What is the cause for this error?

Madhu92
Tera Contributor

ErrorUnique Key violation detected by database ((conn=86882) Duplicate entry '93e4e5aa33785610ef1d80a34d5c7b4d' for key 'PRIMARY').

 

When submit a request through ESC portal it shows the above error and the request is created

4 REPLIES 4

anvesh_v
Giga Guru

Could you please validate any current.setAbortaction exists in business rules 

Sai_Charan_K
Kilo Sage

Hi @Madhu92 ,

 

The error states that already a record exists with the same name in the table where you are trying to insert and is giving the sys_id of the already existing record i.e. "93e4e5aa33785610ef1d80a34d5c7b4d".

 

Request may be created but did you try verifying whether the record which you are trying to create has been created or not through your request? If not then please verify and change the script accordingly.

 

Please mark this answer "Helpful" and "Correct" if you feel this has helped you in anyway.

 

Thanks and Regards,

K. Sai Charan

Sr. ServiceNow Developer 

Deloitte India 

Sagar Pagar
Tera Patron

Hi @Madhu92,

 

Check is there any before insert/ update business rule with current.update() on your table.

 

Thanks,

Sagar Pagar

The world works with ServiceNow

Anurag Tripathi
Mega Patron
Mega Patron

For any of the fields that are supposed to be unique(Primary key) , there is a duplicate getting inserted. 

EG, Number 

-Anurag