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
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
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy