Hi!
I'm doing a migration to ODI 12c and I have an error on a Reusable mapping. The problem I have following the next steps...:
- I have one reusable mapping with 6 lookups with the match row as Any single value.
- I validate this reusable mapping and it's all okay, nothing wrong.
- In the main mapping it's all fine too, no warnings or errors with the validate option.
- When I run the main mapping a message error appears saying : Exception when invoking: SELECT method in AST processor source for component KM XKM Oracle Lookup when generating source for node: ("THE NAME OF THE LOOKUP OF THE REUSABLE MAPPING").
- The name of the 6 lookups are(Lookup Condition):
· LKP_ETNIES(EXPRESSION.C_ETNIES_MINORITARIES = LKP1_ETNIES_MINORITARIES.C_ETNIES_MINORITARIES )
· LKP_CONVERSIO_PAIS(EXPRESSION.C_PAIS_NAIXEMENT = LKP1__CONVERSIO_PAIS.C_PAIS_DWH )
· LKP_PAIS(EXPRESSION.C_PAIS_NAIXEMENT = LKP0_PAIS.C_PAIS )
· LKP_ANY(EXPRESSION.C_ANY_NAIXEMENT = LKP0_ANY.C_ANY )
· LKP_SEXE (EXPRESSION.C_SEXE = LKP0_SEXE.C_SEXE )
· LKP_DOCUMENT (EXPRESSION.C_CODI_DOCUMENT = LKP1_TIPUS_DOCUMENT.C_TIPUS_DOCUMENT)
· LKP_MUNICIPI(EXPRESSION.C_MUNICIPI_NAIXEMENT = LKP0_MUNICIPI.C_MUNICIPI )
- In this case It fails in the second one, I tried to do it with distinct and putting the match row value as all values, but with this options the main mapping fails with another error: ODI-1228: Task IKM Oracle Update (Load LKP4__PERSONA_PAGAMENTS_UPD) fails on the target ORACLE connection EMO_DHW. Caused By: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected. But the right option is to do it with the any value option.
Can someone help? Thanks!!!