Canadian Civil Aviation Register Computer System Evolution (CCARCSE)
- Michelle Coelho de Oliveira
- kurt.martin
(CCARCSE) #
Developer's Guide
How to Fix CCARCSE Issues
Oct 2014
- 1 Table of Contents
- 1.1 Introduction
- 1.2 Sys-Admins
- 1.3 Development Environment and Tools
- 1.4 Databases
- 1.4.1 Development
- 1.4.2 Acceptance
- 1.4.3 Testing
- 1.4.4 Production
- 1.5 Other Useful Links
- 1.6 CCARCSE Nightly Job
- 1.7 Logging on – Which Database is used
- 1.8 Current Status
- 1.9 Most Frequent Problems
- 1.9.1 0. Where to find the scripts<a name="Wheretofind"></a>
- 1.9.2 1. A user needs their password reset and account unlocked.<a name="Unlock"></a>
- 1.9.3 2. Change in a Common Name
- 1.9.4 3. Un-Cancel a Cancelled Registration<a name="Uncancel"></a>
- 1.9.5 4. Unexpire a reserved Mark.<a name="Unexpire"></a>
- 1.9.6 5. Unsuccessful of a resurrection of an aircraft<a name="Unsuccessful"></a>
- 1.10 Good To Know
Table of Contents
Introduction
This document describes the structure of CCARCSE, most likely problems, most likely fixes and other details pertinent to CCARCSE. CCARCSE is the Canadian Civil Aviation Registry Computer System – Evolution program. It's a national client server app that enables the users to
Enter personal tombstone information about individual owners;
Enter company tombstone information about companies;
Enter aircraft makes, models, standards and specific aircraft;
Reserve and issue marks, register aircraft and lease aircraft;
Print letters, leases and certificates of registration.
Sys-Admins
Chris McCue, (613) 998-3684
Craig Dennis, (613) 990-9490
Development Environment and Tools
Powerbuilder 12.5
Team Foundation Server on Visual Studio for Source Control
Microsoft Visual Studio Team Foundation Server 2010 MSSCCI Provider 32-bit for Source Control
Databases
Canadian Civil Aviation Registration System
Development
CCARCSD.WORLD =
(DESCRIPTION =
(ADDRESS\_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcdevpkgb)(PORT = 1522))
)
(CONNECT\_DATA = (SID = CCARCSD)(SERVER = DEDICATED))
)Acceptance
CCARCSA.WORLD =
(DESCRIPTION =
(ADDRESS\_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcdevpkgb)(PORT = 1523))
)
(CONNECT\_DATA = (SID = CCARCSA)(SERVER = DEDICATED))
)Testing
CCARCST.WORLD =
(DESCRIPTION =
(ADDRESS\_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcdevpkgb)(PORT = 1523))
)
(CONNECT\_DATA = (SID = CCARCST)(SERVER = DEDICATED))
)Production
Passwords not included due to security
Other Useful Links
CCARCSE System Guide | |
CCARCSE User Manual – lets you use the application as a user | |
CCARCSE Addendum to the User Manual – the 'what if's not included in the User Manual | |
CCARCSE Administrator's Guide - extras | |
CCARCSE Nightly Job – Unix Code | |
CCARCSE Feed to Search and Rescue – if the Search and Rescue fails or needs modification |
CCARCSE as a Picture
CCARCSE Nightly Job as a Picture
CCARCSE Nightly Job
There are actually two identical jobs. One runs at 9:40 at night and one runs at 7:00. We really only need one of them, but sometimes the UNIX job doesn't run at night because a drive has been dismounted. It's generally mounted by the time the morning job runs. However, as of June 17, it seems that a patch was run to put computers into sleep mode and even though these jobs are set to wake the computer to run the job, the job isn't running in sleep mode.
Note : As per PBI-168150 “CCARCS - Downloadable Registry package contains an unknown file type”, adjustments were made to eliminate carslay.out from the registry zip file (KM 2022--05-10) Zip file now contains CARSLAYOUT.TXT instead
Logging on – Which Database is used
You may choose which database to log in to by specifying the radio button on the logon screen. The default is Production and Training. In order to have the others appear, you need to enter a setting in the cars_usr.ini (usually found in c:\ccarcs_v2).
[Defaults]
AllowDevAccess=1
Current Status
A release was pushed to the desktops on December 18'th, 2017. No problems have been reported since.
Most Frequent Problems
0. Where to find the scripts<a name="Wheretofind"></a>
The scripts can be found at G:\CIVAV shared\CIVAV SQL Fixes
1. A user needs their password reset and account unlocked.<a name="Unlock"></a>
In general, pass this problem on to the sys admin as they have the ability to reset the password and unlock the account. If there is no sys admin or this is urgent, do the following:
1 – Logon as Admin
2 – Click the Security ICON
3 – Click the User's line
4 – Click the Reset Pwd ICON
2. Change in a Common Name
Occasionally a Common Name (such as Boeing) is entered incorrectly. The user may change it providing no aircraft have been assigned that common name. If the user (even a sys admin) tries to change it while it has aircraft, the user will receive the following error message:
Use G:\CIVAV shared\CIVAV SQL Fixes\CCARCSE\Change_common_Name.sql.
3. Un-Cancel a Cancelled Registration<a name="Uncancel"></a>
This one happens quite often. A user accidentally cancels a registration and now you have to un-cancel it. A sys admin can un-cancel it using the system utility, providing it's the last transaction that was done against that mark and aircraft. If it wasn't, then you have to do it.
- 1 – Logon as Admin
You're done.
If it doesn't work, you will receive this error (a user has performed a subsequent transaction against that mark or aircraft). In this case, you will have to do it with sql.
Use G:\CIVAV shared\CIVAV SQL Fixes\CCARCSE\Uncancel.sql.
4. Unexpire a reserved Mark.<a name="Unexpire"></a>
Occasionally a mark is set to expired and it should not be. Display the mark and set the mark status to issued. You would do that with Unexpire a reserved Mark.sql
The mark auth status is 6 (expired). Set it to 2 (issued) if there is an aircraft id for this mark or 1 (reserved) if there is no aircraft id for this mark.
-- Set an expired Mark to be Unexpired
-- Find the mark
-- Change the mark_AUTH_STATUS_CODE to 1 (reserved)
-- Change the expiry date to whatever you wish (in the future)
5. Unsuccessful of a resurrection of an aircraft<a name="Unsuccessful"></a>
You go to the history page of the mark in question and click the resurrect button. The aircraft will, under normal circumstances, be placed back on the registry and be available for use.
However, every few months, the aircraft model has been discontinued for that aircraft and is no longer available for use. When the client resurrects the aircraft for that discontinued model, CCARCSE can no longer find it and you, the IT dude, have to give it the new model. You do this by assigning the correct aircraft standard ID to the the aircraft.
There is a script called Fix missing model after resurrect.sql that will do this.
DATABASE: CCARCSP
1 – Find the aircraft by serial number in the database
2 – Note the AIRCRAFT_STANDARD_ID. That's what you have to change
3 – The sys admin will provide you with the new model name (that replaces the discontinued model name)
4 – Find the model ID based on that name
4 – Get the AIRCRAFT_STANDARD_ID for that model id. There may be more than one, but it will be obvious which one to use.
5 – Enter it in the Aircraft Row. You're done.
Good To Know
Reference information: http://tfsprod:8080/tfs/CivAv/CCARCS-RIACC/_versionControl?path=$/CCARCS-RIACC/README.md&createIfNew=true&anchor=Wheretofind&_a=preview