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/_versionControl?path=%24%2FCAETAS-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	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) ) )