Fatal error CDE transfer

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

 COLUMNS

SECTION1_TOTAL_QUESTIONS

SECTION2_TOTAL_QUESTIONS

SECTION3_TOTAL_QUESTIONS

SECTION4_TOTAL_QUESTIONS

 FIX (using Examples from this particular ERROR)

• Login to CDEP.WORLD (PROD)

• Confirm that the data is missing and get the Exam_SERIES

 SELECT *

FROM CDEI_EXAM_TRANSFER_FILE

WHERE candidate_5802 = '448593' and exam_type = 'AIRAT';

 Replace Data in RED with provided CANDIDATE and EXAM TYPE

•  Obtain the values for these columns from a similar EXAM

 SELECT *

FROM CDEI_EXAM_TRANSFER_FILE

WHERE exam_type = 'AIRAT' and exam_series = '006' ;

 Replace Data in RED with provided CANDIDATE and EXAM TYPE

•  Update the values of these columns for the student

 UPDATE CDEI_EXAM_TRANSFER_FILE

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' ;

 Replace Data in RED with appropriate data FROM the SIMILAR EXAM