MEMS-SGMESM

Owned by Tibo (Unlicensed)
Last updated: Jan 31, 2024 by Peng Li

System Profile

System Full NameMarine Enforcement Management System
Business ContactRahul Gulati (GULATIR)
Business OwnerRahul 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 VersionOracle 18c
Development Language and Framework

VB.NET Framework 4.0, WinForms, Crystal Reports

Operating System and VersionCitrix (virtual Windows 2016)

Environment Access Information

ENVUNPWUNCWWWFILESURLDB
DEVSYSTEMSee here\\ncrfs352\MSCA\DEVELOPMENT\RUNTIME
Deployed via Citrix but can be run local/MyDesk via click-once in UNC folderMSCA@MSCAD
ACCSYSTEMSee here\\ncrfs352\MSCA\ACCEPTANCE\RUNTIME
Deployed via Citrix but can be run local/MyDesk via click-once in UNC folderMSCA_USER@MSCAA
TRAININGSYSTEMSee here\\ncrfs352\MSCA\TRAINING\RUNTIME
Deployed via Citrix but can be run local/MyDesk via click-once in UNC folderMSCAT_USER@MSTRAIN
PRODSYSTEMSee here\\ncrfs352\MSCA\PRODUCTION\RUNTIME
Deployed via Citrix but can be run local/MyDesk via click-once in UNC folderMSCA_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

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