Error Message Help

When processing messages with the database communication point, database lookup filter or database query filter, it is possible that one or more of the following errors may occur and the following information will be written to the error log. To help diagnose the problem here is a list of actions you should check in each case.

Failed to extract message content of "message field". Incoming message may
not be valid or repeating message elements may not be properly nested.

• Check the configuration. Ensure the statements are properly nested and all repeating elements are specified by the "iterate" attribute value.
• Check the incoming message using EDI Explorer to ensure it is valid for the specified definition.

• Please note that an XML message field path finishes with either .#PCDATA for an element value or .valuefor an attribute value.

  Error occurred mapping column value.:\- nested message: Unknown error while
  parsing.:\- nested message: Failed to parse input.
  

• Check the incoming message using EDI Explorer to ensure it is valid for the specified definition.

  Can't find order column in result

• The root statement must return the "key" column in its result set. Please include the "key" column in your SELECT query.