SDS Errors

Errors and remediation

The following table contains common errors that you may encounter after you enable sync for a sync profile in School Data Sync. The "Steps to remediate" column contains recommended steps for correcting the errors listed, often referencing the more detailed attribute validation steps listed in the Troubleshoot attribute mappings and values section of this article.

Error Entity Action Steps to remediate
AzureActiveDirectoryInvalidPropertyValue
Section
Add
The Section has an invalid mailNickname value and can't create the appropriate target object in Azure. Check the values for the section to ensure they contain only alpha numeric characters and no whitespace, as this value is used to create the smtp address of the O365 Group in Azure.
UnsynchronizableChange
Student
Add
Check if Source attribute matches Target attribute for this teacher. Steps for checking source and target listed in this article. Also, check to make sure the domain suffix setting in the sync profile is correct, and set to append the source attribute if that is required for the match to be completed successfully.
UnsynchronizableChange
Teacher
Add
Check if Source attribute matches Target attribute for this teacher. Steps for checking source and target listed in this article. Also, check to make sure the domain suffix setting in the sync profile is correct, and set to append the source attribute if that is required for the match to be completed successfully.
DuplicateTargetEntries
Student
Add
Two users exist with the same SIS ID in the source directory
InvalidLookupReference
SchoolStudents
Update
The student was unable to be added to the school. If the Student failed to sync or/add initially, this student will subsequently fail to add to the school. If this error occurs, check if the student has synced in the organization tab of the SDS portal. If not, remediate the sync/add error for the student. Also, confirm the School SIS ID is correct for this student, and if the school was in scope for sync.
InvalidLookupReference
SchoolTeachers
Update
The teacher was unable to be added to the school. If the teacher failed to sync/add initially, this teacher will subsequently fail to add to the school. If this error occurs, check if the teacher has synced in the organization tab of the SDS portal. If not, remediate the sync/add error for the teacher. Also, confirm the School SIS ID is correct for this teacher, and if the school was in scope for sync.
InvalidLookupReference
TeacherRoster
Update
The teacher was unable to be added to the section. If the teacher failed to sync/add initially, this teacher will subsequently fail to add to the section. If this error occurs, check if the teacher has synced in the organization tab of the SDS portal. If not, remediate the sync/add error for the teacher. Also, confirm the Section SIS ID is correct for this teacher, and if the section was in scope for sync.
InvalidLookupReference
StudentEnrollment
Update
The student was unable to be added to the section. If the student failed to sync/add initially, this teacher will subsequently fail to add to the section. If this error occurs, check if the student has synced in the organization tab of the SDS portal. If not, remediate the sync/add error for the student. Also, confirm the Section SIS ID is correct for this student, and if the section was in scope for sync.
None
Section
Add
Duplicate record exists or an invalid character exists in the name.
None
Student
Add
DisplayName for the student has invalid characters.
UnSpecified
Student
Update
The SIS ID of the student is invalid or is related to a student/user that did not successfully sync.
AzureActiveDirectory ObjectMissingDependantLicense (All one string, but broken here to make this table readable.)
Student Teacher
Add Update
This error can occur if SDS is attempting to assign a license to a user, but a dependent license is not currently assigned to the user. For example, the Classroom license requires the user must already have a license for Exchange Online and SharePoint Online. To address this, assign the dependent license, and re-run sync.
AzureActiveDirectoryNoAvailableLicenses
Student Teacher
Add Update
This error code can occur if SDS attempted to assign a license that is either expired or exhausted (All available licenses of this type have been assigned). To remediate, add more licenses of this type, to allow for additional assignments through SDS.
AzureActiveDirectoryInvalidLicense
Student Teacher
Add Update
This error occurs if SDS attempted to assign a license which is not present within the tenant. For example, if the tenant does not contain the Classroom Subscription and Licenses, but SDS attempts to assign Classroom Licenses to Teachers or Students, this error will be generated.
AzureActiveDirectoryReplicaUnavailable
School Section Student Teacher
Add Update
This error occurs is an AAD Graph Replica Server is unavailable. These errors are transient, and do not need any action from users. These errors will resolve themselves over time.
AzureActiveDirectory LastOwnerOfGroupCannotBeRemoved (All one string, but broken here to make this table readable.)
Teacher Roster
Delete
A teacher could not be removed from a class/group because a class/group must have at least one teacher.
AzureActiveDirectory RequestThrottledTemporarily (All one string, but broken here to make this table readable.)
This is a transient error that could occur due to throttling when processing a large amount of data. No action is required from user, and error should fix itself on a subsequent sync cycle.
UnmatchedEntry
Could not find a matching entry in Azure Active Directory for sync
AzureActiveDirectoryImmutablePropertyUpdateFailed
An attempt was made to update a property that cannot be updated. Please contact support
AzureActiveDirectoryInvalidUserPrinicipalNameFormat
UPN for the user is not in a valid format. Please check the source data and identity matching options
AzureActiveDirectoryInvalidUserUsageLocation
License Assignment failed for the user since the user does not have a Usage Location set. Please update the user from Office Admin Portal

Exporting errors and prioritizing remediation

When you encounter errors in School Data Sync, any errors associated with sync will be displayed on the sync profile summary page, after clicking on the Sync profile. The top errors will be displayed first, and will be actionable. We suggest you take action on these errors first. You can also view and export all sync errors associated with a given sync profile, for review and remediation purposes.

The steps below detail how to export errors for a given sync profile.

  1. Log into the SDS portal (sds.microsoft.com).
  2. Click on the sync profile you'd like to review errors for.
  3. Click the Download these Errors button to export the errors into a CSV file.
    errors-and-troubleshooting-1.png errors-and-troubleshooting-2.png
  4. Click ok when prompted.

Prioritizing errors for remediation

When troubleshooting errors in School Data Sync, it's always recommended that you prioritize Top Errors or ahead of troubleshooting any other error types in the All Errors view. This is because any instance of a Top Error may result in numerous subsequent errors for each instance, within the same sync profile. Often, remediating Top Errors will subsequently remediate many roster-related errors that also show in the all errors list, within the profile. This is the recommended method for remediating errors in bulk, in the most efficient manner possible.