System Profile
System Full Name | Continuing Airworthiness Web Information System - Internal |
System Full Name (French) | Système Web d'information sur le maintien de la navigabilité - Interne |
Business Administrator | Lauren McMahon |
Business Owner | Jenny Young |
Director | Philippe Ngassam |
Subject Matter Expert | Sylvie Blais |
Division | National Aircraft Certification |
NTARS Code | CA60 |
Source Location | |
Source Code Location | |
Migration to DevOps | |
New Source Code Location (DevOps) | https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CAWIS-SWIMN |
Technology Assessment
Platform Type | Web (Internal) |
|---|---|
Database Platform and Version | Oracle 18c |
Development Language and Framework | ASP.NET + VB.NET |
Operating System and Version | Windows Server 2016 |
Additional Dependencies | Crystal Report, TC Mailer, Rightfax |
Authentication | Custom |
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV | \\ncrws499\catcappsx\Saf-Sec-Sur\2\CAWIS-SWIMN | https://catcappsx.tc.gc.ca/Saf-Sec-Sur/2/CAWIS-SWIMN/ | CAWISD | |
PREACC | PREACC_CA | |||
ACC | \\tctestmaster\tcappsroot\Saf-Sec-Sur\2\CAWIS-SWIMN | CAWISA | ||
PROD | CAWISP | |||
TRAINING |
System Overview
The Continuing Airworthiness Web Information System (CAWIS) is a web based multi-faceted application that supports the Continuing Airworthiness Program in Transport Canada to monitor and enhance the safety of Canadian manufactured and/or operated aircraft in Canada.
5008 - Core of CAWIS - nightly feed from CCARCS which loads registered aircraft, owner, make, model, etc
5008 purpose is to distribute information to owners, to send notices to owners regarding any changes to their aircraft, report hours, report accidents, fill it out in AAIR, notify whether there is safety issue on aircraft.
Good To Know
CAWIS Ext
To address security issues, CAWIS has both internal and external websites. This requires some special consideration when migrating code.
The differences between the two versions, are outlined here :
CAWIS Links
NOTE : CAWIS has no database links outside of Transport Canada
CCARCS | CAWIS pulls aircraft information from CCARCS CAWIS pushes contact data to CCARCS (phone numbers, fax numbers, email addresses) |
NACIS | CAWIS pulls Airworthiness data (AMO, Manufacturer, Distributor along with Principal Maintenance Inspectors (PMIs)) |
AMES | CAWIS pulls AME Licence Numbers |
NAPA | CAWIS pulls type certificates for Airworthiness Directives (ADs) |
DAPLS | CAWIS pulls addresses of pilots |
TC Directory | CAWIS pulls TC user information |
BII | CAWIS pushes Airworthiness Directives (ADs) and Service Difficulty Reports (SDRs) to BII. There also ten canned reports and ad hoc reports Power BII or BII - Civil Aviation's Occurrence Statistics in the Data Warehouse + a suite of BI reports |
Linked folder for ADs to host to the web | development production |
WSDRS and CAWIS were two separate systems. SDRS is now a subsystem of CAWIS holding approximately 2,100,000 records |
Slow / Hanging Reports
Project Book Report
The Project Book Summary (Release) reports sets the “last print date” to SYSDATE at the time of execution (LAST_PROJECT_BOOK_PRINT_DATE in table TR47_CAWIS_GENERAL_PROPS). Subsequent report will only return data where the issued date is >= LAST_PROJECT_BOOK_PRINT_DATE, or if there is no issue date (NULL - often the case for IN PROGRESS AMOCs)
⚠ Production CAWISP database and CAWIS user⚠
CAWIS is one of the rare application that has access to the schema owner of its objects (CAWIS@CAWISP.WORLD) and as such, one should be very cautious of what he is doing to avoid changing or corrupting objects. While we do have access to such credentials, it should be noted that we do not have permission to use it to modify anything other than data. Structure changes, such as packages, tables, database links and standalone functions, are banned from being done without the DBA group consent.
Such an issue did arise in 2022, where a developer accidentally change the configuration of one of the database link, thinking he was in the development database. This caused a full outage for three hours and no way of fixing the issue, since the password to the remote database is unknown to us.
How-To and Fixes
AD Document not linking
Check if file properly named
Go to \\ncrws488\tcwwwtest\Aviation\applications\AWD-CN\documents and check if the problematic document is correctly named.
The expected format for AD files is :
Canadian directives:
{AD_NUMBER}-{LANG}.{HTM|PDF}(the country code CF is included as part of the AD number)Foreign directives:
{COUNTRY}{AD_NUMBER}.{HTM|PDF}
Check if the sync script if running
There is a script that copies the files in \\ncrws488\tcwwwtest\Aviation\applications\AWD-CN\documents to :
Internal: \\ncrws539\tcappsroot\Saf-Sec-Sur\2\AwD-CN\documents
External: \\ncrws536\wwwappsroot\Saf-Sec-Sur\2\AwD-CN\documents
Check if the files in the source folder is in both target folder.
Project Book Report & Last Print Date
If the “Last Printed Date” (LAST_PROJECT_BOOK_PRINT_DATE in table TR47_CAWIS_GENERAL_PROPS) gets set to an incorrect date (For instance: Project Book Summary (Release) is executed instead of Project Book Summary (Preview)) it can cause incomplete reports (see note in good to know section above). Users with admin access can change this date through the CAWIS application as follows:
Select “Code Table Admin” under the Admin section in the side menu
Select “General”
Select “General Properties” in the System section
Select “LAST_PROJECT_BOOK_PRINT_DATE”
Change date (Value) and Save
Slow / Hanging Reports (158722)
New reports returning large amounts of data were taking far too long, often timing out before completing. Reports were changed to make use of materialized views which reduced time significantly. Reports generally complete in under 5 minutes.
PLANNED OUTAGES
CAWIS can announce planned outages on the login page by performing the following steps:
login as ADMIN
MAIN MENU → CODE TABLE ADMIN → GENERAL → GENERAL PROPERTIES
MAINTENANCE START → Set Date/time for start of maintenance
MAINTENANCE END → Set Date/time for end of maintenance
The system will lock out all users (except the ADMIN account) during the specified period. The ADMIN account can log into CAWIS at any point and revise the end date if/when a release is completed early. The Out-of-Service period is displayed at the top of every CAWIS screen during the time period leading up to the planned outage.
Add Comment