-
V7.1 XML Annotation Decomposition Error
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!
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules