My Oracle Support Banner

ODI Fails to Load XML File with Error "ODI-1227" and "Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found" (Doc ID 2953899.1)

Last updated on JULY 30, 2024

Applies to:

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

Symptoms

Using Oracle Data Integrator (ODI) 12c to load XML files. Executions fail intermittently with the following error:



To reproduce:

1. Execute a mapping or package that involves loading of XML files
2. Notice the failure

The same execution was working fine previously



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.