Error: Entra ID Replication Always Runs from Scratch Due to Domain Case Sensitivity
Related Queries
- "Directory Manager 11 EntraID replication always runs from scratch"
- "Replication does not use stored timestamps to perform delta updates"
- "Getting delta Groups from server. ShouldGetObjectsFromScratch = True"
Symptoms
- Replication cycles against Microsoft Entra ID stores take many hours (for example, 19 hours for approximately 6,500 groups).
- Replication logs show
ShouldGetObjectsFromScratch = Trueon every run. - Replication does not use stored timestamps and always performs a full sync.
Cause
This issue occurs due to a case sensitivity mismatch in the SVC.IdentityStoreReplication table:
- The database stores the domain as
domain.org(lowercase "d"). - The replication engine expects
Domain.org(uppercase "D").
Because the check is case-sensitive, the system fails to find the existing timestamp and assumes it must replicate from scratch.
Resolution
-
Identify the affected Entra ID store(s):
SELECT is1.IdentityStoreId, is1.IdentityStoreName, st.StoreTypeNameFROM SVC.IdentityStore is1JOIN SVC.StoreType st ON is1.StoreTypeId = st.StoreTypeIdWHERE st.StoreTypeName LIKE '%Entra%' OR st.StoreTypeName LIKE '%Azure%';Note the IdentityStoreId of the production Entra ID store.
-
Verify current domain values:
SELECT isr.IdentityStoreId,is1.IdentityStoreName,isr.Domain,isr.TimeStampsFROM SVC.IdentityStoreReplication isrJOIN SVC.IdentityStore is1 ON isr.IdentityStoreId = is1.IdentityStoreIdWHERE isr.IdentityStoreId = <IdentityStoreId>;If you see the domain in all lowercase letters (e.g.,
domain.org), this confirms the mismatch.If the domain already matches the correct title case (e.g.,
Domain.org), no change is needed. -
Backup the table (precaution):
SELECT *INTO dbo.IdentityStoreReplication_Backup_<yyyymmdd>FROM SVC.IdentityStoreReplicationWHERE IdentityStoreId = <IdentityStoreId>; -
Correct the domain casing:
UPDATE SVC.IdentityStoreReplicationSET Domain = 'Domain.org'WHERE IdentityStoreId = <IdentityStoreId>AND Domain = 'domain.org'; -
Re-run the verification query from Step 2. The domain should now be stored in the proper case (e.g.,
Domain.org). -
On the next replication cycle, confirm in the logs:
ShouldGetObjectsFromScratch = False- Replication runtime drops significantly (minutes instead of hours).
- Only changed groups are processed.
Risk and Rollback
- Risk level: Low – the update changes only the casing of the domain value.
- Rollback: Restore from the backup table created in Step 3 if needed.
Additional Notes
- This issue is environment-specific and not widespread.
- If Directory Manager 11 Entra ID replication always runs from scratch, check the domain casing in SVC.IdentityStoreReplication. Correcting a single character in the domain field (lowercase “d” → uppercase “D”) restores delta replication and reduces runtime from hours to minutes.