Support Article
Invalid pzInsKey encountered after 7.1.6 update
SA-1166
Summary
Error appearing in the log sporadically:
2014-08-25 15:49:52,408 [ PegaRULES-Batch-3] [ STANDARD] [ ] [ PegaRULES:07.10] (l.vtable.VirtualRulesTableImpl) ERROR - VTable can't load rule resolution support
com.pega.pegarules.pub.database.BadInputException: Invalid pzInsKey encountered: RULE-UTILITY-FUNCTION PZRENDERSYNCHRONIZATIONITEM #20140523T061018.648 GMT
I indeed can't find this function in the system so I don't know why it's being referenced somewhere.
Error Messages
ERROR - VTable can't load rule resolution support
com.pega.pegarules.pub.database.BadInputException: Invalid pzInsKey encountered: RULE-UTILITY-FUNCTION PZRENDERSYNCHRONIZATIONITEM #20140523T061018.648 GMT
...
Caused by: com.pega.pegarules.pub.database.BadInputException: This external handle is not valid: !PZRENDERSYNCHRONIZATIONITEM
Steps to Reproduce
Error in logs after 7.1.6. installation.
Root Cause
The root cause of this problem is a defect in Pegasystems’ code/rules. The function called PZRENDERSYNCHRONIZATIONITEM isn't associated to any exisiting library. This unexpected situation is the reason for the error generated.
Resolution
This issue is resolved through the following local change:
The recommended approach then is to remove the function from the database side. So the instance of this function should be present into two tables:
- PR4_RULE
- PR4_Rule_VW
Please verify that on your side by running the following queries:
- select * From Pr4_Rule_Vw Where Pxinsid = '!PZRENDERSYNCHRONIZATIONITEM';
- select * From Pr4_Rule Where Pxinsid = '!PZRENDERSYNCHRONIZATIONITEM';
The each above SELECT should return 1 instance. The you should run the following DELETE statement to remove both instances:
- Delete from pr4_rule Where Pxinsid = '!PZRENDERSYNCHRONIZATIONITEM';
Normally both instances will be removed because a trigger should be automatically started after the above DELETE. Don't forget the COMMIT after executing the DELETE statement.
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.