Fatal error CDE transfer

Owned by Sufyan Maghur
Last updated: Jun 01, 2023
1 min read

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' and exam_series = '006';

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