"ExecutionEngineException" and "The maximum number of web service calls per statement has been exceeded" In ODI 12.2.1.2.6 When Copying an Entity With Thousands of Records From Salesforce.com To Oracle (Doc ID 2262059.1)

Last updated on MAY 15, 2017

Applies to:

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

Symptoms

When attempting to load thousands of rows from Salesforce to Oracle in ODI 12.2.1.2.6, the following error occurs.

The issue can be reproduced at will with the following steps:

  1. Create a mapping loading data from Salesforce to Oracle using a Salesforce source that has more 4000 rows
  2. Set filter to %, notice the error
  3. Set filter to A% (effectively loading only a few rows), notice that the execution is successful.

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