My Oracle Support Banner

"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 to [Release 12c]
Information in this document applies to any platform.


After upgrading from Oracle Data Integrator (ODI) 11g to ODI, 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)




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.