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 = 'AIRAT' and exam_series = 'AIRAT006';
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
...