My Oracle Support Banner

"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 12.2.1.3.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

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:

 
  • Ensure that neither the Mapping, nor the Agent executing the Mapping uses **Unique Names**.

    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.

    • 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.