Support Article
Duplicate pzInsKey created when refreshing a work object
SA-4748
Summary
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.
Error Messages
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
Root Cause
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.
Resolution
This issue is resolved by modifying the work table in the database to specify pzInsKey as the primary key.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.