"SnpsXmlUnknownNSPrefixException:xml" Exception Is Received When Creating An XML Data Server In ODI (Doc ID 2320518.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

An XML file contains explicit references to the standard XML Namespace such as:

xml:lang=...
xml:space=...

The following error is observed when creating the corresponding XML Data Server in the Oracle Data Integrator (ODI) Topology and applying the changes:

java.sql.SQLException: class java.sql.SQLException com.sunopsis.jdbc.driver.xml.model.exceptions.SnpsXmlUnknownNSPrefixException:xml
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
  at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1125)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:163)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$4(SnpsDialogTestConnet.java:159)
Caused by: java.sql.SQLException: class java.sql.SQLException com.sunopsis.jdbc.driver.xml.model.exceptions.SnpsXmlUnknownNSPrefixException:xml
  at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(SnpsXmlFile.java:464)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.readDocument(SnpsXmlFile.java:474)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.synchronizeFromFile(SnpsXmlFile.java:649)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.<init>(SnpsXmlFile.java:117)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.<init>(SnpsXmlSchema.java:498)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.createNewSchema(SnpsXmlSchemaManager.java:296)

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.