1. Home
  2. Data
  3. Record Storage Services
  4. Data in Motion Tables
  5. Table – DiM-MessageFailures
Searching...

Table – DiM-MessageFailures

Contents

Purpose

Tracks all messages that could not be delivered to their intended recipients.

Can be used to re-try the transmission of the message at a later date.

Definition

CREATE TABLE [dbo].[DiM-MessageFailures](
	[MessageGUID] [UNIQUEIDENTIFIER] NULL,
	[QueuedOn] [DATETIME2](7) NULL,
	[MessageQueueGUID] [UNIQUEIDENTIFIER] NULL,
	[Sender] [VARCHAR](500) NULL,
	[Recipient] [VARCHAR](500) NULL,
	[Subject] [VARCHAR](500) NULL,
	[BodyFormat] [VARCHAR](10) NULL,
	[BodyContent] [TEXT] NULL,
	[Result] [TEXT] NULL,
	[ProcessedOn] [DATETIME2](7) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Column Definition

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

Result details why the transfer failed.

ProcessedOn contains the timestamp of when the failure occured.

Updated on November 24, 2022

Was this article helpful?

Yes No

About The Author

Tony Nicholls

Building application systems with 100% of the desired requirements with only a fraction of the cost, time, and risk. This is the problem Tony has been working to solve for more than 35 years. Starting his career in the UK military sector, he has been developing highly secure, scalable, and robust applications since 1985. He has been relentless in finding innovative ways to build new applications. This has come to a pinnacle with trellispark, which eliminates 90% of the costs and effort of application development without compromising on quality, scalability, or security. Tony leads our innovation center of excellence and development teams. His Data Agnostic Services vision has sparked a movement that shakes the traditional assumptions of software development.

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