Summary

A developer asks: I'm receiving an error message that there is more than one result for pzInsKey, and that I should ensure that my database has its pzInsKey set properly. This happens for covered work objects.

What do I need to do to make sure that pzInsKey properties are set properly so that such duplicates are not created?

Suggested Approach

If you have created a copy of the database table pc_work to hold work objects, examine the pc_work database constraints. Make sure that your copy of the pc_work table matches those exactly. 

Unless the constraints are included in your cloned table, you'll get duplicate work objects that could produce the message you're seeing.

Examine the schema for pc_work closely.  That may reveal changes you must make to your clone. 

For example, inside the schema to pc_work there is a reference to pc_work, so you have to update your copied table name to reference itself, similarly.