Flight Training and Aviation Education
- Michelle Coelho de Oliveira
(FTAE)
Developer's Guide
How to Fix FTAE Issues
Nov 2014
Table of Contents
Introduction
This document describes the structure of FTAE, most likely problems, most likely fixes and other details pertinent to FTAE.
FTAE is the Flight Training and Aviation Education System. It's a national client server app that enables the users to
Enter personal instructor and examiner information;
Enter and catergorize examination questions;
Enter and catergorize examinations;
View, pause, terminate and grade online (CDE Internal) examinations;
Scan flight tests and examinations;
Perform analysis on exams and flight tests;
Enter Flight Training Unit Information.
The CDE internal allows pilots/students within the TCCs to use a thin client workstation in order to write their examinations online.
The CDE external is a standalone application that is downloaded through the GALRO application. It allows pilots/students at Flight Training Units (FTUs) to write their examinations online. The examinations are downloaded by an Authorized Exam Invigilator (AEI) and the exam results are uploaded by the AEI using the GALRO application.
Sys-Admins
Chantal Avon, (613) 410-9019
Andrew Simpson, (613) 990-1118
Development Environment and Tools
Development Environment and Tools
FTAE uses Powerbuilder 2017 R3
FTAE CDE uses Powerbuilder 12.5
Team Foundation Server on Visual Studio for Source Control
Microsoft Visual Studio Team Foundation Server 2013 MSSCCI Provider 32-bit for Source Control
Microsoft Visual C++ for the scanning software
Team Foundation Server on Visual Studio for Source Control
Microsoft Visual Studio Team Foundation Server 2013 MSSCCI Provider 32-bit for Source Control
Where to find the latest release of CDE Internal
The CDE internal runs on two citrix servers. Nothing else runs on those servers.
Therefore, it’s a simple as copying up the latest executable and three PBD files to those servers.
The servers are rebooted every Saturday night. The business clients are supposed to power down their thin client devices every night.
When the do not, weird failures take place (such as a pilot writing an exam and then all-of-a-sudden, that exam being replaced by an exam from yesterday).
The latest release can be found at G:\CIVAV shared\CDE_4.1.6. This has been written using PB 12.5.
Where to find the latest release of CDE External
The CDE external runs on a desktop at flight schools. It is downloaded from the GALRO website once the invigilator has entered their GC key and been authenticated and once they have been authorized by the FTAE app.
The latest production release can be found at G:\AARR\ Civav Shared\CDE_Dev_External_PB12
Internal Vs External
IMPORTANT: Though the Internal and External seem very different, there is one switch that you compile to determine Internal vs External.
Once compiled, the Internal is copied to the Citrix server and the External is copied up to GALRO.
##Nightly
FTAE Feeds DAPLS with flight tests on a nighly basis though an Oracle Scheduled Job in the FTAE database.
FTAE syncs training unit information with NACIS on a nighly basis though an Oracle Scheduled Job in the FTAE database.
Bascially, FTAE gets Airplane and Helicopter FTUs from NACIS.
FTAE gets aircraft type information with NACIS on an hourly basis.
Databases
#################################################################
FTAE II PRODUCTION SERVERS
#################################################################
##Do not remove IP address from HOST in FTAE, this is required to resolve connectivity issues - DBA Group#
FTAE II PRODUCTION
new ftae prod entry
#Do not remove IP address from HOST in, this is required to resolve connectivity issues - DBA Group#
ftae dev
FTAED.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcdevpkgb)(PORT = 1522))
)
(CONNECT_DATA = (SID = FTAED)(SERVER = DEDICATED))
)
ftae acc
FTAEA.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcdevpkgb)(PORT = 1523))
)
(CONNECT_DATA = (SID = FTAEA)(SERVER = DEDICATED))
)
#cde dev
CDED.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcdevpkga)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = CDED)(SERVER = DEDICATED))
)
CDE Acceptance
CDEA.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcdevpkgd)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = CDEA)(SERVER = DEDICATED))
)
#################################################################
FTAE II PRODUCTION SERVERS
#################################################################
##Do not remove IP address from HOST in FTAE, this is required to resolve connectivity issues - DBA Group#
FTAE II PRODUCTION
new ftae prod entry
FTAE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tcprdpkgb)(PORT = 1646))
)
(CONNECT_DATA =
(SID = FTAE)(SERVER = DEDICATED)
)
)
#cde Prod
CDEP.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TCPRDPKGA)(PORT = 1634))
)
(CONNECT_DATA =
(SID = CDEP)(SERVER = DEDICATED)
)
)
Other Useful Links
RDIMS-#8393219 -FTAE SCANNING PROBLEMS AND SOLUTIONS
RDIMS-#1096041-FTAE/CDE AND SYSTEM-GENERATED EXAMINATIONS
RDIMS-#809372-FTAE CHOOSING BEST SUPPLEMENTAL EXAMS
Current Status
FTAE 3.2.6 is the current production version, but FTAE 3.3.0 is about to be released.
FTAE 3.2.6 is built using PB 12.5. FTAE 3.3.0 is built using PB 2017 R3 because it has to consume restful APIs.
FTAE CDE 4.1.6 is built using PB 12.5.
FTAE Scripts
The scripts can be found at G:\CIVAV shared\CIVAV SQL Fixes. These are up-to-date, but not well-documented
Logging on – Which Database is used
Look in c:\ftaer2run for ftae_app.ini.
[FTAE_NETWORK]
DBMS=o10
SERVERNAME=FTAE
DBPARM=DELIMITIDENTIFIER='NO'
DAPLSSERVERNAME=HQR
[Exam_print]
INDENT=1000
Most Frequent Problems
0. Where to find the scripts
The scripts can be found at G:\CIVAV shared\CIVAV SQL Fixes.
Look in RDIMS-#10169831 - FTAE DEVELOPERS GUIDE for the most requent types of issues.
Good luck and thanks, Chris.