My Oracle Support Banner

'Unexpected token in statement...' Or 'Reverse table ... for model ... already exists' Message When Testing The Connection To An XML File With The ODI XML Driver (Doc ID 423870.1)

Last updated on FEBRUARY 20, 2018

Applies to:

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

Symptoms

Although XML instances of the DTD (or XSD) are well-formed and valid, the following message is received when using Oracle Data Integrator (ODI) and either:

0 : null : java.sql.SQLException: ... a class java.sql.SQLException occurred and said: java.sql.SQLException: java.sql.SQLException: Unexpected token in statement [select ...

   == or == (in the case of an XSD file that contains an element called ORDERS)

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Reverse table ORDERS for model TEST_XML already exists.
  at com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:1204)
  at com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:1569)
  at com.sunopsis.graphical.frame.edit.EditFrameSnpModel$7.doInBackground(EditFrameSnpModel.java:2566)
  at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker$1.call(SwingWorker.java:240)

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.