Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Troubleshooting: duplicate pzInsKeys error after setting up a copy of the pc_work table

Updated on November 15, 2015


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. 


  • Previous topic Troubleshooting: database error ORA-00904: Invalid Identifier on startup in new Oracle installation
  • Next topic Troubleshooting: "No Schema Name specified in WebServer for access" for DB2 UDB

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us