PCOCDS
- Justin Green (Unlicensed)
- Peng Li
- Roxanne Lafleur (Unlicensed)
System Profile
| System Full Name | Pleasure Craft Operators' Competency Database System |
|---|---|
| Business Contact | Myke Dwyer |
| Business Owner | Honey Walsh |
| Prod Source Location | https://wwwapps.tc.gc.ca/saf-sec-sur/4/pcocds-sbdccep/pdf/ https://wwwapps.tc.gc.ca/saf-sec-sur/4/pcocds-sbdccep/to/ https://wwwapps.tc.gc.ca/saf-sec-sur/4/pcocws-swccep/service.asmx |
| Dev Source Location | https://wwwappsmssdev.tc.gc.ca/saf-sec-sur/4/pcocds-sbdccep http://wwwappsmssdev/saf-sec-sur/4/pcocds-sbdccep/to/ http://wwwappsmssdev/saf-sec-sur/4/pcocds-sbdccep/WebService/Service.asmx DevOps Repos.:https://dev.azure.com/transport-canada/DSD-MARINE%20Support/_git/PCOCDS-Admin https://dev.azure.com/transport-canada/DSD-MARINE%20Support/_git/PCOCDS-TestOnline https://dev.azure.com/transport-canada/DSD-MARINE%20Support/_git/PCOCDS-UploadEmulator https://dev.azure.com/transport-canada/DSD-MARINE%20Support/_git/PCOCDS-WebService |
| Support Guide (Protected B) | RDIMS #10774893 |
Technology Assessment
| Database Platform and Version | Oracle 18c |
| Development Language and Framework | VB .NET Framework 4.7.2 C# .NET Framework 4.7.2 Crystal Reports |
| Operating System and Version | Windows Server 2016 |
Environment Access Information
ENV | UN | PW | UNC | URL | DB |
|---|---|---|---|---|---|
| DEV | n/a | n/a | \\NCRWS535\wwwappsroot\saf-sec-sur\4\pcocds-sbdccep | https://wwwappsmssdev.tc.gc.ca/saf-sec-sur/4/pcocds-sbdccep/p1000.aspx | PCOCDSD.WORLD |
ACC | n/a | n/a | \\NCRWS488\wwwappsroot\Saf-Sec-Sur\4\pcocds-sbdccep \\NCRWS489\Data\wwwappsroot\Saf-Sec-Sur\4\pcocds-sbdccep | https://wwwappstest.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/pdf/p1000.aspx | PCOCDSA.WORLD |
| KANGA | \\NCRWS518\wwwappstestextroot\Saf-Sec-Sur\4\pcocds-sbdccep | https://wwwappstestext.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/pdf/p1000.aspx | PCOCDSA.WORLD | ||
| PROD | n/a | n/a | \\NCRWS536\wwwapps\Saf-Sec-Sur\4\PCOCDS-SBDCCEP \\NCRWS537\Data\wwwappsroot\Saf-Sec-Sur\4\PCOCDS-SBDCCEP \\NCRWS538\Data\wwwappsroot\Saf-Sec-Sur\4\PCOCDS-SBDCCEP | https://wwwapps.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/pdf/p1000.aspx | PCOCDSP.WORLD |
Production SMTP server DNS: INTSMTP.TC.GC.CA
Environment Access Information
DEV
- Url: https://wwwappsmssdev.tc.gc.ca/saf-sec-sur/4/pcocds-sbdccep/p1000.aspx
- Upload page: http://wwwappsmssdev/saf-sec-sur/4/pcocds-sbdccep/Upload/Pages/UploadPage/NDkzetxt
- Test Page: https://wwwappsmssdev.tc.gc.ca/saf-sec-sur/4/pcocds-sbdccep/TO/p1000.aspx?lang=0&token=e70e3116-652a-4fdf-974e-7a6175ed5bb3
- Server: ncrws535
ACC
- Url: https://wwwappstest.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/pdf/p1000.aspx
- Upload page: https://wwwappstest.tc.gc.ca/saf-sec-sur/4/pcocds-sbdccep/UploadService/Pages/UploadPage/Mjc5etxt
- Server(s): ncrws488, ncrws489
KANGA (External ACC)
- Url: https://wwwappstestext.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/pdf/p1000.aspx
- Upload page: https://wwwappstestext.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/UploadService/Pages/UploadPage/Mjc5etxt
- Test Page: https://wwwappstestext.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/to/p1000.aspx?lang=0&token=ca5debda-0dd1-4531-9075-52c307ecdf91
- Server(s): ncrws518
PROD
- Url: https://wwwapps.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/pdf/p1000.aspx
- Upload page: https://wwwapps.tc.gc.ca/saf-sec-sur/4/pcocds-sbdccep/UploadService/Pages/UploadPage/Mjc5etxt
- Test Page: https://wwwapps.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/TO/p1000.aspx
- Server(s): NCRWS536, NCRWS537, NCRWS538
Production Log File Locations:
\\NCRWS536\wwwfiles (Application logs)
\\NCRWS536\LOGFILES\W3SVC3 (wwwapps IIS logs)
\\NCRWS536\LOGFILES\Events (Event Viewer logs)
\\NCRWS537\wwwfiles (Application logs)
\\NCRWS537\LOGFILES\W3SVC3 (wwwapps IIS logs)
\\NCRWS537\LOGFILES\Events (Event Viewer logs)
\\NCRWS538\wwwfiles (Application logs)
\\NCRWS538\LOGFILES\W3SVC3 (wwwapps IIS logs)
\\NCRWS538\LOGFILES\Events (Event Viewer logs)
System Overview
Tips For Supporting This System
- Setting system outage/unavailability message
- How-Tos And Quick Fixes
- Manage User Accounts
- Find Operator In DB
- Find Operator Tests In DB
- Find Course Provider User
- Reset A Test To "Not Started" State For Re-Take
- See Tests Currently Being Taken
- Find Exam Token By Operator ID
- Set Exam Language To Fix Request In Wrong Language
- Find Users By Email
- Find SAIK For Course Provider And Ensure Validity
- Using The Emulator And Set Up Course Provider For Online Test Access
- Check Upload History For Course Provider
- Differentiate Between Test Online Operators And Classroom Candidates
- Updating Contact Details For A Course Provider
- Find Exams Where Questions Are Used, I.E. Question_ID #520 is Part of Which Exam?
- Find Which Tests An Image Is Used In
- Fix Broken Images In Questions Which Prevent Printing Exams
- Find Questions Using Question Text
- Find Possible Answers for Questions
- Find SAIK for Course Provider
- Find Resources for Label Text in All Applications
- Set Up Maintenance Messages
- Error Importing: {FIELD_NAME} must not be empty
- PCOC External ACC [Kanga] Not Working after Migration to 2016
- How to Remove Unwanted Uploaded Card Data
- How to View Package Bodies in PCOCDS ACC and PROD Databases
- Course Provider receiving multiple emails from the PCOCDS Web-Service for the same person on the same date with different test results.
- CPS-ECP Transport Canada PCOC Online exam TOKEN Request Example, unable to POST to CPS
- Operator completed exam and the exam record could not be found on the Test Status page.
- Update the instructions (user guides) for the Upload page