Common Data Ingestion Errors

Data Ingestion Error Troubleshooting

After ingesting your data, you may come across some errors. These errors will need to be resolved before moving forward. They will appear under the Ingestion Report on the right side after you ingest your Baseline or Transcript data.

To further troubleshoot the error, you can click on "Preview Resources" which will allow you to pinpoint the exact cells that are problematic and need to be fixed.

In the screenshot, we are seeing one of the errors as an "Incorrect Data Type" originating in the students.csv file. When you click on Preview resources, we see that the external_id of the student is listed, along with the grade level. In this case, the grade level has a typo and is displaying as i2 as opposed to 12. To resolve this you would need to go back into the students.csv file, fix this typo, then reupload and ingest the file.

Continuing with the example of errors in the screenshots, you will see the second error is telling us the courses.csv file is missing an entire column which is departments. To correct this, you would need to go into the courses.csv and add the "departments" column as stated in the file specs you received from your support lead.

Common Errors

This chart will show you the common errors you may see and why you are seeing them. The Preview Resources button will then tell you where to fix that error.

Error Category	Tooltip	Potential Fixes
Missing Column	This type of error occurs when a CSV file does not have all required columns present.	Refer to the file specifications to ensure that the values are in the correct format and all required values are included.
Missing Data	This type of error occurs when a cell in a CSV has blank or null values.	Refer to the file specifications to ensure that the values are in the correct format and all required values are included.
Incorrect Data Type	This type of error occurs when the value presented is of the wrong type. Ex: if the given value is a string when the expected value is a number.	Refer to the file specifications to ensure that the values are in the correct format and all required values are included.
Unmapped or Non-standard Value	This type of error occurs when values in the data do not match Abl standard values. Non-standard values can be mapped to standard values in the Dictionary page.	Check the Dictionary to map unmapped values
Invalid Data	This type of error occurs when the data in a CSV field contains a value we don’t accept for an unmappable field, but the data type is correct. Ex: if the given value is "foo" when the expected value is "true" or "false".	Refer to the file specifications to ensure that the values are in the correct format and all required values are included.
Unrecognized Exceptions	This type of error occurs when there is an issue on Abl’s end, such as a connection issue. The Abl team has been notified of this error. Feel free to re-try your ingestion or contact support for additional assistance.	Click “Contact Support” under the ingestion report
Referential Integrity Error	This type of error occurs when a CSV has a resource with a value in a field that cannot be looked up in a base resource. For instance, a course request CSV is referring to a course which does not exist at the organization.	Click “Contact Support” under the ingestion report
Uncategorized Error	This error falls outside of our standard error categories, or has not yet been categorized. The Abl team has been notified of this error. For assistance with this error please contact support.	Click “Contact Support” under the ingestion report
Data Integration Error	This type of error occurs when there is an issue on Abl's end relating to how we configured your data integration. The Abl team has been notified and will correct the issue and re-run your ingestion. Feel free to also re-try your ingestion in a little while or contact support for additional assistance.	Click “Contact Support” under the ingestion report
Destructive Inactive Data Error	This type of error occurs when ingesting data would result in the destruction of resources or associations due to previously 'Active' resources such as students being marked 'Inactive' during ingestion. To prevent data loss, ingestion has been halted. Client Support will reach out to you shortly to confirm that the destruction of resources is intentional before continuing your ingestion.	N/A - Client support will reach out to you.
Destructive Missing Data Error	This type of error occurs when ingesting data would result in the destruction of a category of previously ingested data. Common causes of this are: 1) incorrect file name, 2) empty file, 3) file contains incorrect IDs, 4) other errors made during file generation. To prevent data loss, ingestion has been halted. Client Support will reach out to you shortly to confirm that the destruction of data is intentional before continuing your ingestion.	N/A - Client support will reach out to you.