Page Comparison

-- 1. Find the record
select * from TM110_PCOCTO_OPERATOR
where upper(first_name_nm) like upper('%keon%') and UPPER(LAST_NAME_NM) like upper('%Nabavi%')
ORDER BY DATE_CREATED_DTE DESC;

select * from TM110_PCOCTO_OPERATOR Where OPERATOR_EMAIL_TXT='Nabavikeon@gmail.com';

-- 2. Check the latest attempt by using the values found in query 1
Select * From Lm109_Exam_Grp_Token WHERE PCOCTO_OPERATOR_CD in(2245383,2245221)
ORDER BY DATE_CREATED_DTE DESC;
-- use Exam_group_id for latest attempt

-- 3. Check if user actually passed,
SELECT COUNT(PASS_QUESTION_IND) AS QuestionsCorrect
FROM TM107_XREF_EXAM_GRP_QUESTION t
WHERE T.EXAM_GROUP_ID = '2246659' and Pass_Question_ind = 1;
--46 out of 50 is a pass

-- 4. Update the record Lm109_Exam_Grp_Token to 1
Update Lm109_Exam_Grp_Token
set result_status_type_cd = 1
where PCOCTO_OPERATOR_CD = 2245383;

-- 5. One more update required
SELECT *
FROM TM104_EXAM_GROUP_VERSIONS
WHERE EXAM_GROUP_ID IN (2246659)
ORDER BY DATE_LAST_UPDATE_DTE DESC;

--update the exam indicator to 1 if passed
update TM104_EXAM_GROUP_VERSIONS
set exam_passed_ind = 1
where EXAM_GROUP_ID = 2246659;

• Export query results to Excel.
• Will also need to send all of the images as well (\\tcwwwmaster\wwwapps\Saf-Sec-Sur\4\pcocds-sbdccep\pdf\question_images).
• Place report and images in the following GroupShare folder: \\tc4s0b\groups\AFCCB\GroupShare\PCOCDS\PCOC Exam Questions

    CAST(tm103.question_version_cd AS SMALLINT);

Problem: Course Provider can't access PCOC web service after attempting to change or reset password.

Description:
A Course Provider is unable to connect with the PCOC web service due to a password reset on the course provider's web service account.  If the password change is initiated via the PCOC Admin Site, the new password will not work and intervention by DSD-Marine will be needed. 

Solution:
To fix the issue (or to reset a Course Provider's password without causing any downtime):

Find the service user account in the TC008_USER table. To do this, you'll need the USER_ID or USER_EMAIL_TXT associated with the account:

select * from TC008_USER where USER_ID = 'KALKOS';
or
select * from TC008_USER where USER_EMAIL_TXT = 'tc@kalkomey.com'

TC008_USER_ID = 525
Update the USER_PASSWORD_TXT to any secure password:

update tc008_user set user_password_txt = 'Jkfds03-fefja' where tc008_user_id = 525;

Now we need to make sure that this password won't expire and that there is no lockout on the account:

update tc008_user set date_expiry_password_dte = null, date_lockout_account_dte = null where tc008_user_id=525;

Send updated password to the course provider and have them confirm that access is restored to the PCOC web service.

ref#TFS 14219

Problem: Server error when student attempts exam

Description:
When attempting to take the exam an error page is shown on the transport Canada site.

When visiting: https://wwwapps.tc.gc.ca/Saf-Sec-Sur/4/pcocds-sbdccep/to/p1000.aspx?lang=0&token=79efa39d-585a-4d12-bf95-c1c3773475a0
The following error is returned in the browser:

Server Error in '/Saf-Sec-Sur/4/pcocds-sbdccep/to' Application.

There is no row at position 0. (IndexOutOfRangeException)

Solution:

Quick Fix :

Create a new token for the candidates and send the test online URL back to the Course Provider so that they may pass this along to their candidate:

...

...