Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 MESSAGEBODY nvarchar(max)   Default = '' The content of the workflow queue message
 MESSAGETYPE nvarchar(128)   Default = ''
 CONVERSATION_GROUP_ID uniqueidentifier   The service broker conversation group id of the message.
 ERRORMESSAGE nvarchar(max)   Default = '' The error message reported.
 ERRORDETAILS nvarchar(max)   Default = '' A detailed error message including stack trace information.
 ERRORDATE datetimeoffset   The date that the error occured.
 RESENTDATE datetimeoffset The date that the message was resent to the queue.
 ORIGINAL_CONVERSATION_HANDLE uniqueidentifier   The service broker conversation handle of the original message.
 RESENT_CONVERSATION_HANDLE uniqueidentifier The service broker conversation handle of the resent message.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 BBWORKFLOWINSTANCEINFOID uniqueidentifier BBWORKFLOWINSTANCEINFO.ID FK to BBWORKFLOWINSTANCEINFO
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_BBWORKFLOW_QUEUEMESSAGE_ERROR_CONVERSATION_GROUP_ID CONVERSATION_GROUP_ID      
 IX_BBWORKFLOW_QUEUEMESSAGE_ERROR_DATEADDED DATEADDED    
 IX_BBWORKFLOW_QUEUEMESSAGE_ERROR_DATECHANGED DATECHANGED      
 IX_BBWORKFLOW_QUEUEMESSAGE_ERROR_ERRORDATE ERRORDATE      
 IX_BBWORKFLOW_QUEUEMESSAGE_ERROR_ORIGINAL_CONVERSATION_HANDLE ORIGINAL_CONVERSATION_HANDLE      
 IX_BBWORKFLOW_QUEUEMESSAGE_ERROR_RESENT_CONVERSATION_HANDLE RESENT_CONVERSATION_HANDLE      
 PK_BBWORKFLOW_QUEUEMESSAGE_ERROR ID  

Trigger Name Description
 TR_BBWORKFLOW_QUEUEMESSAGE_ERROR_AUDIT_UPDATE
 TR_BBWORKFLOW_QUEUEMESSAGE_ERROR_AUDIT_DELETE

Entity-Relationship diagram of this table