System Profile

System Full Name	Marine Enforcement Management System
Business Contact	Rahul Gulati (GULATIR)
Business Owner	Rahul Gulati (GULATIR)
Source Location	https://dev.azure.com/transport-canada/DSD-Marine%20Support/MSS-Portfolio/_git/MEMS/ TAG: v3.9.1 Solution file here: https://dev.azure.com/transport-canada/DSD-Marine Support/MSS-Portfolio/_git/MEMS/Code/Source/MSCA_HOST/MSCA_HOST.sln

Technology Assessment

Database Platform and Version	Oracle 18c
Development Language and Framework	VB.NET Framework 4.0, WinForms, Crystal Reports
Operating System and Version	Citrix (virtual Windows 2016)

Environment Access Information

ENV	UN	PW	UNC	URL	DB
DEV	SYSTEM	See here	\\ncrfs352\MSCA\DEVELOPMENT\RUNTIME	Deployed via Citrix but can be run local/MyDesk via click-once in UNC folder	MSCA@MSCAD
ACC	SYSTEM	See here	\\ncrfs352\MSCA\ACCEPTANCE\RUNTIME	Deployed via Citrix but can be run local/MyDesk via click-once in UNC folder	MSCA_USER@MSCAA
TRAINING	SYSTEM	See here	\\ncrfs352\MSCA\TRAINING\RUNTIME	Deployed via Citrix but can be run local/MyDesk via click-once in UNC folder	MSCAT_USER@MSTRAIN
PROD	SYSTEM	See here	\\ncrfs352\MSCA\PRODUCTION\RUNTIME	Deployed via Citrix but can be run local/MyDesk via click-once in UNC folder	MSCA_USER@MSCAP

System Overview

Essentially a case management system.
- Allows users to build a Case that has Contraventions (Warning, Assurance of Compliance - AC, Administrative Monetary Penalty - AMP, Vessel Detention, Canadian Maritime Document Action - CMD, etc.).
- And Contraventions that have Dispositions (Payment Received, Appealed, CMD Surrendered, AC Complied with, etc.).
- Has an approvals process before a Case is "live".
- Generates PDF Notices that can be served to the subject of the case.
Winforms app delivered via Citrix.
FYI CAPS team no longer needs to package/virtualize MEMS. You can send the package directly to SSC

Good To Know

Historical overview: The original MSCA (Marine Safety Common Architecture, a.k.a MSCA I) initially hosted 2 systems, MEMS and NWDS (Navigable Waterways Database System), and in subsequent work the intention was for other Marine Safety applications to be re-written and hosted in MSCA. After going to production, plans changed and maintenance became problematic, so the NWDS groups took a copy of the code and the database, and maintained their own system separately from MSCA. MEMS is the only system in production that is still hosted in MSCA, so the database and code are a bit messy (the DB still has all the NWDS tables, there are x-ref tables between the common tables and MEMS/NWDS, etc.).

\\ncrfs352\msca\ is the fileserver that hosts:
- PDF files that are filled by MEMS
- Images uploaded by inspectors
- Documents uploaded by inspectors
- SQL "stored procedures"

Account Administration

Since 2015, Rahul Gulati has been looking after most administrative functions such as new user profile set-ups, forgotten or unused application password resets, and other file closures, specific purpose resets, approvals or deletions. All password reset requests should be referred to Rahul.

How-To and Fixes

MEMS Troubleshooting

MEMS Stored Evidence Files Won't Open

The user is unable to open a Word/Excel document from the Details/Docs Tab. Solution is to find the file in the MEMS Prod directory \\ncrfs352\msca\PRODUCTION\FileServer\Documents. Right click, go to properties, and check unblock. These files were created from Crystal Reports application and had blocked the ability to edit them. Opening them from the folder level works but from the app, it didn't . Check after the unblock setting from the app

2. Once debug the code locally, encounter the error "FileNotFoundException: Could not load file or assembly 'log4net, Version=1.2.10.0,Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified."

The error means you don't install the lon4net assembly 32 bite for Crystal Report. Get the right version with same token dll. Normally it is for .net 1.0. If you can't find in internet or repo, look into Dev server's C:\Windows\assembly\GAC_32\log4net\1.2.10.0__692fbea5521e1304. Grab the dll to you local. Use "gacutil -i log4net.dll" command to install it to your Global Assembly Cache.

It will look like the screen capture at last.

Browser not supported