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:
Oracle Data Integrator - Version 12.2.1.3.0 and laterInformation 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 |