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 |
| Tech Stack | Presentation Layer: ASP.NET Business Logic Layer: VB.NET RDBMS: Reporting: |
| Prod Source Location | TFS: $/SSB-BSN/RELEASE/SSB 1.5 |
| Dev Source Location | TFS: $/SSB-BSN/DEVELOPMENT (create dev branch as needed) |
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, from the Web Monitor 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
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