Understand column structure of a rejected message

The column structure and order of a message in the RejectedMessages.Messages array is provided here to allow you to set up processing of rejected messages. The message in the array is formatted in JSON.

• The timestamp of the rejected message in the local time where the object is running

• The XML error message returned by the MES middleware

• The XML message that was originally submitted

• The timestamp of the rejected message, in UTC

• The status of the rejected message after originally being submitted to the MES database:

  • 0 = Never submitted before

  • 1 = Resubmitted with error

  • 2 = Resubmitted with success

  • 3 = Edited and resubmitted with error

  • 4 = Edited and resubmitted with success

• The name of the object that submitted the original message

• The name of the object section from where the message was initiated

• The region from where the original message was initiated

• The message locale

• The message version

• A comment about the last edit made to the rejected message record, if one was provided

• Who last edited the rejected message record

• When the rejected message was initially logged or last edited

• The row ID of the rejected message record

An example message is shown below.

[{“rejected_message_local":"2015-10-09 4:14:21 pm",

“xml_error_message":"A row does not exist in util_exec for this entity{3243}”,

"xml_message":"<?xml version='1.0'?><request><object>util_exec</object>

<msgtype>exec</msgtype><cmd>setrawreasonbyname</cmd><session_id>29</session_id>

<ent_name>Roaster</ent_name><raw_reas_cd>Idle</raw_reas_cd>

<new_reas_start_utc>10/9/2015 11:14:21 PM</new_reas_start_utc>

<comments></comments></request>",

"rejected_message_utc":"2015-10-09T23:14:21","message_status":0,

"object_name":"Roaster","object_section":null,

"message_region":"Pacific Standard Time","message_locale":"en-US","message_version":1,

"last_edit_comment":null,"last_edit_by":"oneuser",

"last_edit_at":"2015-10-09 11:14:21 pm","row_id":18}]