FIM Deadlock Errors

Database

SPID

Victim

Procedure

LockMode

Waitresource

Code

ClientApp

HostName

FIMService

1000

1

FIMService.fim.AddObjectValueReference

R

KEY: 13:72057609323806720 (37c

INSERT INTO [fim].ObjectValueReference ( ObjectKey, ObjectTypeKey, AttributeKey, ValueReference ) VALUES ( @ObjectKey, @objectTypeKey, @AttributeKey, @value );

.Net SqlClient Data Provider

VSRPDC2INF005

Microsoft.ResourceManagement.WebServices.Exceptions.UnwillingToPerformException: Other ---> System.Data.SqlClient.SqlException: Reraised Error 50000, Level 13, State 1, Procedure ReRaiseException, Line 37, Message: Reraised Error 50000, Level 13, State 1, Procedure ReRaiseException, Line 37, Message: Reraised Error 1205, Level 13, State 49, Procedure AddObjectValueReference, Line 18, Message: Transaction (Process ID 1000) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.    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.ProcessRequest(RequestType request)    --- End of inner exception stack trace ---
February 20th, 2015 1:57am

What is the question or issue you have?

Free Windows Admin Tool Kit Click here and download it now
February 21st, 2015 4:36pm

The deadlock occurs due to unavailability of enough resources to perform the action or one or more activity is performing an action to update the same resource at same instance of time. So would like to help more but please provide the information on what the issue is.

February 24th, 2015 3:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics