Page Comparison

System Profile

...

• All members of the maintenance team, including the product owner, have been added to an automated process that will send an email when the AAIR /RAINA (TC) password will expire within 10 days.
  
  
  
  Note: we had hoped to be able to provide the team distribution list (Team Avro Arrows). Unfortunately, the initial test email that was not distributed. Our contact, Robert Lang, also tested using the distribution list for the team he is a member list. That did not work either. He advised that the email is possibly being flagged as a “mass email” (spam) when the distribution list is used.
  
  For that reason, the contact information is listed individually.
  
  The current recipients are listed below.
  
  Team lead:
  alain.asgill@tc.gc.ca   ASGILLA
  
  Product owner:

• kelly,haynes@tc.gc.ca HAYNESA
  
  
  Developers:

• phuong.nguyen@tc.gc.ca  NGUYEPH

• riadh.said@tc.gc.ca     SAIDR  

• christopher.collins@tc.gc.ca  COLCHRI

• haoyuan.wang@tc.gc.ca   WANGHA  

• rajesh.shah@tc.gc.ca    SHAHR  

• hiren.amin@tc.gc.ca     AMINH  

• siamak.shirzad@tc.gc.ca SHIRZAS

• sufyan.maghur@tc.gc.ca  MAGHUSU

• noreen.dertinger@tc.gc.ca  DERTINN
  The Business client also receive these emails.
  
  
  The process will send an email once everyday until the password is reset.
  
  Example:
  

  Image Removed

  
  

  Image Added

AAIR inbox inbox access:

• alain.asgill@tc.gc.ca   ASGILLA

• phuong.nguyen@tc.gc.ca  NGUYEPH

• riadh.said@tc.gc.ca     SAIDR  

• christopher.collins@tc.gc.ca  COLCHRI

• haoyuan.wang@tc.gc.ca   WANGHA  

• rajesh.shah@tc.gc.ca    SHAHR  

• hiren.amin@tc.gc.ca     AMINH  

• siamak.shirzad@tc.gc.ca SHIRZAS

• sufyan.maghur@tc.gc.ca  MAGHUSU

• noreen.dertinger@tc.gc.ca  DERTINN
   have been granted full permission and send as to TC.AAIR-RAINA.TC@tc.gc.ca 
  
  

• These permissions take min 24 hrs to apply at which time mailbox

  can be added using instructions located in Knowledge base

  article https://orion.tc.gc.ca/dwp/app/#/knowledge/KBA00002102/rkm
  
  The following users already had access to the inbox previously:

  Image Added

   

To fix the AAIR Password issue

1. Log an Orion ticket using the Orion “Report an issue” category:

...

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)

...