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 12.1.2.0.0 and later
Information 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

	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