Workday connector sync error: Duplicate organization IDs

This page helps you resolve a synchronization error where multiple active organizations in Workday share the same external ID.

Symptom

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

Organization with external ID {externalId} - externalId: Duplicate id. Organization ids must be unique

Cause

Talent requires every active organization to have a unique externalId. This error occurs when your Workday organizations custom report contains multiple active organizations with the same organizationId.

Resolution

To resolve this issue, you must identify the duplicate ids in your Workday organizations report and ensure only one is marked as active.

Step 1: Identify the affected organizations

1. Open your organizations report in Workday.

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

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

4. If you find multiple organizations with the same ID, check the isActive field for each.

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

Step 2: Fix the duplicate IDs

You can resolve this in one of two ways:

• Update your organizations report in Workday to remove or change duplicate organizationId values so that each active organization is unique.

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

Step 3: Re-sync

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

2. Select the Settings tab.

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