"unknown Token: [XML SCHEMA NAME]" or "user lacks privilege or object not found: [TABLE NAME]" Received in ODI 12c when Unique Names Mechanism Is Used with XML
(Doc ID 2709742.1)
Last updated on JUNE 08, 2023
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 and later
Oracle Data Integrator on Marketplace - Version 126.96.36.199.200123 and later
Information in this document applies to any platform.
The following error is encountered intermittently when executing an Oracle Data Integrator (ODI) 12c Mapping that uses the Unique Names mechanism, and writes data to XML:
In the ODI Studio > Topology > definition of XML Technology > "Advanced" tab, set the "Maximum Table Name Length" to any value.
Execute the Mapping, and observe that the execution succeeds without any error message.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!