What is the cause for this error?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 02:51 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 05:01 AM
Could you please validate any current.setAbortaction exists in business rules
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 06:05 AM - edited 09-25-2024 06:07 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 06:09 AM
Hi @Madhu92,
Check is there any before insert/ update business rule with current.update() on your table.
Thanks,
Sagar Pagar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 06:11 AM
For any of the fields that are supposed to be unique(Primary key) , there is a duplicate getting inserted.
EG, Number