Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 24 Next »

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 (GALRO development)
Izabella Krukowska (GALRO at Quebec region)

Josie Fusca (GALRO at Ontario region)

Chantal Avon (FTAE System Administrator)

Christopher McCue (CCARCS System Administrator)

Division

NTARS Code

CA26

Source Location

Source Code Location

http://tfsprod:8080/tfs/CivAv/GALRO-AGLIE-SEC

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

CCARCSD

HQRDEV

ftaed

ACC

\\Tctestmaster\tcappsroot\Saf-Sec-Sur\2\GALRO-AGLIE-SEC

N/A

http://tcappstest/Saf-Sec-Sur/2/GALRO-AGLIE-SEC/req_1.aspx

CCARCSA

HQRACC

FTAEA

PROD

consult with Web Group

N/A

http://tcapps/Saf-Sec-Sur/2/GALRO-AGLIE-SEC/req_1.aspx

CCARCSP

HQR

FTAE

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.

In order to run the GALRO Admin web page, we need to be added as the administrators. Most members of the current (Sept 2022) Civil Aviation maintenance team have been added to GALRO Admin as Administrators on development, acceptance and production. See RDIMS (to be created) for details regarding adding users.

 Compile errors and fixes

If there is any error about CrystalDecisions:

Check the References, you 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 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 .

<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

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

 User requests access to GALRO online

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. 

  • The request is stored in the CCARCS-E database as a BF entry.  The entry is assigned to the appropriate region based on province.

  • The administrator reviews the request

  • The administrator searches the CCARCS-E database to see if a client with the same name/address already exists in the database

  • If a client already exists, a client letter is generated and mailed to the client

  • If there is not existing client found the Administrator:

    • Creates a new client in CCARCS-E database and an activation key is generated

    • The administrator generates the letter and mails it to the client

  • The administrator closes the BF entry

 Unable to issue an activation key in GALRO for a user

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

  • No labels