My Oracle Support Banner

Testing an XML JDBC Physical Schema In ODI Studio Fails with "unexpected token: <ELEMENT_NAME>_DELETE" when UseImplicitMaxValue Property is Set to True (Doc ID 2457464.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

After creating a physical schema using the Extensible Markup Language (XML) technology, the "Test Connection" action fails with the following error message when the property "useimplicitmaxvalue" is set to True:

ODI-26039: Connection failed
Java.sql.SQLException: unexpected token: <ELEMENT_NAME>_DELETE

The log file may also write similar to the following:

2018-08-29 14:57:39.912 NOTIFICATION Accepting the XML model and creating the corresponding Relational model
2018-08-29 14:57:40.007 NOTIFICATION Validating model for the XML driver
2018-08-29 14:57:40.078 NOTIFICATION Done validating XML model
2018-08-29 14:57:40.079 NOTIFICATION Creating Relational model
2018-08-29 14:57:40.285 ERROR ODI-40837: An error occurred during the creation of the schema: unexpected token: <ELEMENTNAME>_CREATE
2018-08-29 14:57:40.286 NOTIFICATION Dropping schema
2018-08-29 14:57:40.287 NOTIFICATION Dropping TablesTable

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!


In this Document
Symptoms
Cause
Solution
References


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