2 Replies Latest reply on Jan 29, 2013 3:09 PM by Bos

    JMS XML Namespace issue

      Hi all,


      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!!