Below are the most common errors seen when uploading XML data, and their explanations.
Pre-Staging Errors | |
Another Load is in Progress | A previous load is still in progress. |
Error Processing File | Appears if the data uploaded is not valid XML and the school has a legacy upload that needs to be loaded manually by CollegeNET. |
XML Error | Appears 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 Errors | Appears if the data uploaded is not valid XML, and the school does not have a legacy upload. |
Data Type QC Errors | |
Data Length Error | A text string is too long. |
Data Parsing Error | A 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 Exist | The courses for the given Term ID or Sub-term ID already exist. |
Evals for this erm_id/sub_term_id Already Exist | The evaluations for the given Term ID or Sub-term ID already exist. |
File Contains Source Terms that are Unexpected | There 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 Exist | The 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 Exist | The student and course pairing for the given Term ID or Sub-term ID already exist. |
Term id is Null | No term id information was given. |
Term QC Failed | Appears if any of the above term QC failures are displayed. |
Pre-QC Errors | |
Empty staging table | Appears if there is no actual data given. |
There must be only 1 distinct term | Appears 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_code | Appears when a single department code appears in a multiple school code. |
Course primary key violation | Occurs when a course appears more than once, but with different information, such as a different course name. |
Student primary key violation | Occurs when a student appears more than once, but with different information, such as a different student name. |
Null or empty school_code or school_name | Appears 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_id | Appears 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 violation | Occurs when an instructor appears more than once, but with different information, such as a different instructor name. |
Instructor-course primary key violation | Occurs when an instructor/course appear more than once, but with different information, such as a different instructor/course name. |
Null or empty instructor_id | Appears when no instructor is given. |
Some can_edit_viewable rows are not in (1, 0). Only 1 or 0 are valid values | Appears 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 values | Appears 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_id | Appears when the given course ID is empty. |
Subject is null or empty | Appears when the given subject is empty. |
Section is null | Appears when the given section is empty. |
Offering is null | Appears when the given offering is empty. |
Eval_type is null | Appears 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_dt | Appears 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 attribute | Appears when an attribute for a student has more than one value. |
Combined section value larger than 255 characters | Combined 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_x | Appears 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_id | Appears 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 mappings | Appears 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 violation | Appears 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 courses | Appears when TA course mappings do not correspond to a parent course. |
TA: some many-to-many mapped courses do not have parent courses | Appears 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 data | Appears when TA courses are mapped to departments that do not exist. |
TA: Instructor-course primary key violation | Appears 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_id | Appears when a TA course has an empty course ID. |
TA: null or empty dept_code | Appears when a TA course has department code. |
TA: section is null | Appears when a TA course has an empty section. |
TA: offering is null | Appears when a TA course has an empty offering. |
TA: eval_type is null | Appears 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 failed | Appears 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 Failed | Appears along with the above message or if an unexpected error occurs during Student Refresh QC. |
Student Refresh Missing Insert Failed | Appears 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 Failed | Appears when the student refresh delete fails. CollegeNET will need to be alerted. |
Student Refresh Update Failed | Appears when the student refresh update fails. CollegeNET will need to be alerted. |
Data Load Errors | |
Cannot find inst_id for given term_id | Appears when the instructor ID for a given term cannot be located. |
There is form_code not in awdba.instapp | Appears 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 Failed | Appears 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 <> Post | Appears 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 mismatch | Appears when the data expected to be loaded does not match what was actually loaded. |
Staging vs Prod counts off | Appears when the amount of data expected to be loaded does not match how much was actually loaded. |
Staging TA vs Prod TA data mismatch | Appears when the TA data expected to be loaded does not match what was actually loaded. |
TA: Staging vs Prod counts off | Appears 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 load | Contact CollegeNET with this error: support@collegenet.com |
System error loading XML to staging | This 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 errors | This 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 errors | Contact CollegeNET with these errors: support@collegenet.com |
Staging shared operations error | Contact CollegeNET with this error: support@collegenet.com |
Update sub-term id errors | Contact CollegeNET with these errors: support@collegenet.com |
Threshold Check Failed | Contact CollegeNET with this error: support@collegenet.com |
Populate Instructor Questions Failed | Contact CollegeNET with this error: support@collegenet.com |
Try/Catch Error During Loading | Appears 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. |