+ Reply to Thread
Results 1 to 2 of 2

Thread: V7.1 XML Annotation Decomposition Error

  1. #1

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

  2. #2

    Default

    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.

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts