HRIS S3 connector sync error: Duplicate position IDs

This page helps you resolve a synchronization error where multiple active positions in your HRIS S3 data share the same external ID.

Symptom

When syncing users with the HRIS S3 app, the sync fails and you see the following error in your logs:

Position with external ID {externalId} - externalId: Duplicate id. Active position ids must be unique

Cause

Talent requires every active position to have a unique externalId. This error occurs when your positions report CSV contains multiple active rows with the same positionId.

Resolution

To resolve this issue, you must identify the duplicate positions in your CSV data and ensure only one is marked as active.

Step 1: Identify the affected positions

1. Download your positions report CSV from your S3 bucket.

2. Search for the positionId that matches the {externalId} provided in the error message.

3. If you find only one position (or none), the CSV data may have been updated since the last sync attempt. Try to re-sync the connector to see if the issue is resolved.

4. If you find multiple positions with the same ID, check the isActive column for each.

5. If only one position has an isActive value of 1, try to re-sync the connector. If multiple positions are marked as 1, continue to the next step.

Step 2: Fix the duplicate IDs and upload

You can resolve this in one of two ways:

• Update your positions report CSV to remove or change duplicate positionId values so that each active position is unique.

• Update the CSV so that only one position with that ID has an isActive value of 1. Set all other duplicates to 0.

Once you have updated the CSV, upload it to your S3 bucket.

Step 3: Re-sync

1. Go back to the HRIS S3 connector in Atlassian Administration (Connected apps > HRIS S3).

2. Select the Settings tab.

3. Select Sync now to sync the update that fixes the error.