-
Title
Active Roles Sync Service Workflow fails after moving Synchronization database from SQL 2008 to SQL 2016. -
Description
When moving the Synchronization database from a 2008 SQL Server database to a 2016 SQL Server database, workflows may fail with the error similar to the following:
Sync workflow execution failed. Sync workflow name: {WORKFLOW NAME} Run ID: 21 User name: - List of steps: Step Id: [d9d06f86-e25f-4951-9385-536b222e09a3], Step name: [STEP NAME, Errors: [0] Error details: Synchronization steps aborted. Details: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. The wait operation timed out
-
Cause
Cause may be that the SQL database compatibility mode needs to be set to the previous database mode, which in the case where the Synchronization database was moved from SQL 2008 to SQL 2017 the SQL Server compatibility level needs to be SQL 2008. -
Resolution
Modified the SQL database compatibility mode to run as the previous version of SQL Server used rather than the updated version.
For more information on Microsoft SQL Server compatibility levels of a database please visit the link below.
How to view or change the compatibility level of a database