My Oracle Support Banner

ODI-40799: Root element "xml2sql" of XML file doesn't match the DTD/XSD element with name "TRANSACTION_SET" from namespace "" set as root element (Doc ID 2607672.1)

Last updated on NOVEMBER 05, 2019

Applies to:

Oracle Global Trade Intelligence Cloud Service - Version 19.3 and later
Oracle Transportation Management Cloud Service - Version 19.3 and later
Oracle Global Trade Management Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

Data transfer from OTM/GTM to Oracle Analytics Cloud (OAC) using ODI, fails with the following error.

org.xml.sax.SAXException: ODI-40799: Root element "xml2sql" of XML file doesn't match the DTD/XSD element with name "TRANSACTION_SET" from namespace "" set as root element
at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(SnpsXmlFile.java:508)
at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(SnpsXmlFile.java:536)
at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.synchronizeFromFile(SnpsXmlFile.java:705)
at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.(SnpsXmlFile.java:125)
at com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.(SnpsXmlSchema.java:530)
at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.createNewSchema(SnpsXmlSchemaManager.java:316)
at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.getSchemaFromProperties(SnpsXmlSchemaManager.java:293)
at com.sunopsis.jdbc.driver.xml.SnpsXmlDriver.connect(SnpsXmlDriver.java:142)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:110)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at com.sunopsis.sql.SnpsConnection.createConnection(SnpsConnection.java:530)
at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:486)
at oracle.odi.runtime.agent.execution.SessionExecutor.changeIsolationLevel(SessionExecutor.java:1076)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.createSrcTargetConnectionsInFixedOrder(AbstractSessionTask.java:1765)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.getCollectDwgConnectConnection(AbstractSessionTask.java:781)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.getCollectDwgConnectConnection(AbstractSessionTask.java:752)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:147)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)



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


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