RuleBase Compare returning incorrect results
Hi All,
I am running Rulebase compare wizard to compare rules in two different environments. Connection to target system is successful.
But when i give a min and max RS Version for comparison then it is giving incorrect results.
1. It is getting rules which are not in specified min and max RSV's.
2. It is also returning rules which are actually similar in both environments (same pzinskey).
May i know what criteria the Rulebase compare wizard uses to compare rules? Is it pzinskey or some other key?
Thanks in advance!
Pega version: Pega Platform 8.2.8
Regards,
Mohammad Yousuf
***Edited by Moderator Marije to add Support Case Details***
Self
IN
@MarissaRogers Yes i have already checked this and it doesn't give the information which i am looking for.
StratosphereTC
US
@MarissaRogers I am facing the exact same issue that Mohammad has reported above. Further the results returned are partial. When I look at the code it seems that there is a hardcoded limit of page size of 50 in the list view ListNonSelectableSyncInventory. I private editted it to 200 (that is the max allowed) and then I got some more results, but the results are clearly wrong (I see both the errors that are mentioned above). :( :( Could you please let us know if we are doing something wrong here?
StratosphereTC
US
@Geeta Ramani I also tried to compare using the "Product Rule" option. As a test I included only a ruleset version that I know doesn't exist on the target system and when I ran the tool, I got back "No Differences" which is clearly wrong. In another test I got back results which are outside the product that I selected. Either I am doing doing something very wrong or this tool is completely broken. :( Could you help please?
Updated: 20 Jun 2023 8:04 EDT
Pegasystems Inc.
GB
@Geeta Ramani this is an old thread.
The Rulebase Compare wizard checks the content of a set of ruleset versions or a Rule-Admin-Product file to confirm if its present in the DB of a target environment. It will report against any content within that scope, regardless of application context. Rulebase compare will show the full scope of the content from the ruleset versions or Rule-Admin-Product files select (regardless of the current application context), and provide guidance on how to get the source and target systems aligned in terms of adding, removing, or updating rules.
If the documentation (Comparing rules by system) does not help you out, please can you log a support incident on the MSP ?
StratosphereTC
US
@MarijeSchillern thank you for your response. This thread was only started on Dec 31, 2022, so it is not *that* old..? Anyway so I tried this again. I had migrated a ruleset version from the first env to the second. So clearly for that ruleset version the rules are exactly the same. Then I tried the Rulebase Compare tool. I chose "Ruleset" option, set the min and max ruleset version to the rsv that I had migrated and then ran the tool. I got exactly 5 pages of results and all the results were of "Class" type (so no ruleset version). As mentioned earlier the results are truncated because of the (deprecated) list view ListNonSelectableSyncInventory. If I private edit that rule to return more results I get more results (20 pages) but NOT results just from the ruleset version that I mentioned. So I am not sure what use it is to mention the ruleset version if the tool returns results from other ruleset versions. I will as you suggested open a ticket about it, but just thought I'd get your thoughts too. And yes I have gone through the documentation you mentioned above.
Ford Motor Company
US
I remeberI ran into similar issues few years back when I was trying to compare one Environment to another. Then was investigating some native database tools and ofcourse Excel Connectors, none helped me with the details I was looking.
However, I got an Environment Comparision Tool [ ECT] from Pega Market Place, unfortunately it was a Pilot project and later discontinued from Market Place.
I have a older copy of the stand alone tool, I'm attaching it here along with Installation/User Guide. All you need is, JDBC Connection details of the Env which you want to compare [ I think up to8 Env at a time] and associated jdbc drive.
This is very effective, you can compare the Overall Rules, Differences in pzInsKeys by Version, comparision on Non Versioned Rules, comparision on Rule/Data instances by its type.
Index, Column, Table , schema and View differences etc.,
I'm not positive on how to connect PegaCLOUD Env as we dont get direct logins to the Cloud instance databases.
Self
IN
@SUMAN_GUMUDAVELLY thanks for the response. We manually checked for this back when i raised the request. but I shall try out your copy as well when I get a chance to do this again.