Page Comparison

System Profile

...

System Overview

<--->

Good To Know

A single emailing can contain up to 20,000+ emails.

MDM does the following steps to manage Mailbox size as the Mailbox cannot exceed its 2 gig size limit otherwise replies (bounce-back messages) will be lost:

• All processed messages are move to the MDMBounced folder and subsequently deleted at the end of the run

• Using BCC, MDM sends one message to 500 recipients every 60 seconds.  The MDM process continues until all emails have been sent.  Concurrently MDM is checking for and processing any bounce back responses as follows.  

  • The responses in the inbox are loaded into a list.

  • Each response in that list is processed and then moved from the Inbox to the MDMBounced folder.

  • When the end of the list is reached all messages in the MDMBounced folder are deleted, freeing up the space.

  • This entire process takes less than 15 seconds to complete.

  • If the MDM process is still running (as it continues to send out messages every 60 seconds until all message are sent) then this cleanup process restarts every 60 seconds.

How-To and Fixes

See also. for detailed MDM repair information and history: MDM OUTAGES - BSD - Civil Aviation - Confluence (atlassian.net)

e-mail

...

notifications regarding expiration of the AAIR inbox password

See also

CAWIS DevOps task: 235611 CAWIS Airworthiness Directive (AD) Distribution
Bug 235611: CAWIS Airworthiness Directive (AD) Distribution - Boards (azure.com)

CAWIS DevOps task 240218 CAWIS AD Distribution MDM not functional
Bug 240218: CAWIS AD Distribution MDM not functional - Boards (azure.com)

...

1. In the table TR47_CAWIS_GENERAL_PROPS:
   
   First, backup the existing password/encryption info

   UPDATE TR47_CAWIS_GENERAL_PROPS A SET A.PROPERTY_VALUE =
   (SELECT PROPERTY_VALUE FROM TR47_CAWIS_GENERAL_PROPS B
   WHERE B.PROPERTY_NAME = 'MDM - MAILBOX PASSWORD' )
   WHERE PROPERTY_NAME = 'MDM BACKUP - LAST KNOWN PASSWORD';

   UPDATE TR47_CAWIS_GENERAL_PROPS SET PROPERTY_VALUE =
   (SELECT PROPERTY_VALUE FROM TR47_CAWIS_GENERAL_PROPS B
   WHERE B.PROPERTY_NAME = 'MDM - MAILBOX PASSWORD SECRET' )
   WHERE PROPERTY_NAME = 'MDM BACKUP - LAST SECRET ENCRYPTION';

   then, null out the encryption key

   UPDATE TR47_CAWIS_GENERAL_PROPS SET PROPERTY_NAME = NULL
   WHERE PROPERTY_NAME = 'MDM - MAILBOX PASSWORD SECRET';
   
   Note : most fields (with the exception of “password” ) will be UPPERCASED when saved on the TR47 interface page in CAWIS. This would nullify any benefits of backing up up the old encrypted password at this point.

Clearing the value of “MDM - MAILBOX PASSWORD SECRET” is to tell MDM that the password is unencrypted. (Do not remove the row).

a. Set the value of “MDM - MAILBOX PASSWORD” to the new, unencrypted password.

b. Set the value of “MDM - MAILBOX PASSWORD LAST CHECK DATE to SYSDATE + 2”. This will ensure that MDM does the password change two days after the reset (you have to wait a day to do another password change)

...