NORMS - SNGI

System Profile

System Full Name	National Occurence Response Management System
System Full Name (French)	Système national de gestion des interventions
Business Administrator	Dean Ciaschini
Business Owner	Joel Morley
Director	Patrick Juneau
Business Subject Matter Expert(s)
Division	Aviation Safety Policy and Intelligence
NTARS Code
Source Location
Source Code Location (Archived)	http://tfsprod:8080/tfs/CivAv/NORMS/_versionControl
Migration to DevOps
New Source Code Location (DevOps)	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/NORMS

Technology Assessment

Platform Type
Database Platform and Version	Oracle 18C
Development Language and Framework
Operating System and Version	Windows Server 2016
Additional Dependencies
Authentication

Environment Access Information

ENV	WWWFILES	URL	DB

ENV	WWWFILES	URL	DB
DEV	\\tcwebscripts\tpwwwroot\eigdev\norms	https://eigdev.tc.gc.ca/norms/	NORMSD
ACC	\\tcwebscripts\tpwwwroot\eigacc\norms	https://eigacc.tc.gc.ca/norms/	NORMSA
PROD		https://eig.tc.gc.ca/norms/	NORMSP

ENV	WWWFILES	URL

ENV	WWWFILES	URL
TruePass (Archived)
DEV	\\tcwebscripts\tpwwwroot\securedev\NORMS	https://etpdev.tc.gc.ca/NORMS/
PREACC	\\tcwebscripts\tpwwwroot\securedev\NORMS-PreAcc	https://etpdev.tc.gc.ca/NORMS-PreAcc/
ACC	\\tcwebscripts\tpwwwroot\secureacc	https://etpacc.tc.gc.ca/norms
PROD		https://etp.tc.gc.ca/norms

System Overview

This project is for the redesign and replacement of existing inefficient tools, processes, and procedures towards creating a current, modern, well designed, well supported tool set to enable the Occurrence Response sections in Civil Aviation, Marine Safety, and Rail Safety to manage and deliver the Minster’s Observer Program as defined in the Canadian Transportation Accident Investigation and Safety Board (CTAISB) Act, and other relevant legislature for Safety and Security Groups.

NORMS receives data from the TSB's ASIS system during a nightly 'handshake'. That is the only connection to the TSB other than manual emails sent by the various users (TSB liaison).

Developer installation

Completely uninstall and reinstall oracle 12c. The installer can be found in \\TC4S0A\GROUPS\AARA\AARAD\Software Library\Developer Tools\Oracle. Regular installation, except there is no need for any VS dev tools and can be installed system-wide. (Note: Not having Visual Studio 2015 installed might prompt the following error. Downloading Visual Studio 2015 should fix that issue.)
Unconfigure Oracle’s GAC with the attached bat file from \\Tc4s0a\groups\AARA\AARAD\NORMS.
Install the latest ODT from Oracle’s website.

Note: Although installing Visual Studio 2015 is needed for step 1, the application is run on Visual Studio 2019.

How to get NORMS running locally if there are Oracle issues

How to Create a NORMS User for Development Purposes

Good To Know

Valid Occurrence Number Formats

CWMS.Utilities - \\Tc4s0a\groups\AARA\AARAD\NORMS\CWMS.Utilities.1.0.1

Refreshing NORMS databases

When the Inspector users log in, Inbox->Action List will be opened to display, Occurrences will be closed.

At present (2023-03-20), it is not required to change the above features_ Please see task #246234 NORMS user account not being directed to 'to do list'

How-To and Fixes

Production Error Log - Tracking all the production issues to notice trends as they can't be replicated in ACC

How to Change the TSB Coordinator in NORMS

Deployment Considerations:

NORMS has been changed to use Entrust Identity Guard instead of Entrust Truepass.
They have provided dev (eigdev) and acc (eigacc) environments for EIG applications. eigdev is running on a single server but eigacc is running in web farm.

Web Farm Deployment Considerations

Machine Code Generator - Entrust Guard Identity

BSD - Civil Aviation