Troubleshooting guide

Common errors that are encountered while uploading assessments are listed below, together with potential solutions. This troubleshooting table will be expanded over time.

Request help if the issue you are experiencing is not listed below and you need additional assistance.

Issue	Potential solution
Error related to file name (e.g., invalid assessment type or invalid district id).	View file formatting page for file naming conventions.
Zero matching student records found in ODS for file.	Make sure that the students who are listed in the assessment file are students who are currently active so they will match the students in your student information system.
File header format error	View the text and CSV files on the file formatting page for the required format for each assessment type.
Student mismatch errors	Remove inactive students from assessment file. Make sure that students' names and dates of birth match the names and dates of birth in the student information system. Some errors are associated with dual last names or hyphenated last names. Other errors occur with generational designation suffixes like "Sr.", "Jr.", "II", "III", etc.
Receive an error message indicating “cannot insert NULL”	Because an assessment score is matched with a student by using the student’s first name, last name, and date of birth, these fields MUST be populated accurately in the assessment file. For rows with missing data, either add in the missing information or delete the rows, rename the file (e.g., file_name_v2), and reload it. If this solution doesn’t work, please submit a help desk ticket.
File does not show up on import status screen	If you need to update a file and reload it, you must change the name of the file (e.g., file_name_v2) because the system will not allow you to upload the same file twice. Files will also not show up if zero students matched. If renaming the file doesn’t work, please submit a help desk ticket.
Red error message on import status screen	For ACT files only: Try to change the date format in the “test date” column to a date category with format type “Mar-12” and then reload the file. If this doesn’t work, please submit a help desk ticket.
Red error message on import status screen	For AP files only: Try to change the date format in the “date of birth” column to “text” and then reload the file. If this doesn’t work, please submit a help desk ticket.