Unique Key Violation error

cipla
Giga Contributor

Hi All,

Whenever I try to create a new Standard Change and select a template, an error message is displayed every time- " Unique Key violation detected by database (Duplicate entry '741ad1404fa37a00445cecd18110c73b' for key 'PRIMARY') "

I have checked Dictionary for all fields in Standard Change Form for Unique checkbox true, but all are false still it displays this error. The sys_id in the error message is different everytime I create new Standard change. How can I get rid of this error.

find_real_file.png

1 ACCEPTED SOLUTION

Ivano B
ServiceNow Employee
ServiceNow Employee

Hi Arpita



Make sure you don't have current.update in any of the business rules created.


Can you go to the BR table and check script contains current.update()   and when is before in the filter conditions.



Cheers


R0b0


View solution in original post

5 REPLIES 5

Chuck Tomasi
Tera Patron

I found something similar related to business rules being fired at the wrong time.



You may find this helpful.


how to remove Unique Key violation detected error in change form once record is submitted



Related to BRs...


Business Rules Best Practices - ServiceNow Wiki  


Ivano B
ServiceNow Employee
ServiceNow Employee

Hi Arpita



Make sure you don't have current.update in any of the business rules created.


Can you go to the BR table and check script contains current.update()   and when is before in the filter conditions.



Cheers


R0b0


cipla
Giga Contributor

Hey thanks for the reply.. It worked..


Hi Robo,

 

We are facing same issue in our portal. but we r not using current.update() in business rule but still this issue is coming.

can u help us. why this is happening.