LearningFAQ > SIS Error Code Cheat Sheet
SIS Import Exception Codes
The following exceptions are listed within each .txt file produced from a bad file generation. Below is a list of possible exceptions broken down by filename:
schdata.txt
“unique key duplication” - School ID is not Unique
usrdata.txt
“unique key duplication” - Student ID is not unique within School ID provided
“unique key duplication” - Username (Optional) is not unique within School ID provided
studata.txt
“unique key duplication” - Student ID is not unique within School ID provided
“unique key duplication” - Username is not unique within School ID provided
“foreign key failure” - School ID was not found in schdata.txt
clsdata.txt
“unique key duplication” - The combination of School ID, Student ID, Course ID, Section, Term, School Year may only appear once in clsdata.txt. This error indicates this combination was duplicated
“foreign key failure” - School ID was not found in schdata.txt
“foreign key failure” - Student ID and/or School ID were not found in studata.txt
“custom rule failure” -
◦ usrdata.txt file is present: Teacher ID must be located in usrdata.txt
◦ usrdata.txt file is not present: First Name and Last Name of Teacher must be located in clsdata.txt