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_LIBRARYrl where not exists (select pzinskey from yourRulesSchema.pr4_rule_vwvw 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 April 19, 2017 - Updated May 8, 2017

Have a question? Get answers now.

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