Unique Key violation detected by database ((conn=2248722) Duplicate entry 'a7df393e875b12900f72ea8f8

[BijoyDeb]

Hi All,

I have a record producer which if submitted creates catalog tasks for different teams for custom ticket that will get created.

I am getting this error when i am trying to click submit on record producer

Unique Key violation detected by database ((conn=2248722) Duplicate entry 'a7df393e875b12900f72ea8f8bbb35d2' for key 'PRIMARY') 

Also, when I checked for sys id, turns out it has created a record in task table with all details that I have used to create catalog task from my workflow.

I am not getting how this is happening. Has anybody faced similar issue before?

[Sandeep Rajput]

@BijoyDeb Please check this thread and see if it helps https://www.servicenow.com/community/developer-forum/i-am-getting-this-unique-key-violation-detected...

[Runjay Patel]

Hi @BijoyDeb ,

Share your code to identify the issue. There is an issue with your code.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[Ankur Bawiskar · Accepted solution]

@BijoyDeb 

Please share your record producer configuration and record producer script

seems you are doing current.insert() in the Record producer script.

If my response helped please mark it correct and close the thread so that it benefits future readers.