My Oracle Support Banner

ODI Salesforce.com Technology Error "The maximum number of web service calls per statement has been exceeded" and "ExecutionEngineException" In ODI 12c When Loading an Entity With Large Number of Records into Oracle (Doc ID 2262059.1)

Last updated on MAY 01, 2019

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.com to Oracle in Oracle Data Integrator (ODI) 12.2.1.2.6 or later, the following error occurs.

To reproduce:

  1. Create a mapping loading data from Salesforce.com to Oracle using a Salesforce.com 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

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
Symptoms
Changes
Cause
Solution


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