Page Comparison

System Profile

...

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)

...

1. Check the log at \\ncrws548\scripts\CivAv\CAWIS-MDM\.
   Note: The log files are automatically rotated when they hit a certain size. You may need to look in the “logs” folder if the problem happened a while ago.
   If there’s no logs being generated => the task isn’t running :

   1. Contact the group responsible for the server for diagnostic or server restart.
      Current update, Jan 2023 regarding who to contact:

      For support on the web application contact the web group.
      For a production issue with the web application, open an ORION ticket to the attention of the web server group so that they can work on and document the issue.
      
      

   2. If the process seems to be looping the same messages => One of the thread in stuck:

      1. You can wait for the deadlock-prevention timer (2hr) to kick in.

      2. OR contact the group responsible for the server to kill the task.
         
         Per Marcin on Jan 27, 2023: “the deadlock issues we had we back in 2020 and for those you need to contact Oracle dba group.”
         

   3. If there’s a message like “Application is disabled due to database configuration.“ => The application is disabled

      1. In the TR47 table in the CAWIS database, set the configuration called “MDM - APPLICATION ENABLE” to “true”.
         

   4. If there’s a message like “exchange server is unreachable.“ => The email account might be locked.

      1. Open a command prompt and type “net user DNRENAC /domain“. In the response, you should get something like below:

         

         If the line “Account active” says “Locked” or “No”, contact the Service Desk for them to reactivate the account. To-date, most recently in Jan 2023, Robert Lang and Muhammad Duhabei assisted with this.

• The MDM inbox/account is called DNRENAC. Currently, it’s password is auto updated every 80 days, by the MDM process on the script server at \ncrws548\scripts\CivAv\CAWIS-MDM Again, log files in the “Log” directory will tell you exactly when the process began failing