Support Article
Certain RUF instances not imported during Pega update
SA-36760
Summary
User is trying to upgrade from Pega 7.1.7 to Pega 7.2.1 and is getting the below error.
Error Messages
[java] 2017-04-10 15:53:34,523 [ main] [ ] [ ] ( internal.util.MoveLog) INFO - Processed 2924 of 7215 (40.53%): 862 committed, 2062 skipped, 31 seconds remaining
[java] 2017-04-10 15:53:36,005 [ main] [ ] [ ] ( internal.util.MoveLog) INFO - Processed 3487 of 7215 (48.33%): 962 committed, 2525 skipped, 27 seconds remaining
[java] 2017-04-10 15:53:36,065 [ main] [ ] [ ] ( internal.loaders.FastLoader) ERROR - 0 rows updated returned for instance of type Data-Rule-Summary with key RULE-UTILITY-FUNCTION PREDICTIVEANALYTICS_COMMONMETHODS CONNDB #20150406T061439.758 GMT
[java] 2017-04-10 15:53:36,065 [ main] [ ] [ ] ( internal.loaders.FastLoader) ERROR - 0 rows updated returned for instance of type Data-Rule-Summary with key RULE-UTILITY-FUNCTION PREDICTIVEANALYTICS_COMMONMETHODS EXPORTBYTES #20150406T061439.876 GMT
[java] 2017-04-10 15:53:36,065 [ main] [ ] [ ] ( internal.loaders.FastLoader) ERROR - 0 rows updated returned for instance of type Data-Rule-Summary with key RULE-UTILITY-FUNCTION PREDICTIVEANALYTICS_COMMONMETHODS GETCURRENTSTEPINFO #20150406T061439.978 GMT
[java] 2017-04-10 15:53:36,065 [ main] [ ] [ ] ( internal.loaders.FastLoader) ERROR - 0 rows updated returned for instance of type Data-Rule-Summary with key RULE-UTILITY-FUNCTION PREDICTIVEANALYTICS_COMMONMETHODS GETDATATYPEFROMPADCOLUMNTYPE #20150406T061440.071 GMT
[java] 2017-04-10 15:53:36,065 [ main] [ ] [ ] ( internal.loaders.FastLoader) ERROR - 0 rows updated returned for instance of type Data-Rule-Summary with key RULE-UTILITY-FUNCTION PREDICTIVEANALYTICS_COMMONMETHODS GETFILEINPUTSTREAM #20150406T061440.165 GMT
[java] Apr 10, 2017 3:53:36 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Problem during method invocation (main)
[java] com.pega.pegarules.pub.PRException: PRException
Steps to Reproduce
Run upgrade from Pega 7.1.7 to Pega 7.2.1.
Root Cause
A defect or configuration issue in the operating environment: The records between PR4_RULE_LIBRARY and PR4_RULE_VW tables are out of synchronization.
Resolution
Perform the following local-change steps:
1. Check the number of records which are out of sync between PR4_RULE_LIBRARY and PR4_RULE_VW tables using below queries:
SELECT count(*) FROM yourRulesSchema.PR4_RULE_LIBRARY where pxobjclass like 'Rule_Utility_Function'
SELECT count(*) FROM yourRulesSchema.pr4_rule_vw where pyclass='Rule-Utility-Function'
2. Once it is confirmed that the records are out of synchronization as per step 1, correct the records using the below query:
Insert into yourRulesSchema.pr4_rule_vw (pzinskey) (select pzinskey from yourRulesSchema.PR4_RULE_LIBRARY rl where not exists (select pzinskey from yourRulesSchema.pr4_rule_vw vw where vw.pzinskey=rl.pzinskey));
3. Resume the upgrade.
4. After the upgrade is completed, resave the Rule-Utility-Function rule either from prpcUtils or from the portal.
This will populate all the columns for this rule in the pr4_rule_vw table.
Published May 8, 2017 - 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.