Common XML Upload Error Messages and Explanations for Eval25

Below are the most common errors seen when uploading XML data, and their explanations.


Pre-Staging Errors


Another Load is in ProgressA previous load is still in progress.
Error Processing FileAppears if the data uploaded is not valid XML and the school has a legacy upload that needs to be loaded manually by CollegeNET.
XML ErrorAppears if the data uploaded is not valid XML and the school has a legacy upload that needs to be loaded manually by CollegeNET.
XML File Update ErrorsAppears if the data uploaded is not valid XML, and the school does not have a legacy upload.

Data Type QC Errors


Data Length ErrorA text string is too long.
Data Parsing ErrorA character that should be to be a number or date is not.
Data Type QC failed

Appears if either of the above two Data Type QC Errors is displayed.

Term QC Errors


Courses for this term_id/sub_term_id Already ExistThe courses for the given Term ID or Sub-term ID already exist.
Evals for this erm_id/sub_term_id Already ExistThe evaluations for the given Term ID or Sub-term ID already exist.
File Contains Source Terms that are UnexpectedThere are Term IDs in the file that are not part of the term being uploaded.
Instructor/Course Pairs for this term_id/sub_term_id Already ExistThe instructor and course pairing for the given Term ID or Sub-term ID already exist.
Student/Course Pairs for this term_id/sub_term_id Already ExistThe student and course pairing for the given Term ID or Sub-term ID already exist.
Term id is NullNo term id information was given.
Term QC FailedAppears if any of the above term QC failures are displayed.

Pre-QC Errors


Empty staging tableAppears if there is no actual data given.
There must be only 1 distinct termAppears if more than one term is given.
Course has students but no instructor

Appears when a course is given containing students but not an instructor.

Department primary key violation

Occurs when a department appears more than once, but with different information, such as a different department name.

School primary key violation 

Occurs when a school appears more than once, but with different information, such as a different school name.

Department foreign key violation - one dept_code is in multiple school_codeAppears when a single department code appears in a multiple school code.
Course primary key violationOccurs when a course appears more than once, but with different information, such as a different course name.
Student primary key violationOccurs when a student appears more than once, but with different information, such as a different student name.
Null or empty school_code or school_nameAppears when no school code or name is given.
Null or empty dept_code or dept_name
Appears when no department code or name is given.
Null or empty student_idAppears when no student ID is given.
Some students have null first/last names!Appears when some student first or last names are empty.
Instructor primary key violationOccurs when an instructor appears more than once, but with different information, such as a different instructor name.
Instructor-course primary key violationOccurs when an instructor/course appear more than once, but with different information, such as a different instructor/course name.
Null or empty instructor_idAppears when no instructor is given.
Some can_edit_viewable rows are not in (1, 0). Only 1 or 0 are valid valuesAppears when values other than 1 or 0 are given in can_edit_viewable rows.
Some viewable rows are not in (1, 0). Only 1 or 0 are valid valuesAppears when values other than 1 or 0 are given in viewable rows.
Some can_edit_viewable rows are null! They should default to 1.Appears when a value other than 1 is given as a can_edit_viewable row default.
Some viewable rows are null! They should default to 1.Appears when a value other than 1 is given as a viewable row default.
Null or empty course_idAppears when the given course ID is empty.
Subject is null or emptyAppears when the given subject is empty.
Section is nullAppears when the given section is empty.
Offering is nullAppears when the given offering is empty.
Eval_type is nullAppears when the given course ID is empty.
Session is not null but the start/end dates are null. Cannot load null start/end dates for a session. Either include the dates or set the session id to null.Appears when a session contains empty start/end dates and the session ID is not set to null.
Some sessions are not unique! Each session_id may only have 1 session_title, session_start_dt, session_report_dt, and session_end_dtAppears when a session ID has more than one session title, session start date, session report date, and/or session end date.
Eval25 has multiple session source term ids, which will cause duplicate records when loaded!Appears when more than one session source term IDs have been given.
File contains form_code that does not exist in system!Appears when a form code that has no reference in the XML is given.
Some instructors have null first/last names!Appears when one or more instructors have empty first/and or last names.
Some sesson_id have a value of ''-1''.A session_id may not be '-1', as that is used internally to represent null session_id courses.
Both NULL and NOT NULL session ids exist.Appears when a term is given as session-based and not session-based. A term can be either fully session-based or not session-based, but it cannot be both.
The term is not session based but the file is.Appears when a term is given as session-based and not session-based. A term can be either fully session-based or not session-based, but it cannot be both.
The file is not session based but the term is.Appears when a term is given as session-based and not session-based. A term can be either fully session-based or not session-based, but it cannot be both.
The term or session is already open.Appears when a given term or session is currently open and not suitable for XML upload.
Student has multiple values for the same attributeAppears when an attribute for a student has more than one value.
Combined section value larger than 255 charactersCombined section value larger than 255 characters
One or more subjects in ev.eval_data_ssis_xml are NOT mapped to a dept in ev.subject_department_xAppears when subject(s) in an evaluation XML upload are not mapped to the department in ev.subject_department_x.

TA-Based

Note: TA courses are checked after main courses, which allows them to display error messages that solely concern TAs.
TA: cannot find inst_id for given term_idAppears when there is not an inst_id for the given term ID.
TA: your institution is configured to use course-based evaluations. This configuration is not compatible with one-to-many parent to TA course mappingsAppears when an institution is configured in Eval25 to use course-based evaluations, but one-to-many TA course mappings, where one parent course may have many TA course children, are given.
TA: course primary key violationAppears when there are one or more courses that have conflicting class_size attributes in the file. All attributes for each course key need to be the same.  
TA: some courses do not have parent coursesAppears when TA course mappings do not correspond to a parent course.
TA: some many-to-many mapped courses do not have parent coursesAppears when TA many-to-many mapped courses do not correspond to a parent course.
TA: some TA courses reference departments that do not exist in the parent or existing production dataAppears when TA courses are mapped to departments that do not exist.
TA: Instructor-course primary key violationAppears when is an instructor has a different instructor type. The instructor type needs to be the same for each instructor through out the file.
TA: null course_idAppears when a TA course has an empty course ID.
TA: null or empty dept_codeAppears when a TA course has department code.
TA: section is nullAppears when a TA course has an empty section.
TA: offering is nullAppears when a TA course has an empty offering.
TA: eval_type is nullAppears when a TA course has an empty evaluation type.
TA: some can_edit_viewable rows are null. They should default to 1.Appears when a TA course has one or more empty can_edit_viewable rows instead of the default of 1.
TA: some viewable rows are null. They should default to 1.Appears when a TA course has one or more empty viewable rows instead of the default of 1.
TA: some sesson_id have a value of '-1'A session_id may not be '-1', as that is used internally to represent null session_id courses.
Pre QC failedAppears if any of the above Pre-QC errors are displayed.

Student Refresh Errors


Student Refresh QC: Cannot refresh a session that does not exist!Appears when the XML upload attempts to refresh a session that has not been previously submitted.
Student Refresh QC FailedAppears along with the above message or if an unexpected error occurs during Student Refresh QC.
Student Refresh Missing Insert FailedAppears when the student refresh fails. CollegeNET will need to fix a try/catch error. Following that, the school should try the upload again.
Student Refresh Delete FailedAppears when the student refresh delete fails. CollegeNET will need to be alerted.
Student Refresh Update FailedAppears when the student refresh update fails. CollegeNET will need to be alerted.

Data Load Errors


Cannot find inst_id for given term_idAppears when the instructor ID for a given term cannot be located.
There is form_code not in awdba.instappAppears when loaded form code cannot be located in awdba.instapp.
Did not load as Eval Load History shows data is already loaded!Appears when Eval Load History locates data that is already loaded.
Data Load FailedAppears if any of the above Data Load Errors occur.

TA Data Load Errors


 TA: did not load as Eval Load History shows data is already loaded Appears when Eval Load History locates data that is already loaded to TA courses.
 TA Data Load Failed Appears if the above TA Data Load error occurs.

Note: When associating a TA course with a parent course, the <ta> tag should be set to 1. In addition, to match with courses that share the same course id, rather than having to share a course id, department, offering, and section, add a <ta_type> tag that is set to 2. Type set to 1 TA courses will inherit most course information from their parent course, but type set to 2 TA courses will not.

Post QC Errors


Eval Data + Pre <> PostAppears when the number of courses, evaluations, instructors, or students is not what would be expected based on how many there were before and how many were uploaded.
Staging vs Prod data mismatchAppears when the data expected to be loaded does not match what was actually loaded.
Staging vs Prod counts offAppears when the amount of data expected to be loaded does not match how much was actually loaded.
Staging TA vs Prod TA data mismatchAppears when the TA data expected to be loaded does not match what was actually loaded.
TA: Staging vs Prod counts offAppears when the amount of TA data expected to be loaded does not match how much was actually loaded.

Try/Catch Errors

Note: Each of these errors occurs when SQL Server raises an error. This should only happen if there is a problem that is not already accounted for in QC.
Errors clearing staging for loadContact CollegeNET with this error: support@collegenet.com
System error loading XML to stagingThis may occur when loading the data from the XML file into staging. The first occurs when SSIS has a problem, while the second occurs if the SQL script that calls SSIS raises an error.
Staging pre-loading errorsThis may occur when loading the data from the XML file into staging. The first occurs when SSIS has a problem, while the second occurs if the SQL script that calls SSIS raises an error.
Normalization errorsContact CollegeNET with these errors: support@collegenet.com
Staging shared operations errorContact CollegeNET with this error: support@collegenet.com
Update sub-term id errorsContact CollegeNET with these errors: support@collegenet.com
Threshold Check FailedContact CollegeNET with this error: support@collegenet.com
Populate Instructor Questions FailedContact CollegeNET with this error: support@collegenet.com
Try/Catch Error During LoadingAppears when an error was raised during the load process that wasn't caught anywhere else.

Role and Authority Errors

The following error messages only appear if a school uses the role and authority fields.
One or more instructor/course pairs do not have a role or authority
Appears when an instructor or course pair are not set in the role and/or authority fields.
TA: One or more instructor/course pairs do not have a role or authority
Appears when a TA instructor or course pair are not set in the role and/or authority fields.