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.
HFix-22433.jar file contains this ReadMe.txt, Application.xml, prenginext.jar
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.
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.