ODI "XML Schema fails on the target connection" and "ODI-40706: This schema doesn't exist"
(Doc ID 2330294.1)
Last updated on FEBRUARY 07, 2022
Applies to:
Oracle Data Integrator - Version 12.1.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
When executing a job in Oracle Data Integrator (ODI) that uses an XML connection, the following error message is thrown:
ODI-1228: Task Procedure-<PROC_XML_SAMPLE_DATA>-Truncate XML Schema fails on the target connection <XML_SAMPLE_DATA_FILE>.
Caused By: java.sql.SQLException: ODI-40706: This schema doesn't exist: <XML_SAMPLE_OTHER_DATA>
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.internalExecute(SnpsXmlConnection.java:605)
at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.preprocessStatement(SnpsXmlConnection.java:1417)
at com.sunopsis.jdbc.driver.xml.SnpsXmlStatement.execute(SnpsXmlStatement.java:30)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:141)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
...
The issue may also surface as an intermittent issue, depending on the design.
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 |