Exam Admin Manager sometimes reports that an examinee that should be authorized with Pearson Vue to sit for an exam is not, and that the BC examinee detail page is showing that there is an error with the Pearson Vue authorization. In order for an examinee to be authorized (EAD sent to PV), the examination EAD open date should have passed and the examinee's application status is 'Approved' or 'Approved-Pending'.
1. Run the query below to pull Pearson Vue RTI errors in the Log for EADs (PV authorizations) and CDDs (demographic data)
2. See what the exception is. If is involves an address, then that usually means we are attempting to send an address in the CDD to PV that has exceeded the maximum length. Exam Admin Manager knows what to do. After address is corrected in BC, the hosted service will attempt again. The CDDs and EADs get synched up on the PV side and we ususally get a successful CDD EAD within the next day or so.
3. If the CDD was successful but the authorization ended in error for whatever reason (maybe system outage on PV side) (as seen in table PearsonVueAuthorization.Status) our system logic in 'AutomatedScheduling' hosted service as of 8/6/24 does not look at status to determine whether or not to attempt resend. Adding ADO story to correct this code logic: if PearsonVueAuthorization.Status = Error then hosted service should attempt to send the authorization again.
4. Until story is developed and fix released to prodution, delete the PearsonVueAuthorization row with a status of 'Error'.
5. Check that authorization succeeds after the next scheduled 'AutomatedScheduling' hosted service run.
Query to look for PV errors in Log:
select top 1000 *, REPLACE(Message, 'Error in PearsonVuePublishCandidateUseCase ClientCadidateId = ', ''), Exception
from log where level = 'error' and RawMessage Like 'Error in PearsonVuePublishCandidateUseCase ClientCadidateId =%'
order by id desc
Query to investigate and delete the correct PV authorization for a specific examinee:
select a.person_key, e.examineeid, a.examination_key, ex.Examination_Code, tt.TestTaker_Status_Key,
pva.*
from applicant a
join examination ex on ex.examination_key = a.Examination_Key
join examinee e on e.testtaker_key = a.applicant_key
join testtaker tt on tt.testtaker_key = e.TestTaker_Key
left join PearsonVueAuthorization pva on pva.ExamineeId = e.ExamineeId
where a.examination_key in (1234) and tt.TestTaker_Status_Key <> 0 and a.Person_Key = 123456
order by ex.Examination_Code, tt.testtaker_status_key, a.person_key, e.examineeid, pva.ExamineeId
----------------------------------------------------------------------------
delete from PearsonVueAuthorization where PearsonVueAuthorizationId = 12345
Examinee Details page displays the Pearson Vue CDDs, EADs (authorizations), and appointments:
