Fatal error CDE transfer
- Sufyan Maghur
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)