"SnpsXmlUnknownNSPrefixException:xml" Exception Is Received When Creating An XML Data Server In ODI

(Doc ID 2320518.1)

Last updated on APRIL 10, 2018

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

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

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