ODI 12c Salesforce Mapping Fails with "Java.sql.SQLSyntaxErrorException: [FMWGEN][SForce JDBC Driver][SForce]Table not found in statement" (Doc ID 2589608.1)

Last updated on AUGUST 20, 2020

Applies to:

Symptoms

In Oracle Data Integrator (ODI) 12c, a mapping uses a Salesforce table as a source and to populate an Oracle table. It fails with error message:

ODI-1227: Task Insert new rows-LKM SQL to Oracle (Built-In)-Load <TABLE> fails on the source connection <SALESFORCE_CONNECTION>.
Caused By: java.sql.SQLSyntaxErrorException: [FMWGEN][SForce JDBC Driver][SForce]Table not found in statement [SELECT
<TABLE_ALIAS>.ROWID AS ROWID_ ,
<TABLE_ALIAS>.VALUE1 AS VALUE1 ,
<TABLE_ALIAS>.VALUE2 AS VALUE2 ,
<TABLE_ALIAS>.VALUE3 AS VALUE3 ,
..
FROM
<SALESFORCE_SCHEMA>.<SALESFORCE_TABLE> <TABLE_ALIAS>
]
  at weblogic.jdbc.sforcebase.ddcn.b(Unknown Source)
  at weblogic.jdbc.sforcebase.ddcn.a(Unknown Source)
  ...

Cause

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