Duplicate or Incorrect Data Due to Overlapping Area Paths

Issue

Duplicate or Incorrect Data Due to Overlapping Area Paths.

Environment

Connector: Azure DevOps

Resolution

To resolve this issue, do one of the following:

Update Area Path configuration in Azure DevOps to ensure that Area Paths do not overlap. Each Area Path should be uniquely scoped to avoid duplicate data ingestion.
Contact Fivetran Support to reset the cursor values for the affected Area Paths to their initial state.
Trigger a re-sync to re-import the corrected data.

Cause

The issue occurs when multiple Area Paths in Azure DevOps overlap or are hierarchically nested, causing the same work items to be included in more than one scope. Since the connector extracts data based on the configured Area Paths, overlapping paths result in duplicate ingestion of the same records. For example, if both a parent Area Path such as Project and its child Area Path such as Project/TeamA are configured, work items belonging to TeamA may be fetched twice—once under the parent path and once under the child path.

Additionally, since the connector uses incremental syncs based on cursor values, previously ingested overlapping data may persist even after configuration changes. This can lead to continued duplication or inconsistencies until the cursors are reset and the data is re-synced.