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 19, 2023
Applies to:Oracle Data Integrator - Version 184.108.40.206.6 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
When attempting to load thousands of rows from Salesforce.com to Oracle in Oracle Data Integrator (ODI) 220.127.116.11.6 or later, the following error occurs.
- Create a mapping loading data from Salesforce.com to Oracle using a Salesforce.com source that has more 4000 rows
- Set filter to %, notice the error
- Set filter to A% (effectively loading only a few rows), notice that the execution is successful.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!