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

Vaishnavi35
Tera Guru

Hi,

 

Vaishnavi35_0-1718217414272.png

 

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

How to fix this?

 

Thanks,

Vaishnavi

 

1 ACCEPTED SOLUTION

AshishKM
Kilo Patron
Kilo Patron

Hi @Vaishnavi35 , 

Based on shared log details, there is insert query running over task table which is adding program record, and the sys_id showing in the unique key voilation belongs to one of PGM record.

Please check the code without this PGM record code, comment that part and test it again. It should work.

 

-Thanks,

AshishKM

 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

View solution in original post

17 REPLIES 17

Hi ,

 

But I want the demand number to populate onto the RITM Variable form.

 

Thanks,

Vaishnavi

Hello, 

 

Change the ordre of two business rules:  assign the lower order to the business rule that creates the demand,  and the higher order to the one that creates the ritm.  

 

AshishKM
Kilo Patron
Kilo Patron

Hi @Vaishnavi35 , 

Based on shared log details, there is insert query running over task table which is adding program record, and the sys_id showing in the unique key voilation belongs to one of PGM record.

Please check the code without this PGM record code, comment that part and test it again. It should work.

 

-Thanks,

AshishKM

 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution