ODI "XML Schema fails on the target connection" and "ODI-40706: This schema doesn't exist"
(Doc ID 2330294.1)
Last updated on DECEMBER 18, 2017
Oracle Data Integrator - Version 22.214.171.124.0 and later Information in this document applies to any platform.
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.
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