FIM Service SQL Exception - Procedure UpdateResource

Hi,

We are getting following exception when multiple workflows are trying to modify the same single valued attribute on the same object. 

System.Data.SqlClient.SqlException: Reraised Error 50000, Level 14, State 1, Procedure ReRaiseException, Line 37, Message: Reraised Error 50000, Level 14, State 1, Procedure ReRaiseException, Line 37, Message: Reraised Error 2601, Level 14, State 1, Procedure UpdateResource, Line 575, Message: Cannot insert duplicate key row in object 'fim.ObjectValueString' with unique index 'IX_ObjectValueString_ObjectKey_AttributeKey_LocaleKey-Filtered_Multivalued'. The duplicate key value is (179755, 32507, 127).

is there any workaround available to resolve this issue? Appreciate your help. Thanks!

July 21st, 2015 3:35pm

I do not believe you can make this work without changing the behavior of the workflows.

Just curious, why would you want to have this anyways? 

Free Windows Admin Tool Kit Click here and download it now
July 21st, 2015 3:48pm

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

Other recent topics Other recent topics