none
FIM Service SQL Exception - Procedure UpdateResource RRS feed

  • Question

  • 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!

    Tuesday, July 21, 2015 7:33 PM

All replies

  • 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? 


    Nosh Mernacaj, Identity Management Specialist

    Tuesday, July 21, 2015 7:46 PM