My Oracle Support Banner

"QUERY_TIMEOUT: Your query request was running for too long" and "INVALID_QUERY_LOCATOR: invalid query locator in statement" Errors Intermittently Received when Running an ODI Mapping to Load Data from Salesforce to Autonomous Data Warehouse (ADW) (Doc ID 2914080.1)

Last updated on DECEMBER 12, 2022

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Oracle Data Integrator - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Using an Oracle Data Integrator (ODI) Mapping to load data from Salesforce to Autonomous Data Warehouse (ADW) fails with below error messages:

 

 

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!


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