IC73923: SQL STATEMENT FAILS WITH "SQL16132N XML DOCUMENT CONTAINS AN INVALID DOCUMENT STRUCTURE" IF COMMENT FOLLOWS XML DECLARATION

APAR status

• Closed as program error.

Error description

• If you have to insert an XML document into a database and a
  comment is included after the XML declaration in the XML
  document, the execution of the SQL insert statement will fail
  with the following error message logged:
  
   sql-source(SQLDataSource): tid(1234567): Database reported
  query error:
   SQL16132N  XML document contains an invalid document structure.
  SQLSTATE=2200M
  

Local fix

• Remove the comment after the XML declaration, or place the
  comment line anywhere within the document element.
  

Problem summary

• Affected are customers that pass XML as an argument to a
  pepared
  statement using dp:sql-execute - if and only if the XML contains
  a processing instruction or comment before the document element.
  
  
  The XML from the argument will not get serialized
  properly, resulting in a fragment (or no text at all). This has
  the potenial of causing an error at the database which gets
  returned back to the appliance and logged.
  
  The problem happened because of serializing issues for
  processing instructions and comments before the document
  element.
  

Problem conclusion

• Fix is available in 3.8.1.10 and 3.8.2.2.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DATAPOWER

• Fixed component ID

  DP1234567

Applicable component levels

• R381 PSY

     UP

• R382 PSY

     UP