Error: Sync Failed and Reconnect Error Appears Due to Projects Not Found

Issue

While running a sync for the Azure DevOps connector, the following reconnect error appears:

Projects not found

Environment

Connector: Azure DevOps

Resolution

To resolve this issue, follow the steps below in order:

1. Verify that the organization name in your Fivetran setup is correct and that your Azure DevOps organization contains at least one active project.

2. In Azure DevOps, go to Organization settings > Security > Policies and enable Third-party application access via OAuth.

3. Confirm that the user or service account used by Fivetran meets the following requirements:

   • Is a member of the Azure DevOps organization.
   • Has Reader access at the organization level.
   • If you are using a personal access token (PAT), ensure it includes the Project and Team (Read) and Graph (Read) scopes.

4. Re-authorize the connection in Fivetran:

   i. Go to your Azure DevOps connection page.

   ii. Select the Settings tab.

   iii. Click Edit connection.

   iv. Click Re-Authorize Connection to refresh the authentication token, or click Save & Test if you are using a PAT.

5. In the top right, click Sync. This verifies that Fivetran can retrieve projects and that the error no longer appears.

Cause

This issue occurs when Fivetran cannot access Azure DevOps projects because the user or service account does not have the required permissions. Azure DevOps may return TF400813: Not Authorized if the account lacks access, OAuth is disabled, or the token is missing required scopes. Consequently, we display the above error when we cannot retrieve projects from your organization.