This discussion is archived
2 Replies Latest reply: Jan 29, 2013 7:09 AM by Bos RSS

JMS XML Namespace issue

Bos Pro
Currently Being Moderated
Hi all,

ODI 11.1.1.3.

I have an issue with the LKM JMS XML to SQL. The XML schema is using Namespace (ns0:) prefixing the XML schema name. So when using the LKM JMS XML to SQL, I am getting the following error on the "Load JMS to XML" step:

"ODI-1227: Task SrcSet0 (Loading) fails on the source JMS_QUEUE_XML connection Bos_Vendor.
Caused By: java.sql.SQLException: class org.xml.sax.SAXException
Root element ns0:VendorBaseDataChangeNotification doesn't match the DTD".

If I change the LKM to Ignore errors for this step, then all other steps of the LKM work fine, including 'Load Data' from the XML to C$ and I have SYNCHRO_JMS_TO_XML = 'true' so that the schema should truncate before hand. (which also works fine).

We are not using LDAP JNDI and the source JMS QUEUE is tibco.

Any help would be appreciated on the is!!


Thanks

Bos

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points