Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

V7.1 XML Annotation Decomposition Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    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.

    Comment

    Working...
    X