PRPC freeze during 'FinishAssignment' activity call in the flow
Sporadically, PRPC freezes while completing an assignment in a flow. We a custom button to go from one assignment (screen) to the other in the flow. Getting database exceptions inserting to pc_assign_worklist table. As per dynaTrace, it occurs during 'FinishAssignment' activity call.
Yes, there is a connector at this specific example. However, the issue occurs at other assignments also (when moving from one assignment to the other) sporadically where there are no connectors/utilities.
If there is a utility/connector shape between the two assignments and Rollback is called in the activity associated with the utility/connector shape, then there is a chance for insert error with workbasket/worklist table.
The reason is that only one assignment is allowed for each executing flow on a work object.
Usually finish assignment will delete current assignment and create next assignment with in one transaction, however if there is a rollback occur between two assignments, the first assignment will not be deleted hence the second assignment can not be created.