I am getting "Unique Key violation" "Duplicate entry" error. How to fix that?

[Vaishnavi35]

Hi,

I am getting this error when I click on "Accept" button on Idea form. 

How to fix this?

Thanks,

Vaishnavi

[Vaishnavi35]

Hi @James Chun ,

I have installed the Chrome plugin. Do I have to search with sysID in Tables column? Because I did and no records to display.

I have search in all the tables you mentioned. Here as well it says no records to display.

Thanks,

Vaishnavi

[James Chun]

Hi @Vaishnavi35,

You can use the slash command, i.e. /sysid {your sysid}

e.g.

If there is a record with the sys_id, it will show where the record resides.

Once that is determined, we can investigate further what is causing the issue.

Additionally, have a look at the system log as well. It can indicate where it's coming from.

[Vaishnavi35]

Its coming from Program record. PGM Record.

Its not creating a record in Program table, whatever sys_id is shown in the error is actually the sys_id of the existing program record.

But in my code "BR to create RITM when Idea is Accepted" , I have not used or referenced program table. You can check in the code above.

Thanks,

Vaishnavi

[James Chun]

Maybe you have a process on another table that is creating the same PGM record?

Do some debugging with Script Tracer.

[Hajar BENJAHHAR]

Hello Vaishnavi35, 

Disable this line of code and verify if the problem still persists.