ARASS - SNARA

Owned by Alexandre Bédard
Last updated: Aug 21, 2023 by Noreen Dertinger
7 min read

 

Note: All new users (on production) are to be added by the PO.

System Full Name

Activity Reporting and Standards System

System Full Name (French)

Système de normes avec rapports d'activités

Business Support Team

ARASS Requests / Demandes SNARA
arass-snara@tc.gc.ca

Business Administrator

Stephane Robichaud / Kelly Haynes / Olivier Hill

Business Owner

Liana Fix

Director

Angèle Saumur

Subject Matter Expert

Team Avro Arrows

Division

 

NTARS Code

CA03

Source Location

 

Source Code Location

http://tfsprod:8080/tfs/CivAv/ARASS-SNARA/_dashboards

Migration to DevOps

New Source Code Location (DevOps)

https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/ARASS-SNARA

Technology Assessment

Platform Type

Web (Internal)

Database Platform and Version

Oracle 18C

Development Language and Framework

ASP.NET

Operating System and Version

Windows Server 2016

Additional Dependencies

Crystal Report

Authentication

Windows/AD

Environment Access Information

ENV

UNC

WWWFILES

URL

DB

ENV

UNC

WWWFILES

URL

DB

DEV

 

\\ncrws499\catcappsx\Saf-Sec-Sur\2\ARASS-SNARA

http://catcappsx/Saf-Sec-Sur/2/ARASS-SNARA/

TTSD18

ACC

 

\\tctestmaster\tcappsroot\Saf-Sec-Sur\2\ARASS-SNARA

http://tcappstest/Saf-Sec-Sur/2/ARASS-SNARA/

TTSA18

PROD

 

 

http://tcapps.tc.gc.ca/saf-sec-sur/2/arass-snara/

TTSP18

TRAINING

 

 

 

TTST

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

 

Currently, we can use any Visual Studio to run ARASS such as VS 2019

To create or edit a crystal report, we can use Microsoft Visual Studio 2013/2015/2017, then save the code, then we can continue to use VS2019 to run that crystal report on ARASS

Notes:

-One limitation when working with Microsoft Visual Studio 2015 is that the stdole.dll might be put in the bin folder when build the project in VS2019. The stdole.dll should be removed from the bin folder before moving the deployment to the server.

-Currently, we can not use SAP CrystalReports for Visual Studio 2019 because this Crystal version is not working with the current Crystal Report runtime on the servers (i.e it does not work with CR version22). This can be changed in the future when Crystal Report runtime on the servers can be updated

Software (being used and proved to be working together)

Can use VS 2013 or VS 2015 to build Crystal Reports and have to install correspondent SAP Crystal Reports

Install location

Software (being used and proved to be working together)

Can use VS 2013 or VS 2015 to build Crystal Reports and have to install correspondent SAP Crystal Reports

Install location

Visual Studio 2013

 

OR

 

Visual Studio 2015

\\Tc4s0a\groups\AARA\AARAD\Software Library\Developer Tools\Microsoft\Visual Studio 2013 (will work with SAP CrystalReports for Visual Studio 2013)

 

 

 

\\Tc4s0a\groups\AARA\AARAD\Software Library\Developer Tools\Microsoft\Visual Studio 2015 (will work with SAP CrystalReports for Visual Studio 2017)

 

-->this software is used to edit/view a crystal report

 

Crystal Reports for VS 2013

 

OR

 

Crystal Reports (64-bit) for VS 2015

 

\\Tc4s0a\groups\AARA\AARAD\Software Library\Developer Tools\SAP CrystalReports for Visual Studio 2013

 

 

\\Tc4s0a\groups\AARA\AARAD\Software Library\Developer Tools\SAP CrystalReports for Visual Studio 2017. (but I do not find it is working with VS2017)

 

Notes:

2023-05-08: All servers in Prod/Acc/Dev are running SAP Crystal Reports 13.0.22.2668 64 bit. Therefore we need to install an SAP CrystalReport for VS to work with the same version of Crystal Report on the servers:

Installing SAP CrystalReports for VS 2017, check the Computer setting->will see the version 22 as same as the crystal report version on the servers

If you find the version is not the same (in this example, it should be 22)

Then:

Using Setting to remove all SAP Crystal Reports installations

Go to net work folder and download the right SAP Crystal Reports (mentioned above)

Go to VS-> remove Crystal Report dll and re-add , remember to set Copy property as True

 

Important Note

If using Visual Studio 2015 to build crystal reports, we should remove stdole.dll from bin folder in the deployment package before moving that to the servers. Otherwise, the crystal reports will not be opened. The remove is not required when we use 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

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.

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)

Notes from Mike Clark about the system (current of writing 2023-04-12)

 

Oracle:

ARASS currently is using Oracle.manageddataacess.dll instead of oracle.dataacess.dll. This can be seen in web.config’s connections

The advantage of using Oracle.ManagedDataAccess is we do not need local Oracle client installed. We only need .Net runtime installed to connect to Oracle. This helps to make applications working in any computer without worrying whether we have installed 32bit or 64 bit version Oracle client.

 

Publish files: can use the same below setup to prepare the deployment for dev, acceptance or prod.

We can create one package on dev/acceptance and copy the same package for prod

Connection: The target location is pointing to your local location

 

Settings

ALL Requests for users to be added should go to PO and not be done by Team Avro Arrows .

Change request examples: C255126 (Crystal report change)

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 Team Avro Arrows at ncrafcccteamavroarrows-equipeavroarrowsrcn@tc.gc.ca for help in case the office list field contains 0 values as 0,0,0,0,0

 

TFS Test Plans, Suites and Test Cases imported: