I am unable to install Override Detection and Upgrade Assessment Tool in my pega application. There is a DB synonym error. Do we need to perform any additional steps before installing this component?

I am unable to install Override Detection and Upgrade Assessment Tool in my pega application. There is a DB synonym error. Do we need to perform any additional steps before installing this component? The link provided in the user guide does not exists or is archived. I wanted to check out this tool as we are upgrading to v24.2.5. @ravum Please help

Hi @DhruvD24 . There are no additional steps required to install the component. You can follow the steps in this link - Pegasystems Documentation

Share the screen shot of the error.

Hi
Please refer to the ss below
I think we would need to create table in the PegaRules schema and try again.

The table should be in the PegaData Schema only. The error seems a bit strange. The table definition doesnt have SYNONYM, as shown below. If you need the DDL of the table, I can share it, so that you can run it on the DB, so that the table creation during import will skip it. Let me know.

Yes please

I am seeing similar errors on the below tables as well -

pr_Data_RuleChanges_Override
pr_Data_RuleChanges_Stag_3cf80
pr_History_Data_RuleChanges
pr_History_Data_RuleChanges_Ov
pr_data_rulechanges_override_staging

I see these tables being present in Pega_Data while BIX_Data, Pega_User and BIX_User have synonyms for this table in our application.

Hi Murali

I am able to resolve this issue. Just wanted to check if we need to add this CompareRules ruleset version to our application stack as well? Please confirm

Are you referring to this tool in Pega Marketplace? Pega Upgrade Tools | Pega ?

If so, you can follow the user guide, and it should work as expected. We recently used this component successfully in our project. If you encounter any issues, I would recommend opening an incident with Pega Support rather than attempting to troubleshoot or modify the component yourself. While some Marketplace components may not be supported by Pega GCS, since this component is provided by Pega, it may be eligible for Pega support.

You can add this as a Component to your application rather than the ruleset.
Component: CompareRules v01.01.01

Yes, I am able to run this now. Thank you
Just one more question, do we need to add Pega FW applications as well in the wizard?
Seems like it does not pick up PegaRules in the rule changes tab.
We do use smart disputes as well, shall we include these apps in the rule changes? Does it include built on applications or do we need to include the complete application stack?

If you are upgrading from one version of the Pega FW / Smart Dispute to a newer version, then you can run the ‘Compare Rules’ for the Pega FW.

This allows you to determine the changes that the FW has done in the newer version. Later in the second page (Override detection), you can find if there are any overrides in your application that the base application (Pega FW) has updated. With this you can retrofit the Pega FW changes and your overides.

But if you are not upgrading the FW, then you dont have to select that FW application.