Remove a commited hotfix HFIX-22433
Hi guys,
We committed an unnneccsary hotfix(HFIX-22433) in our test environment accidentally and deployed major Data conversion on top of it. So Backup/restore is not an option. Is there a better way to remove rules related to this hotfix ? I have the information below from readme.txt. Not sure if this hotfix can provide more granual details.
Contents:
HFix-22433.jar file contains this ReadMe.txt, Application.xml, prenginext.jar
and MANIFEST.MF
Code Changes:
prenginext.jar -
com/pega/pegarules/session/external/engineinterface/etier/engine/WebRequestBas
e.class
Rule Changes:
-
Thank you for your help!
Accepted Solution
PEG
US
HFix-22433 changed only one Engine class,
com/pega/pegarules/session/external/engineinterface/etier/engine/WebRequestBase.java
If you run the following SQL on the table pr_engineclasses
select * from pr_engineclasses where pzclass like '%WebRequestBase%';
You may or may not see multiple entries for this; I think you will see all of the versions starting from the base version and subsequent hotfixes.
The hotfix version had pzmoduleversion of 137685; you should see this one in the result set. If you can see you have a prior version, then merely deleting the row for this version should then have the system fall back to the previous. If you don't see multiple versions but you did back up your database, you should be able to copy the row of this class from the back version and replace (or delete and then insert) it for the 137685 version.
Needless to say, BACK UP the table carefully before you start making changes.
Pegasystems Inc.
IN
Hi
Have you taken database backup before deploying the fix ? If yes then reverting back to the previous checkpoint is the possible option.
ConEdison
US
Hi, we have taken the backup. But along with committing the hotfix, we had a major deployment as well that has many changes to data schema. It was a major Data conversion run. Now restoring it to the version before this deployment would make us to run all the conversion again which may take couple of days. I'm trying to see if there is any other way.
Accepted Solution
PEG
US
HFix-22433 changed only one Engine class,
com/pega/pegarules/session/external/engineinterface/etier/engine/WebRequestBase.java
If you run the following SQL on the table pr_engineclasses
select * from pr_engineclasses where pzclass like '%WebRequestBase%';
You may or may not see multiple entries for this; I think you will see all of the versions starting from the base version and subsequent hotfixes.
The hotfix version had pzmoduleversion of 137685; you should see this one in the result set. If you can see you have a prior version, then merely deleting the row for this version should then have the system fall back to the previous. If you don't see multiple versions but you did back up your database, you should be able to copy the row of this class from the back version and replace (or delete and then insert) it for the 137685 version.
Needless to say, BACK UP the table carefully before you start making changes.