This issue occurs when a test record is not completely generated after a student performs a test and the following fields are missing NULL or (0):
TABLE
CDEI_EXAM_TRANSFER_FILE
COLUMNSColumns
SECTION1_TOTAL_QUESTIONS
SECTION2_TOTAL_QUESTIONS
...
Login to CDEP.WORLD (PROD)
Confirm that the data is missing and get the ExamEXAM_SERIES
SELECT *
FROM CDEI_EXAM_TRANSFER_FILE
WHERE candidate_5802 = '448593' and exam_type = 'AIRATAIRAT' and exam_series = '006';
Replace Data in RED with provided CANDIDATE and EXAM TYPE
...
FROM CDEI_EXAM_TRANSFER_FILE
WHERE exam_type = 'AIRAT' and exam_series = '006' ;
Replace Data in RED with provided CANDIDATE and EXAM TYPE
...
SET SECTION1_TOTAL_QUESTIONS = 73,
SECTION2_TOTAL_QUESTIONS = 0,
SECTION3_TOTAL_QUESTIONS = 0,
SECTION4_TOTAL_QUESTIONS = 27
WHERE candidate_5802 = '448593' and exam_type = 'AIRAT' and exam_series = '006' ;
Replace Data in RED with appropriate data FROM the SIMILAR EXAM
Contact the System Administrator to check and update Correct Answers Total and Score (As it is missing due to interupption)