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 JUNE 16, 2022

Applies to:

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

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