Versions Compared

Old Version 40

changes.mady.by.user Noreen Dertinger

Saved on

compared with

New Version Current

changes.mady.by.user Noreen Dertinger

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

System Profile

System Full Name

CAWIS Mail Distribution Module

System Full Name (French)

SWIMN Module de distribution du courrier

Business Administrator

Lauren McMahon

Business Owner

Jenny Young

Director

Philippe Ngassam

Subject Matter Expert

Civil Aviation Maintenance Team
Original SME was Alexandre Bédard

Team Avro Arrows

Division

National Aircraft Certification

NTARS Code

CA60(?)

Source Location

Source Code Location

http://tfsprod:8080/tfs/civav/CAWIS-WAAU/_dashboards

Migration to DevOps

  •  

New Source Code Location (DevOps)

https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CAWIS-MDM

Technology Assessment

Platform Type

Console

Database Platform and Version

Oracle 18c

Development Language and Framework

VB.NET

Operating System and Version

Windows Server 2016

Additional Dependencies

TC Mailer, RightFax, EPPlus (Nuget)

Authentication

None

Environment Access Information

*WWWFILES and URL are not applicable for CAWIS-MDM

ENV

UNC
Content of both options confirmed to be identical on
February 10, 2023

WWWFILES

URL

Log files

Current logs are in a file called
output.log in the root of the UNC path for the affected environment.

When the log reaches a certain size they are moved to the “logs” folder. For older issues check the output logs in the logs folder.

DB

DEV

\\tcwebscriptstest\Scripts\CivAv\CAWIS-MDM (Dev)

OR

\\ncrws514\Scripts\CivAv\CAWIS-MDM (Dev)

n/a as this is a middleware.

The associated Mailing functionality is accessed via CAWIS

CAWISD

PREACC

n/a

n/a

n/a

PREACC_CA

ACC

\\tcwebscriptstest\Scripts\CivAv\CAWIS-MDM

OR

\\ncrws514\Scripts\CivAv\CAWIS-MDM

n/a as this is a middleware.

The associated Mailing functionality is accessed via CAWIS

CAWISA

PROD

\\tcwebscripts\scripts\CivAv

/a as this is a middleware.

The associated Mailing functionality is accessed via CAWIS

\CAWIS-MDM

OR

\\ncrws548\scripts\CivAv\CAWIS-MDM

CAWISP

TRAINING

System Overview

<--->

Good To Know

CAWIS MDM is a mission critical application. It is used to send aviation safety information on a national and international basis. Problems distributing the emails can generate an aviation safety incident.

CAWIS stands for Continuing Airworthiness Web Information System

...


The following section, “General troubleshooting” provides an overview of the steps to take when investigating an issue with the CAWIS MDM Application. Links with more in-depth details about how issues have been resolved to-date, are also provided.


General troubleshooting

Contact list for the contacts mentioned below

Current update, Jan 2023 regarding who to contact:

...

  1. Check the log file for the environment that is affected. The current The current log file is called “output.log”. They are located in the UNC locations listed in the Environment access information at the beginning of this document. 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.

...

Environment

...

Development

...


...

\\ncrws514\Scripts\CivAv\CAWIS-MDM

...

Production

...

\\ncrws548\scripts\CivAv\CAWIS-MDM\


  1. 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

  2. If there’s no logs being generated => the task isn’t running
    For support on the web application contact the web group for diagnostic or server restart.

    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.

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

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

    • 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.”

  4. If there’s 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”.

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

    1. Open a command prompt and type “net “net user DNRENAC /domain“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 Dehaibi assisted with this.

    2. The password for DNRENAC is in PINS. It is set to “never expire”. If the password does get changed for any reason the database table TR47_CAWIS_GENERAL_PROPS also needs to be updated. See also:
      Resetting/Updating AAIR inbox password - BSD - Civil Aviation - Confluence (atlassian.net)