"ODI-40786: Prefix not found: {0}xsi" or "ODI-40933: Unable to build XSD from DTD" While Testing the Connection to an ODI XML Data Server
(Doc ID 1501247.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 11.1.1.3.0 and laterInformation in this document applies to any platform.
Symptoms
When testing the connection to an Oracle Data Integrator (ODI) XML Technology Data Server containing xsi:type definition, the following message is thrown:
- In ODI 11g, or when "compat_mode=v2" is set in the URL:
java.sql.SQLException: class java.sql.SQLException
org.xml.sax.SAXException: ODI-40786: Prefix not found: xsi
com.sunopsis.jdbc.driver.xml.model.exceptions.SnpsXmlUnknownNSPrefixException: xsi
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1243)
at ...
...
Caused by: com.sunopsis.jdbc.driver.xml.model.exceptions.SnpsXmlUnknownNSPrefixException: xsi
at com.sunopsis.jdbc.driver.xml.model.ns.SnpsXmlNamespaceManagerBasic.getURI(SnpsXmlNamespaceManagerBasic.java:90)
at com.sunopsis.jdbc.driver.xml.model.ns.SnpsXmlNamespaceManagerFromModel.getURI(SnpsXmlNamespaceManagerFromModel.java:129)
at com.sunopsis.jdbc.driver.xml.model.ns.SnpsXmlNamespaceManagerPrefixStack.getURI(SnpsXmlNamespaceManagerPrefixStack.java:136)
at com.sunopsis.jdbc.driver.xml.model.ns.SnpsXmlNamespacedObjectManager.getQualifiedName(SnpsXmlNamespacedObjectManager.java:68)
at com.sunopsis.jdbc.driver.xml.model.SnpsXmlTypeAbstract.getAttr(SnpsXmlTypeAbstract.java:112)
at com.sunopsis.jdbc.driver.xml.model.SnpsXmlModelElt.getAttr(SnpsXmlModelElt.java:353)
at com.sunopsis.jdbc.driver.xml.data.SnpsXmlLoader.matchAttrToAttrFromXSDModel(SnpsXmlLoader.java:112)
at com.sunopsis.jdbc.driver.xml.data.AbstractXmlLoader.handleAttributes(AbstractXmlLoader.java:299)
... 30 more - In ODI 12c, or when "compat_mode=v3" is set in the URL:
java.sql.SQLException: ODI-40933: Unable to build XSD from DTD.
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1243)
...
Caused by: java.sql.SQLException: ODI-40933: Unable to build XSD from DTD.
at com.sunopsis.jdbc.driver.xml.SnpsXmlDTD.initialize(SnpsXmlDTD.java:371)
...
Caused by: java.lang.ArrayIndexOutOfBoundsException: 4
at oracle.xml.parser.v2.DTD2SchemaBuilder.getElementDecls(DTD2SchemaBuilder.java:175)
at oracle.xml.parser.v2.DTD.convertDTD2Schema(DTD.java:585)
at com.sunopsis.jdbc.driver.xml.SnpsXmlDTD.initialize(SnpsXmlDTD.java:367)
...
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 |