LinkedIn
Copied!

Table of Contents

Rolling back hotfixes by using a direct connection to the database

Version:

Only available versions of this content are shown in the dropdown

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.

You cannot roll back committed hotfixes.
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.jar Path to the database driver .jar file.
    pega.jdbc.driver.class The database driver class.
    pega.database.type Database vendor type.
    pega.jdbc.url URL of your database.
    pega.jdbc.username Database user name.
    pega.jdbc.password Database password.
    rules.schema.name If 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.name If 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.jar Path to the database driver .jar file.
    pega.jdbc.driver.class The database driver class.
    pega.database.type Database vendor type.
    pega.jdbc.url URL of your database.
    pega.jdbc.username Database user name.
    pega.jdbc.password Database password.
    rules.schema.name If 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.name If you use a split schema, the value for the data schema name.

Related Content

Did you find this content helpful?

Have a question? Get answers now.

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