Share via

IntegrationEntityMessageStatus

  • Article

The IntegrationEntityMessageStatus table contains information regarding the current processing state for a specific message in a specific channel. A message can go through multiple channels, so there is an entry for each MessageID/OriginationChannel pair.

Warning   Modifying this table could cause malfunctions in the integration process.

Column Description
ID A unique identifier for the record.
MessageID The message ID from IntegrationMessage.MessageID.
OriginationChannel The name of the BizTalk channel this message is traveling in.
RetryCount This field usually indicates how many times the message has been resent to the channel.
State The state of the current message.

Values:

1 - Failed

11 – Failed, because the message expired

2 - Ignored

3 – Message posted successfully

4 - Currently posting message

5 - Waiting to be retried

51 - Pre-retry state, waiting to be moved to 5 (Retry)

6 - Submitted to integration
InitialRetry The timestamp of the first attempt to send the document to the channel. When a document expires, this timestamp is used to determine whether it is too old.
Priority Indicates an ordering of messages other than by IntegrationMessageDetails.Timestamp or IntegrationTimestamp. A lower priority value is processed before a higher value.

This field is not used for Microsoft CRM messages, only for Microsoft Great Plains messages.