Versions Compared

Old Version 38

changes.mady.by.user Riadh.Said

Saved on

compared with

New Version 39

changes.mady.by.user Phuong

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

System Profile

...

RDIMS #7391216

Developer installation

Expand
titleSoftware to install

...

Currently, we are using Visual Studio 2019 to run ARASS

To create or edit a crystal report, we can use Microsoft Visual Studio 2013

...

/2015/2017, then we can continue to use VS2019 to run that crystal report on ARASS

Note: 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.

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

Image Modified

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

Image Modified

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

Expand
titleSetting 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

Code Block
languagexml
<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.

Image Modified

  • 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.

Image Modified
Expand
titleFix 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

Image Modified

Change in the web.config:

Commenting this line for CLFVersion

Image Modified

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

Image Modified

If you find this type of error

Image Modified

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

Image ModifiedImage Modified


Good To Know

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

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

...

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.

...

 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

  • Image Removed

    Click on the small rectangle

  • Click on Configuration manager

  • Image Removed

    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:

...