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	\\NCRWKIT103417\	NASIMSP
TRAINING		NASIMST

System Overview

<--->

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 are currently stored in TFS.

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”.

Stop the scheduled job (running on computer NCRWKIT1034)

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 to scheduled job