Connection Error "The internally generated remote query is too long" in ODI When Using Safesforce Driver

(Doc ID 2406828.1)

Last updated on JUNE 12, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When using Salesforce as connection in Oracle Data Integrator (ODI), the generated internal query could be very long, over 10000 characters. If so, the following error is returned:

Changes

 

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