Unique Key violation detected by database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-28-2018 09:11 PM
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
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2018 12:09 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2018 02:22 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2018 03:31 AM
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.
Regards,
Shloke