Duplicate pzInsKey created when refreshing a work object
If you click the refresh option while running a supporting process on an existing work object and then submit the action, a duplicate pzInsKey record is created in the table.
More than one result for pzInsKey "SAMPLE-WORK S-213"; please ensure your database has its pzInsKeys set properly. code: <none> SQLState: <none> Message: <none>
Steps to Reproduce
- Open a work object that was previously created
- Run a supporting process on the work object
- While in the supporting process flow, choose Other Actions => Refresh. Then submit to finish the flow
- Try to perform another action on the work object
The root cause of this problem is a defect in customer application code/rules. The work table did not specify pzInsKey as the primary key.
This issue is resolved by modifying the work table in the database to specify pzInsKey as the primary key.