My Oracle Support Banner

'SAX Exception In Translator Error' while Configuring Complex File Data Server in ODI 12.1.3 (Doc ID 2464270.1)

Last updated on OCTOBER 31, 2018

Applies to:

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

Symptoms

When trying to test a Complex File data server for a JSON file with an XSD specified for the schema definition, a 'SAX Exception in translator' error occurs.

ODI-26039:Connection failed.
oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: class java.sql.SQLException
oracle.odi.jdbc.driver.xml.io.exception.PipelineStageException: ORABPEL-11210
SAX Exception in translator.
SAX Exception raised while trying to SAX Parse InputStream .
Please make sure that the xml data is valid.
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:336)
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:899)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:688)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1200(SnpsDialogTestConnet.java:51)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:665)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:658)
  at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:947)
  at java.lang.Thread.run(Thread.java:744)

Changes

 

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
Changes
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.