System Profile
System Full Name | General Aviation Licensing and Registration On-line |
Business Administrator | Christopher McCue |
Business Owner | Jeff Phipps |
Director | Felix Meunier |
Subject Matter Expert | Xia Wang, Nikolay Melnik |
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 | http://catcappsx/Saf-Sec-Sur/2/Galro-aglie-sec/client_2.aspx |
|
PREACC
N/A
N/A
N/A
N/A
ACC | \\Tctestmaster\tcappsroot\Saf-Sec-Sur\2\GALRO-AGLIE-SEC | N/A |
| |
PROD | consult with Web Group | N/A |
|
TRAINING
N/A
N/A
N/A
N/A
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
Good To Know
Developer’s note
This solution can run on VS2019.
In order to run the GALRO Admin web page, we need to be added as the administrators (Team leaders can provide you the access)
Compile errors and fixes:
If there is any error about CrystalDecisions
...
, check the References and have to reinstall the actual Dlls for these libraries
...
On VS2019->Tool-> Nuget Packet Manager-> Manage Nuget Packages for Solution, and search for the library to install if that library is not existed, and reinstall if that is already existed.
When we added the library “CrystalDecisions.ReportAppServer.ClientDoc”, we have to install the specific version “13.0.3500.0” since these info are required in the web.config
<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Build the solution and run it. The banner is still not displaying correctly. How to fix it?
...
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. | We an not 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  Please send the email to Service Team Support to close all “pending registration action” and has have that user re-apply as New Request-License. |
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 |