"ExecutionEngineException" and "The maximum number of web service calls per statement has been exceeded" In ODI 220.127.116.11.6 When Copying an Entity With Thousands of Records From Salesforce.com To Oracle
Last updated on MAY 15, 2017
Applies to:Oracle Data Integrator - Version 18.104.22.168.6 and later
Information in this document applies to any platform.
When attempting to load thousands of rows from Salesforce to Oracle in ODI 22.214.171.124.6, the following error occurs.
The issue can be reproduced at will with the following steps:
- Create a mapping loading data from Salesforce to Oracle using a Salesforce 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.
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