Unique Key violation detected by database

Kaka Nayeem
Tera Guru

Hi All,

      Iam getting an error while order catalog item 'Unique Key violation detected by database (Duplicate entry 'in_process' for key 'a_str_3').

    Any suggestion?

Regards,

Kaka Nayeem

7 REPLIES 7

Mrudula6
Mega Guru

Hi,



Unique key violation usually occurs if you trying to update double update record.For ex, if you have current.update() in your before insert business rule. Check your scripts for this particular catalog item.


Hi,


We don't have any before Business rule but i have written current.update in after business rule


After receiving 'Duplicate entry' error, all request table records were deleted.



Any Suggestion?



Regards,


Kaka Nayeem


Hi,



Enable Business rule debugging and check, as mentioned above by others it should be some Business rule which is causing this conflict. Check for some your workflow too.


Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke