NASIMS Back-end Processor - SGINSA Processeur dorsal

System Profile

System Full Name	National Aviation Safety Information Management System Back End Processor
System Full Name (French)	Système de gestion d'information nationale sur la sécurité aérienne processeur dorsal
Business Administrator	Sebastien Arsenault
Business Owner	Andrew Larsen
Director	Felix Meunier
Subject Matter Expert
Division
NTARS Code	CA49
Source Location
Source Code Location

Technology Assessment

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

Environment Access Information

ENV	UNC	WWWFILES	URL	DB

ENV	UNC	DB
DEV		NASIMSD
PREACC		NASIMSPA
ACC		NASIMSA
PROD	\\NCRWKIT169103\	NASIMSP
TRAINING		NASIMST

System Overview

The NASIMS Back-End Processor exists on the server NCRWKIT169103. The server is in a secure cabinet located on the 11th Floor of the Enterprise Building (Minto) located at 427 Laurier Ave. West in Ottawa. The secure cabinet can only be opened via a combination lock.

The server NCRWKIT169103 replaced the server NCRWKIT103417 in January 2025. The server NCRWKIT103417 was decommissioned as it was using Windows 7, a security risk.

There is a process called NASIMS_WSBEP in the Task Scheduler which runs every 10 minutes to process the production data:

populate the data to the NASIMS database
send out reports and emails in the queue
parse email data in NASIMS mailbox

Process NASIMS_WSBEP

When the server does not execute, it maybe due to one of the following issues:

the server is off
the server requires rebooting
updates were applied to the server
electrical outage at the Enterprise Building
a new password is required

In order to access the server, it is necessary to logon to the server. Go to Remote Desktop Connection.

Enter NCRWKIT169103 in the Computer field and TC\AANSIMS in the User Name field. Select Connect.

If VPN is not running, a message of the following nature will be returned:

If VPN is running, the following window will appear:

Go to the PINS Password Manager to get the password for NASIMS Back-End Server (NCRWKIT169103 PROD) for user AANSIMS. Enter the password. The following will appear:

Ensure that user AANSIMS is selected and enter the password again.

If AANSIMS is not listed select “Other User”, User ID AANSIMS and enter the password again.

Good To Know

<--->

How-To and Fixes

Mail box full

Under regular usage, the NASIMS mail box can become full. Periodically (every few months) an export from the “Processed” folder should be conducted. Backups were currently stored in TFS and should now be stored in GIT.

DoWebEvents WebEvents are locked

The back-end processor can stop running properly if it crashes while processing incoming e-mails. Typically it generates error e-mails such as: “DoWebEvents WebEvents are locked”.

Disable the process NASIMS_WSBEP (running on computer NCRWKIT169103)

2. Check the status:

select * from TA047_USER_PREFERENCE
 where user_id = 'ADMIN' 
 and PREFERENCE_CD = 'WebEventsLocked

It is likely that PREFERENCE_VALUE_TXT will be True, causing the error e-mail.

3. Clean up the bad email "Undeliverable: DoWebEvents WebEvents are locked

3,1 Check if bad data exists

SELECT REPORT_ID  FROM (  SELECT *
FROM GA001_INTELLIGENCE_REPORT GA001
WHERE GA001.ACTIVITY_TYPE_CD = 'MAIL'
AND GA001.ACTIVITY_STATUS_CD = 'INPROCESS' 
AND ACTIVITY_TXT = 'Undeliverable: DoWebEvents WebEvents are locked'
ORDER BY GA001.DATE_CREATED_DTE ASC)
WHERE ROWNUM < 700 AND DATE_REPORT_DTE > sysdate - 3

3.2

Take a back up of report_id (to keep track of the report_id to be updated?) (Export 3.1)

3.3

UPDATE GA001_INTELLIGENCE_REPORT
SET ACTIVITY_STATUS_CD = 'COMPLETE'
WHERE REPORT_ID IN
(SELECT    REPORT_ID  FROM (  SELECT *
FROM GA001_INTELLIGENCE_REPORT GA001
WHERE GA001.ACTIVITY_TYPE_CD = 'MAIL'
AND GA001.ACTIVITY_STATUS_CD = 'INPROCESS' AND 
ACTIVITY_TXT = 'Undeliverable: DoWebEvents WebEvents are locked'
ORDER BY GA001.DATE_CREATED_DTE ASC)
WHERE ROWNUM < 700 AND DATE_REPORT_DTE > sysdate - 3 )Set the status to false

4. Set the status to false

5. Enable the process NASIMS_WSBEP.