LearningStation Insight Help Center

FAQ > 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