My Oracle Support Banner

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

To reproduce:

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




To view full details, 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 a vibrant support community of peers and Oracle experts.