"Invalid object name" Error when Executing in ODI 12c Mappings Upgraded from ODI 11g

(Doc ID 2305889.1)

Last updated on DECEMBER 14, 2017

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 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.dbo.TABLE1'.
  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)
  ...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms