"java.sql.SQLException" Or "class java.lang.NullPointerException" Messages Signaled When Parallel Integration Interfaces Are Executed With XML Source Files (Doc ID 424767.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

When running simultaneous Oracle Data Integrator (ODI) Integration Interfaces set up using the ODI XML Driver with different XML source files, random errors are signaled during the 'Synchronize XML' or 'Truncate schema' commands:

java.sql.SQLException: CREATE expected
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.b(SnpsXmlConnection.java)
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.e(SnpsXmlConnection.java)

or

java.sql.SQLException: LOAD expected
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.b(SnpsXmlConnection.java)
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.e(SnpsXmlConnection.java)

or

java.sql.SQLException: SET expected
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.b(SnpsXmlConnection.java)
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.e(SnpsXmlConnection.java)

or

class java.lang.NullPointerException said null
java.sql.SQLException: class org.xml.sax.SAXException
class java.lang.NullPointerException said null
at com.sunopsis.jdbc.driver.xml.u

or

java.sql.SQLException: SYNCHRONIZE expected
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.b(SnpsXmlConnection.java)
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.e(SnpsXmlConnection.java)

or

java.sql.SQLException: Table not found: TT_..... in statement [delete from TT_......]
at com.sunopsis.jdbc.driver.xml.bz.execute(bz.java)
at com.sunopsis.jdbc.driver.xml.ca.execute(ca.java)

Cause

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 hundreds of Community platforms