Geeting "Failed to translate JSON to XML. ParseError at [row,col]:[-1,-1]" Error During Testing Nxsd Through ODI Using Complex File Technology (Doc ID 3040878.1)

Last updated on AUGUST 13, 2024

Applies to:

Symptoms

Customer is getting the following error while testing the nxsd while generating from json file using ODI Native Format Builder.

ERROR
-----------------------
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-15235

Translation Failure.
Failed to translate JSON to XML. ParseError at [row,col]:[-1,-1]
Message: Cannot read attribute: element has children or text
The incoming data does not conform to the NXSD schema. Please correct the problem.

at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:483)
at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1996)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:1080)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$12.doInBackground(SnpsDialogTestConnet.java:1038)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
at java.lang.Thread.run(Thread.java:748)

Cause

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