"Invalid object name" Error when Executing in ODI 12c Mappings Upgraded from ODI 11g
(Doc ID 2305889.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 12.1.2.0.0 to 12.2.1.3.0 [Release 12c]Information in this document applies to any platform.
Symptoms
After upgrading from Oracle Data Integrator (ODI) 11g to ODI 12.2.1.2.6, some mappings fail to execute.
These mappings contain SQL sub-queries based on the target table.
The execution fails with the error below:
ODI-1228: Task Insert flow into I$ table-IKM MSSQL Incremental Update- fails on the target connection <CONN_NAME>.
Caused By: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name '<SCHEMA_NAME>.dbo.<TABLE_NAME>'.
at weblogic.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcv.a(Unknown Source)
...
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |