System Profile
System Full Name | General Aviation Licensing and Registration |
|---|
Admin | |
System Full Name (French) | Admin d'Aviation générale licences & immatriculation en ligne |
|---|---|
Business Administrator |
Christopher McCue
Business Owner |
|---|
Jeff Phipps
Director
Felix Meunier
Subject Matter Expert
Elie Chamieh | |
Business SMEs | Izabella Krukowska (GALRO at Quebec region) Josie Fusca (GALRO at Ontario region) Chantal Avon (FTAE System Administrator) |
|---|
Director | Marcia George |
|---|---|
Division | |
NTARS Code | CA26 |
Source Location | |
Source Code Location | |
Migration to DevOps | ✅ |
New Source Code Location (DevOps) | https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/GALRO-AGLIE-SEC |
Technology Assessment
Platform Type | Web (Internal) |
|---|---|
Database Platform and Version | Oracle 18c |
Development Language and Framework | .NET 4.0, VB.NET, Web Forms, “Intranet“ GoC CLF |
Operating System and Version | Windows Server 2016 |
Additional Dependencies | Crystal Report |
Authentication | Windows/AD |
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV | \\ncrws499\catcappsx\Saf-Sec-Sur\2\GALRO-AGLIE-SEC | N/A |
| ||
ACC | \\Tctestmaster\tcappsroot\Saf-Sec-Sur\2\GALRO-AGLIE-SEC | N/A |
https://tcappstest.tc.gc.ca/Saf-Sec-Sur/2/GALRO-AGLIE-SEC/req_1.aspx |
| |
PROD | consult with Web Group | N/A |
https://tcapps.tc.gc.ca/Saf-Sec-Sur/2/GALRO-AGLIE-SEC/req_1.aspx |
|
System Overview
GALRO Admin is an internal admin website that uses Oracle (CCARCS, FTAE, DAPLS database); It used by TC personnel (GALRO administrators) to manage internal user access and external user registration, activation
Allows for the online entry of General Aviation transactions as well as the request for information from General Aviation. It allows external clients to: Manage marks - reserve, issue and renew Change address and ownership Provide leasing advisories Exter
Good To Know
Developer’s note
This solution can run on VS2019.
Admin access to GALRO Admin
In order to run the GALRO Admin web page, we need to be added as the administrators (Team leaders can provide you the access). All members of the Civil Aviation maintenance team have been added to GALRO Admin as Administrators on development, acceptance and production.
To connect to GALRO Admin:
Find the URL for the environment you need to connect to in the Environment Access Information section.
Note: on acceptance you may be presented with a prompt to login. Login using your network credentials. If your login attempt fails you will need to log an ORION ticket to request access.
Adding a new user via the GALRO Admin application:
Any user listed above can connect to GALRO Admin on development, acceptance and production and add a new user.
1. Select “User Administration” from the left hand menu.
...
2. Click “Add user”
...
3. Search for the user you are adding.
Example
...
4. Add and save the user.
Example, for admin user:
...
Adding a new user via the GALRO Database application:
GALRO Admin users are managed in the CCARCS database (Table TA04_GALRO_SECURITY_USER).
See also TA05_GALRO_ACCESS_LEVEL
On dev and acc, use the “CARS” user. I was not able to find an appropriate account for PROD with write access, so the client gave me access. Once I had access, I could add the rest of the team.
Important note: if you don’t have access to the GALRO admin app you will not be able to add other users.
I was able to add myself to the database and then could add other users.
Running on Local:
| Expand | ||
|---|---|---|
|
...
If there is any error about CrystalDecisions:  |
...
Check the References |
...
, you have to reinstall the actual Dlls for these libraries.  On VS2019 |
...
→ |
...
did not |
...
exist, and reinstall if |
...
it already existed. When we |
...
add the library “CrystalDecisions.ReportAppServer.ClientDoc”, we have to install the specific version “13.0.3500.0” since |
...
this is what is specified/required in the web.config .
Build the solution and run it. |
...
If the banner is still not displaying correctly |
...
, how to fix it? |
...
 Fixed: On the browser, click view source code, you can find  → we must miss the images folder and stylesheets folder in our local path when running GALRO-AGILE-SEC in dev mode → Go to \\ncrws499\catcappsx\ and copy “images” and “stylesheets” folders to your local source code of GALRO-AGILE-SEC → Refresh the browser, now it displays correctly  |
How-To and Fixes
| Expand | ||
|---|---|---|
| ||
New users, can request an “activation-key” directly from the Web by providing name and address information. The request is sent to CCARCS-E as a BF entry (client server system) where an Administrator reviews it. If there is a client match (existing client with same name and address) the client’s activation key is mailed to the client’s address. If there is no client match, a new client is created, and a new “activation-key” is assigned. The “activation-key” is then sent to the client’s address.
|
| Expand | ||
|---|---|---|
|
...
|
No account exists in CCARCE. Not issue an activation key in GALRO for a user because there is no such record in CCARCE. For example, when searching the individual details for that user, we do not find any record in CCARCE
...
User has already requested an activation that was not completed but no account exists in CCARCSE.  Solution: Please send the email to Service Team Support to close all the “pending registration action” for the user and have that user re-apply as New Request-License only. |
References
Document | RDIMS # |
|---|---|
GALRO_PHASE_I_CONSOLIDATED_ANALYSIS | 4672886 |
GALRO_PHASE_II_III_CONSOLIDATED_ANALYSIS | 4693669 |
GALRO_PHASE_II_III_SS2_SECURITY_DETAIL_DESIGN | 4719638 |
GALRO_ENVIRONMENT_SUMMARY Some of information in this document is out of date | 16772158 |