System Profile

Technology Assessment

Environment Access Information

System Overview

The ARASS application provides Civil Aviation managers with an automated resource management tool for planning and analyzing workload requirements, resource analysis and performance reporting. It contains a database of activities completed within the national Civil Aviation program.

ARASS Quick Reference Document: RDIMS #7908813

RDIMS #7391216

Developer installation

 Software to install

To run ARASS, you must use Microsoft Visual Studio 2013 because it works with Crystal Reports.

Software	Install location
Visual Studio 2013	\\Tc4s0a\groups\AARA\AARAD\Software Library\Developer Tools\Microsoft\Visual Studio 2013
Crystal Reports	\\Tc4s0a\groups\AARA\AARAD\Software Library\Developer Tools\SAP CrystalReports for Visual Studio 2013
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
CLF Page	This project are using CLF Page \\tcinfomaster\mytcroot\Views\WCMS\en-CA\media\documents\cwms\CLFPage https://tcmarin.atlassian.net/wiki/spaces/OP/pages/76906592/Development+environment+documentation#Set-up-CLFPagePlugin
TCMailer	This project are using the version for TCMailerNet \\Tc4s0a\groups\AARA\AARAD\Software Library\Developer Desktop\Old CLF Files\Old CLF Files\TCMailerNet 2.0
AjaxControlToolkit	Version used: 4.1.50401.0
TOAD	\\Tc4s0a\groups\AARA\AARAD\Software Library\Vendor Software\Toad\Installs

*If you don’t have access to \\TC4S0A\GROUPS\AARA\AARAD\, you need to send an email to Service Desk

 Setting up local build

ARASS is using the C:\Program Files\Transport Canada folder (not :\Program Files (x86)\Transport Canada?). You can copy the content of C:\Program Files (x86)\Transport Canada to C:\Program Files\Transport Canada

Inside C:\Program Files\Transport Canada, you should have AjaxControlToolkit.dll, CLFPage.dll, TcMailerNet.dll, and the following folders: StreamTagFilter and CLFPagePlugin

• Inside your local .vs, make sure the applicationhost.config contains these lines inside the <modules> section

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

• If you are seeing any exclamation marks in the References for CLFPage , AjaxControlToolkit, TCMailerNet then add their references by pointing to their dll 's locations on C:\Program Files\Transport Canada, and make sure Copy Local is True. When Copy Local is True, then building the solution will add the dll copies to the bin folder.

• If the layout is still not fixed (see image below), this means the CLFPage.dll is not correct (calling the old stylesheets), please see below for the fix.

 Fix for layout not loading properly (issue with CLFPage dll)

Go to the bin folder and delete the CLFPage.dll. Go to References and remove the CFLPage.dll.

Copy the correct CLFPage.dll (ask team members) to C:\Program Files\Transport Canada and add the Reference for CLFPage.dll to the path of the bin folder

Change in the web.config:

Commenting this line for CLFVersion

Build the solution and run it. The layout should now be displaying correctly.

If you find this type of error

copy your folder in Program Files(x86) in Program Files

Good To Know

~1300 people use this application (source: Olivier Hill)

How-To and Fixes

In case of missing office data in the ARASS report Excel (Using national data dump by quarter). Please refer first to the PDF file by downloading it from the production environment using Generate report tab on the left side of the screen (It’s important to select (‘’Actuals by Office’’ / Report Format ‘’PDF’’) as well as the fiscal year and the quarter.

Then select the offices that you think they’re missing. In this case, we selected (Aerodromes/Cabin Safety/A-OHS)

Then click on Generate report.

Now you’ll get the chance to do the comparison between both files (One using National data dump by quarter/Actuals by office).

In case of you see data that exists on the PDF file and does not on the excel.

Please refer to the database table: AA001_ARASS_OFFICE

Then you’ll be able to look for the missing office using the OFFICE_TITLE_ETEXT field by filtering the office missing.

Then look at the WA003_OFFICE_HIERARCHY_DETAIL table and make sure that the office has values into the OFFICE_LIST field:

Level1/2/3/4/5 are defined for the location of the office. Example :

Pacific/Coastal/Surrey/Specialties/Aerodromes

 please contact me @ Riadh.said@tc.gc.ca for help in case the office list field contains 0 values as 0,0,0,0,0

Oracle.DataAccess.Dll Run error

Switch the CPU Application to X64 Bit mode :

• VS-> Tools-> Options-> Projects and Solutions ->Web Projects

• Uncheck first option in case its checked

• Go to the Any CPU tab bar

• 

  Click on the small rectangle

• Click on Configuration manager

• 

  Then click on New and X64 from New platform

• Click ok then switch from any CPU to X64 and Run the application

TFS Test Plans, Suites and Test Cases imported: