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.
It seems that this was to do with the XML parser- the ODI parser is only single pass so does not handle DTD's which have complex types (multi pass). Oracle assure me that this will be fixed in the future...