Purple Alerts

Owned by Sufyan Maghur
Last updated: Oct 04, 2022
1 min read

Authorized external invigilators (AEIs) download exams through the GALRO website.  They also upload the examination results through GALRO.  Chantal Avon then transfers the results to the examination transfer file.  Every once in a while you will receive a purple alert - the exam results are uploaded empty and duplicated.  You will remove the duplicate and allow the AEI to re-upload them.  To do this, you need to clear the upload, which resets the process and enables the AEI to redo the upload. 

You need to do the following using (TOAD or any other Database Management tool)

  1. Login to FTAE PRODUCTION database

  2. Look at CDE_EXAM_RESULTS_IMPORT_LOG see the 2 or more records (Filter By CANDIDATE_5802 and CDE_USERID with the information in the PBI)

  3. Look at CDE_EXAM_RESULTS_IMPORT_FILES see the 2 or more records (Filter By FTAE_USERID with the information in the PBI)

  4. Look at CDE_EXAM_EMAIL_REQUEST_LOG see the 1 record. (Filter By CANDIDATE_5802 and CDE_USERID with the information in the PBI). Take note of the value in the IMPORTED_AND_TRANSFERRED_DATE field.

  5. Go back to CDE_EXAM_RESULTS_IMPORT_FILES Make sure the answers are there and delete the row that doesn’t have the IMPORT_DATETIME same as IMPORTED_AND_TRANSFERRED_DATE in CDE_EXAM_EMAIL_REQUEST_LOG.

  6. If the answers are in the other row only, switch the date but answers are usually in both rows)

  7. Go back to CDE_EXAM_RESULTS_IMPORT_LOG and delete the row that doesn’t have the IMPORT_DATETIME same as IMPORTED_AND_TRANSFERRED_DATE.