Skip to main content

Rolling back hotfixes by using a direct connection to the database

Suggest edit
Updated on April 12, 2022

If an uncommitted hotfix introduces unwanted changes to your system, you can remove it by rolling it back using a direct connection to the database. This is most commonly done for a stopped instance.

To roll back hotfixes by connecting directly to the database, do the following steps.Caution: You cannot roll back committed hotfixes.Note: Database schema changes associated with a hotfix are not removed when rolling back.
  1. Configure the common properties of the prpcUtils.properties file.
    Property name Value
    pega.jdbc.driver.jarPath to the database driver .jar file.
    pega.jdbc.driver.classThe database driver class.
    pega.database.typeDatabase vendor type.
    pega.jdbc.urlURL of your database.
    pega.jdbc.usernameDatabase user name.
    pega.jdbc.password Database password.
    rules.schema.nameIf you use a split schema, the value for the rules schema name. If you do not use a split schema, the value for the schema name.
    data.schema.nameIf you use a split schema, the value for the data schema name.
  2. Configure the rollback properties of the prpcUtils.properties file.
    Property name Value
    hotfix.operation rollback
  3. Save and close the prpcUtils.properties file.
  4. Run the prpcUtils.bat or prpcUtils.sh script with the manageHotfixes option, for example: prpcUtils.bat manageHotfixes
  5. Optional: Pass one or more arguments.
    Property name Value
    pega.jdbc.driver.jarPath to the database driver .jar file.
    pega.jdbc.driver.classThe database driver class.
    pega.database.typeDatabase vendor type.
    pega.jdbc.urlURL of your database.
    pega.jdbc.usernameDatabase user name.
    pega.jdbc.password Database password.
    rules.schema.nameIf you use a split schema, the value for the rules schema name. If you do not use a split schema, the value for the schema name.
    data.schema.nameIf you use a split schema, the value for the data schema name.
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us