My Oracle Support Banner

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

Applies to:

Oracle Data Integrator - Version 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(
   at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.preprocessStatement(
   at com.sunopsis.jdbc.driver.xml.SnpsXmlStatement.execute(
   at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(
   at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(
   at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(

The issue may also surface as an intermittent issue, depending on the design.




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

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