GALRO External - AGLIE Externe

System Profile

Technology Assessment

Environment Access Information

System Overview

GALRO 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

External users may also refer to the application as General Aviation Online Services

GALRO is an external secured website that uses Oracle (CCARCS, FTAE, DAPLS database). GALRO-API is an external website that uses Oracle (CCARCS).

GALRO communicates with external clients allowing them access to change addresses and reserve marks. This access will not be available during an outage.

It is a “Web Portal”:

• The security and credential service is built with GCKey and Sign-in partner service

• Enables various external clients to communicate with Transport Canada using a single Internet-based application, as an alternative to current paper-based methods. 

• Information submitted electronically by clients is stored in one or more centralized databases that are accessible by internal TC employees using the following existing National Client/Server systems for processing such as

  • FTAE (Flight Training and Aviation Education)

  • CDE External (Computer Delivered Examinations)

  • DAPLS (Distributed Air Personnel Licensing System)

  • CCARCS (Canadian Civil Aircraft Registration)
    
    

GALRO Accounts on development, acceptance and production:

The following document provides info for shared accounts on development, acceptance and production:
GALRO Developer accounts: dev, acc, prod

See also: GALRO login errors - including AEI login errors - BSD - Civil Aviation - Confluence

Good To Know

GALRO does NOT have it's own standalone Database. It leverage repositories on CCARCS, FTAE, and DAPLS. Tables were created in the CCARCS database for security log tracking (YA tables - CARS schema).

Active business clients (TC):

• FTAE Administrator

• Pilot Training and Licensing

• Service Team, Civil Aviation (National and Regional)

“COPS Callback Web API” is the “client-side” interaction with the COPS payment service. It belongs to GALRO which supports the use of COPS payment.

To test the COPS payment system, the credit card information here can be used: https://tcmarin.atlassian.net/wiki/spaces/FTT/pages/2491023435

Debug project

Note: All these configurations is to run the project local, make sure don’t upload these configurations in production

1. Go to C:\Projects\CivAv\GALRO-AGLIE-WAAU\Source\GALRO-AGLIE\Application Code\SecureChannel.vb and comment on these lines

   Open

   

2. Open this hidden file

   Open

   

    

3. Add this line, verify the version installed in your machine to the web.config (note: this is in web.config for GALRO).

   <add name="StreamTagFilter-4.0" type="Utility.IIS.StreamTagFilterModule, StreamTagFilter.NET.4.0, Version=1.0.6.2, Culture=neutral, PublicKeyToken=d3d707ec692e4024" preCondition="runtimeVersionv4.0" />

   
   
   

4. If you don’t have gcwu-fegc template in your machine, it is recommended to obtain it from
   \\NCRWS499\wwwdocs\CLF_TEMPLATES\x86\gcwu-fegc
   
   It is not recommended to use this template from other sources as they might not be stable.
   
   Copy the gcwu-fegc folder to C:\Program Files (x86)\Transport Canada\CLFPagePlugin\Templates.
   
   Without the mentioned template, you will see the following error when you try to run locally:
   
   
   

    

5. CLF Dependencies

   Fixing CLF Page Plugin or Fixing CLF Page Plugin 1.1
   Note: To install StreamTagFilter and CLFPagePlugin, try to pass by command line running as Administrator

   Select Yes to configuring IIS to use StreamTagFilter.

    

NOTE: It’s possible when you run the project (development) in Visual Studio, we might have this type of issue. You need to click on continue and everything will be OK.

Publish project

1. Right-click in the project > Publish

    

2. Select the correct folder and click on Publish.
   Note: For Release (Production) the option Configuration needs to be Release.

    

3. If you don’t have this configuration, click on New > Folder > Next

4. Get the Folder location in Environment Access Information and click on Finish.

   
   
   

How-To and Fixes

References

Update: August 19, 2022: as discussed with Alain and Raj in the GALRO discussion, RDIMS 16772158 does not seem to be in RDIMS.