CAETAS - SAFAC

System Profile

System Full Name

Civil Aviation Employee Training Activities System

System Full Name (French)

Système d’activités de formation du personnel d'Aviation Civile

Business Administrator

Laura Powell

Business Owner

Michael Oda Lozada / Robert Lowes

Director

Imi Waljee

Subject Matter Expert

 

Division

 

NTARS Code

 

Source Code Location (Archived)

http://tfsprod:8080/tfs/CivAv/CAETAS-CAETAS

New Source Code Location (DevOps)

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

Migration to DevOps

Technology Assessment

Platform Type

Web (Internal)

Database Platform and Version

Oracle 18C

Development Language and Framework

Classic ASP

Operating System and Version

Windows Server 2016

Additional Dependencies

 

Authentication

Custom

Environment Access Information

ENV

UNC

WWWFILES

URL

DB

ENV

UNC

WWWFILES

URL

DB

DEV

\\NCRWS499\CATCAPPX\ONTARIO\CAETAS\

 

 

ONTARIOD

PREACC

 

 

 

 

ACC

 

 

http://tcapps2test/Ontario

ONTARIOA

PROD

 

 

http://tcapps2/ontario/caetas

ONTARIO

TRAINING

 

 

 

 

System Overview

Used to track and budget training expenditures.

Good To Know

CAETAS is a classic ASP application and needs to be set to Classic ASP application pool.

The folder "CAETAS_reports" is a .NET application to display Crystal Reports. This needs to be set to a .NET 4 application pool.

CAETAS resides on the NCR web farm at TCAPPS2, one of the internal legacy servers. It was migrated from Windows Server 2008 servers to Windows Server 2016 in 2019.

How-To and Fixes

<Sub-sections should describe how to address known support request, including any scripts, instructions / steps, etc… >

Database Info

Production

ONTARIO.WORLD=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST=TCPRDPKGA)

(PORT=1634) )

(CONNECT_DATA=

(SERVER=dedicated)

(SID=ONTARIO) ) )

Acceptance

ONTARIOA.WORLD=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST=tcdevpkgd)

(PORT=1521) )

(CONNECT_DATA=

(SERVER=dedicated)

(SID=ONTARIOA) ) )

Development

ONTARIOD.WORLD=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST=tcdevpkga)

(PORT=1521) )

(CONNECT_DATA=

(SERVER=dedicated)

(SID=ONTARIOD) ) )