PDA

View Full Version : V7.1 XML Annotation Decomposition Error



Guest.Visitor
02-04-2011, 01:03 PM
Got a new project working to receive a XML from a vendor that needed to parse into 2 databases. I tried using the new feature (Annotation Decomposition) available in DB2 V7.1 but ran into a problem. Here's the detail:
1. I modified the XSD from our vendor by adding the required annotation with db2 namespace and the necessary rowset and column definitions.
2. Registered the XSD sucessfully (with XSR_REGISTER and XSR_COMPLETE) in an interactive SQL session.
3. When trying to decompose a test file using [CALL SYSPROC/XDBDECOMPXML ('TESTF', 'BOODRREQ',GET_XML_FILE('/Vendor/In/OrderFulFillmentRequest.xml'), null)] in the interactive session, I ran into an error.

The error says: Trigger program or external routine detected an error.
The log says:
>> strsql
JVM properties were loaded from a properties file.
Java Virtual Machine is IBM Technology for Java. PID(51296)
JVM properties were loaded from a properties file.
SQLDA or descriptor area not valid.
Error occurred during decomposition of XML document *N.
The nested transaction operation failed. Reason code 1.
Trigger program or external routine detected an error.

Can somebody help me to find out what is causing this problem?
Thanks!

Guest.Visitor
02-11-2011, 12:03 PM
A latest update with those who are following this thread. Talked to IBM and found the source of error. It looks like the SQLDA problem (SQL0804) is a problem the internal DB2 XML parser trying to process an empty element into a fixed character column.
Will keep all of you posted on the result.