Ed-Fi Troubleshooting

This occurs when an assessment has duplicate values in the label column of their assessment. To resolve:

1. Open the Ed-Fi log via the settings cog → Manage EdFi Logs.
2. Set the start date to the prior date if the daily sync has not yet run.
3. Enter “StudentAssessmentItems enumerable contains duplicate” in the search box.
4. Run the SQL below adding all assessment_id values in the Event Parameters column to the WHERE statement.
5. 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 has a leading or trailing whitespace. To resolve:

1. Open the Ed-Fi log via the settings cog → Manage EdFi Logs.
2. Set the start date to the prior date if the daily sync has not yet run.
3. Enter “cannot contain leading or trailing” in the search box.
4. Run the SQL below adding all assessment_id values in the Event Parameters column to the WHERE statement.
5. 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 the learning standard used in the assessment does not exist in the customer’s ODS. The Event Parameters column of the error log will list all learning standards utilized by the assessment. The log is not saying that all learning standards in the assessment are not in the ODS, but at least 1 is missing and therefore the data is not getting through.

Learning standards can be missing from the ODS due to two primary reasons, either the customer added custom standards to DnA and needs to bring those into the ODS or Academic Benchmarks needs to sync an additional standard collection into the customer’s ODS.

To resolve:

1. Open the Ed-Fi log via the settings cog → Manage EdFi Logs.
2. Set the start date to the prior date if the daily sync has not yet run.
3. Enter “The value supplied for the related 'objectiveassessmentlearningstandard' resource” in the search box.
4. Run the Ed-Fi ODS Query replacing the learningstandardid with each ID in the error log.
5. Note each learning standard id that is not in the ODS.
6. Run the DnA Query below for each learning standard id not in the ODS. Note whether the learning standard is custom or not.
7. If the learning standard is not a custom standard, Academic Benchmarks will need to load in the standards collection that contains the learning standard the assessment is utilizing. If it is a custom standard, the client is responsible for for loading it into the ODS.

Ed-Fi ODS Query:

DnA Query:

This occurs when specific item results fail to make their way to the ODS. The error is specific to an assessment and student. The assessment and overall result likely made it in, but item level results are failing. DnA will automatically try sending the data again during the next sync. However, if a specific error has persisted across many syncs, the steps below should be performed:

1. Open the Ed-Fi log via the settings cog → Manage EdFi Logs
2. Set the start date to the prior date if the daily sync has not yet run
3. Enter “The value supplied for the related 'studentassessmentitem' resource” in the search box
4. Run the SQL query below to determining the assessment author
5. Search the author in DnA and impersonate their account
6. Navigate to the assessment
7. Share the assessment with the System Admin (or power user with all permissions)
8. Return to System Admin user and navigate to the assessment
9. Append &page=Assessment_EdfiPushController to the end of the URL and click “Force Push”

The steps above will cause DnA to push the assessment during the next sync. Check logs after that has completed to see if the error has been resolved.

DnA Query:

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 above, the assessment has two question groups and the first one’s label is blank. The customer needs to complete that field.

To resolve:

1. Search the Ed-Fi logs with the value “IdentificationCode is required”.
2. Run the Illuminate SQL query below, adding all assessment ids that are displayed in the Event Parameters column.
3. Work with your teachers to edit each assessment and add a label to each question group. Below is the process for doing that:
   1. Open the assessment.
   2. Click on Setup → Question Groups.
   3. Add a label name to each assessment question group.
   4. 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 above is an example of an assessment that’s using two performance bands with the same label (Mastered). To resolve:

1. Search the Ed-Fi logs with the value “AssessmentPerformanceLevels enumerable contains duplicate”
2. Run the Illuminate SQL query adding all assessment ids that are displayed in the Event Parameters column
3. 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 above, 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: