Support Article
Migration Cleanup script didn't populate all pr4_rule_vw classes
SA-75318
Summary
The oracle_fix_vw_table migration clean up script which is part of the upgrade does not populate all the classes in the view correctly.
Below are some of the missing classes,
Rule-HTML-Section
Rule-HTML-Property
Rule-Utility-Function
Rule-Message
Rule-Application-Guide
Rule-Service-REST
This occurs though all the rules are available in the actual tables.
Error Messages
Not Applicable
Steps to Reproduce
Run the oracle_fix_vw_table script from ResourceKit\AdditionalUpgradeScripts\MigrationRecoveryScripts.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Perform the following local-change:
- Apply HFix-46367.
- Use prpcUtils to repopulate the pr4_rule_vw table correctly.
- In the prpcUtils.properties file, populate the common Connection details information and the Temp directory to use.
pega.jdbc.driver.jar=
pega.jdbc.driver.class=
pega.database.type=
pega.jdbc.url=
pega.jdbc.username=
pega.jdbc.password=rules.schema.name=
data.schema.name=user.temp.dir
- In the section of the 'Setting for Expose Tool' properties file, set the properties as specified below.
expose.classes.included=Rule-
expose.included.descendent=true
expose.reindexType=full
expose.update.rule.summary=true - Run the tool with the appropriate .bat or .sh script and the Command Line argument of Expose.
On Windows: prpcUtils.bat expose
On Unix: ./prpcUtils.sh expose
Published March 27, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.