Troubleshooting: duplicate pzInsKeys error after setting up a copy of the pc_work table
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?
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.