"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:

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

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