Table – DiM-MessageHistory

Purpose

Tracks which messages were successfully transmitted to their intended recipients.

Definition

CREATE TABLE [dbo].[DiM-MessageHistory](
	[MessageGUID] [UNIQUEIDENTIFIER] NOT NULL,
	[QueuedOn] [DATETIME2](7) NOT NULL,
	[MessageQueueGUID] [UNIQUEIDENTIFIER] NOT NULL,
	[Sender] [VARCHAR](500) NULL,
	[Recipient] [VARCHAR](500) NULL,
	[Subject] [VARCHAR](500) NULL,
	[ProcessedOn] [DATETIME2](7) NOT NULL,
	[Result] [VARCHAR](500) NOT NULL,
 CONSTRAINT [PK_MessageHistory] PRIMARY KEY CLUSTERED 
(
	[MessageGUID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

Column Definition

As per the DiM-Messages table with the following additions:

Result should be ‘SUCCESS’ or otherwise indicate a success transfer depending on the decoupling service implementation (could be a transmission receipt for example).

ProcessedOn contains the timestamp of when the transfer was successfully processed.

The BodyFormat and BodyContent are not preserved if the message was successfully processed.

Updated on November 24, 2022

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support

Leave a Comment