This lesson outlines potential errors that come up when using the Ed-Fi integration and possible resolutions.
Error Messages

This occurs when an assessment has duplicate values in the label column of their assessment. To resolve:
- Open the Ed-Fi log via the settings cog → Manage EdFi Logs.
- Set the start date to the prior date if the daily sync has not yet run.
- Enter “StudentAssessmentItems enumerable contains duplicate” in the search box.
- Run the SQL below adding all assessment_id values in the Event Parameters column to the WHERE statement.
- Work with the assessment author to update the assessment to no longer use duplicate assessment item labels. The assessment data will properly sync to your Ed-Fi ODS after making that change.

This occurs when the value in the label column pictured below has a leading or trailing whitespace. To resolve:
- Open the Ed-Fi log via the settings cog → Manage EdFi Logs.
- Set the start date to the prior date if the daily sync has not yet run.
- Enter “cannot contain leading or trailing” in the search box.
- Run the SQL below adding all assessment_id values in the Event Parameters column to the WHERE statement.
- Please open and edit each assessment, and remove any whitespaces you find before or after the label. The assessment data will properly sync to your Ed-Fi ODS after making that change.

It is likely that this is related to orphaned student assessment associations because a student who took the assessment does not exist in the ODS. Typically, only currently enrolled students are in the Ed-Fi ODS.
This occurs when an assessment has a question group with leading or trailing whitespace. Remove the whitespace.

This occurs when an assessment has a question group with a blank label. You will see in the screenshot below, the assessment has two question groups and the first one’s label is blank. The customer needs to complete that field.
To resolve:
- Search the Ed-Fi logs with the value “IdentificationCode is required”.
- Run the DnA SQL query below, adding all assessment ids that are displayed in the Event Parameters column.
- Work with your teachers to edit each assessment and add a label to each question group. Below is the process for doing that:
- Open the assessment.
- Click on Setup → Question Groups.
- Add a label name to each assessment question group.
- Click Save.
The assessment data will properly sync to your Ed-Fi ODS after making these updates.


This occurs when an assessment is using a performance band set that has duplicate labels. The screenshot below is an example of an assessment that’s using two performance bands with the same label (Mastered). To resolve:
- Search the Ed-Fi logs with the value “AssessmentPerformanceLevels enumerable contains duplicate”
- Run the DnA SQL query adding all assessment ids that are displayed in the Event Parameters column
- Please work with your teachers to edit each assessment and give each performance band label a unique name. The assessment data will properly sync to your Ed-Fi ODS after making these updates.


This occurs when an assessment has a question group that is longer than 60 characters. You will see in the screenshot below, the assessment has two question groups that are longer than 60 characters.
Please work with your teachers to edit each assessment and reduce the number of characters in a question group label to 60. The assessment data will properly sync to your Ed-Fi ODS after making these updates.
DnA Query:


