System Profile
| System Full Name | Ship Safety Bulletins - Bulletins de la sécurité des navires |
| Business Contact | Manny Bou-Mitry, Natalia Bass |
| Business Owner | Manny Bou-Mitry |
| Prod Source Location | TFS: $/SSB-BSN/RELEASE/SSB 1.5 |
| Dev Source Location | TFS: $/SSB-BSN/DEVELOPMENT (create dev branch as needed) |
Technology Assessment
| Database Platform and Version | Oracle 12c |
| Development Language and Framework | ASP .NET Framework 4.7.2 VB .NET Framework 4.7.2 |
| Operating System and Version | Windows Server 2016 |
Environment Access Information
DEV
User (admin): n/a
Pass: n/a
Unc: \\ncrws424\wwwappsroot\saf-sec-sur\4\bulletins
Url: http://wwwappsmssdev/Saf-Sec-Sur/4/bulletins/001-eng.aspx
ACC
User (admin): n/a
Pass: n/a
Unc: \\tctestmaster\wwwappstest\Saf-Sec-Sur\4\bulletins
Url: http://wwwappstest/Saf-Sec-Sur/4/bulletins/001-eng.aspx
PROD
User (admin): n/a
Pass: n/a
Url: http://www.tc.gc.ca/eng/marinesafety/bulletins-menu.htm
DB: SSB_EXTA@TTSXPP.WORLD
System Overview
Web site allowing visitors to search for Marine Security Safety Bulletins.
- Bulletins are stored in subfolders in the main web site directory (\\tcwwwmaster\wwwapps\Saf-Sec-Sur\4\bulletins). Subfolders are organized by year.
- There is no admin interface for the SSB application. Client admins have direct access to the SSB production data in order to add, edit or otherwise modify the SSB web application's data, lookup values, etc.
Good To Know
- Connection string is located in web.config file
- SSB was modified as part of the 2019-01-19 Oracle DB Migration. The previous connection string was SSB_USER@DMZ11P
- NOTE: After the migration, the app did not work. In order to get it to work, Marcin Wieczorek (Unlicensed), from the Web Technical Support Group, copied the bulletins.dll and bulletins.pdb files from ACC to Prod. The files in ACC were dated 2017-06-05 while the ones in PROD were dated 2014-02-13. This indicates that it's possible the app was not working even prior to the DB migration.
How-To and Fixes
How To Perform a Basic Test
- Perform a Search
- Click on a bulletin # (eg. "11/2018") and sure the bulletin comes up
- Click on View Archive Results
Request timeout when attempting a bulletin search
Problem:
Attempting to perform a search on the SSB production web site results in a timeout error message. This functionality was working back in February 2019.
Solution:
DOS 458
Unable to update replacement bulletin code
Problem:
I’m trying to modify a record in the SSB database and I’m getting the below error, I can’t even save nor delete any record.
Solution:
DOS 411
Unable to Access SSB Application (Oracle Account Locked)
Problem:
Would you know why we can’t access SSB database, getting the following error message: "ORA-28000: the account is locked"? Does it reside now on a different server, we’re connecting to the one indicated in the attached RDIMS document?
Solution:
TFS 14057