Return
-
Title
Active Roles Synchronization Service Workflow intermittently fails when product databases are hosted on SQL 2014 or later -
Description
Active Roles Synchronization Service Workflow Sync Step intermittently fails with the following error: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 outSometimes, the Workflow completes without error.The dataset in the associated Workflow Sync Step is very large, including one hundred thousand objects or more. This error may also be encountered in smaller datasets where SQL resources are constrained. -
Cause
Active Roles Synchronization Service queries are not optimized to use the new cardinality estimator (CE) introduced in SQL 2014 and later versions.
This issue is being tracked as Enhancement Request ID 273156.
-
Resolution
WORKAROUNDSet the database compatibility level on the Active Roles Synchronization Service database(s) to 100 (SQL 2008R2).
For more information, please see this Microsoft resource:How to view or change the compatibility level of a database
STATUSAn Enhancement Request has been created to change existing Active Roles functionality.
Product Management will evaluate the request and this feature may become available in a future release of the product.There are no guarantees that this specific enhancement request will be implemented in a future release. For more information regarding our Enhancement Request policy, refer to our Global Support Guide on the Support Portal at: https://support.oneidentity.com/essentials/support-guide/ -
Change Request
273156