Skip to main content

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.

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:
  1. Apply HFix-46367.
  2. Use prpcUtils to repopulate the pr4_rule_vw table correctly.
  3. 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

  4. 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

  5. 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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration 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.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us