none
SQL Deadlock: CalculateRequestSetTransitionsStatementEvaluation RRS feed

  • Question

  • Hello,

    I have an issue during the execution of TemporalEventsJob.

    On FIM Service, I have lot of alerts in Event viewer during the evaluation of SET Transitions. Each error is composed of 3 events:

    1/ Error Event ID 3:

    Reraised Error 1205, Level 13, State 51, Procedure CalculateRequestSetTransitionsStatementEvaluation, Line 153, Message: Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

    2/ Error Event ID 3:

    Microsoft.ResourceManagement.WebServices.Exceptions.UnwillingToPerformException: Other ---> System.Data.SqlClient.SqlException: Reraised Error 1205, Level 13, State 51, Procedure CalculateRequestSetTransitionsStatementEvaluation, Line 153, Message: Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader()
       at Microsoft.ResourceManagement.Data.DataAccess.EvaluateRequest(RequestType request, RequestEvaluationOptions options)
       --- End of inner exception stack trace ---

    3/ Warning Event ID 2 :

    Microsoft.ResourceManagement.WorkflowDataExchangeException: Microsoft.ResourceManagement.WebServices.Exceptions.PermissionDeniedException: ManagementPolicyRule
       at Microsoft.ResourceManagement.Workflow.Hosting.RequestWorkItemProcessor.DispatchRequest[TResponseType](RequestType request, Boolean applyAuthorizationPolicy)
       at Microsoft.ResourceManagement.Workflow.Hosting.RequestWorkItemProcessor.ProcessPutWorkItem(UpdateRequestWorkItem updateWorkItem)
       at Microsoft.ResourceManagement.Workflow.Hosting.RequestWorkItemProcessor.ProcessWorkItem(WorkItem workItem)
       at Microsoft.ResourceManagement.Workflow.Activities.FunctionActivity.FunctionActivityStoreResultComplete(Object sender, QueueEventArgs e)
       at System.Workflow.ComponentModel.ActivityExecutorDelegateInfo`1.ActivityExecutorDelegateOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
       at System.Workflow.Runtime.Scheduler.Run()

    This issue is not constant. For exemple I have no issue during 1 week, and one night, I encounter 4 or 5 errors on different objects.

    Do you see this issue ? Any idea of the origin ?

    I think there are bugs on the SPROC of CalculateRequestSetTransitionsStatementEvaluation, or during the search of MPR to apply. I see that requests on error doesn't have any applied MPR...

    Thank you.

    Anthony.

    Monday, March 24, 2014 9:30 AM

All replies

  • Hello,

    This issue appears again. Nothing during few months but many errors last week.

    Any idea ?

    Thank you

    Tuesday, December 2, 2014 10:24 AM
  • Hi,

    I have the same behavior on MPR change attribute workflow, did you get that fixed somehow? Thx


    • Edited by swarlyru Sunday, September 18, 2016 9:41 AM
    Saturday, September 17, 2016 3:44 PM