Close popover
Anirban Guha (AnirbanGuha25)
senior software engineer
AnirbanGuha25 Member since 2014 1 post
Posted: August 30, 2019
Last activity: September 3, 2019

Unique constrain PR_ASSIGN_PK is violated for PR_ASSIGN table

I am currently facing an intermittent prod issue, which i am not able to replicate in lower environment. In this scenario user tries to submit a case, which has a pageList under pyWorkPage. On submission, system should create new work object for each page of that pagelist (say if there are 5 pages in that pagelist, then 5 new work object should be created) and the first case in which the pagelist exists would be resolved. However at times those new work objects are not being created but system resolves the first case. After adding some exception step we have come to know that, in this fail scenario unique constrain PR_ASSIGN_PK(associated with pzinskey) is violated for PR_ASSIGN table. And in this scenario obj save operation for PR_ASSIGN table is executed from Assign- Add_Assign activity.

I have gone through some article related to this type of issue, which mostly indicated about background agent processing or creating temporary cases on the same page where the new work objects are created or External user's parallel action. However these theories are applicable in my scenario.

Please advise.

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Case Management
Moderation Team has archived post