Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Unable to install hotfix in Pega 7.1.9

SA-21865

Summary



Unable to install hotfixes through Hotfix Installer when the hotfix contains a DDL and executes the DDL script.

Error Messages



The installation process will be stopped. Please restart the hotfix installation after applying the schema changes manually.

Steps to Reproduce



1. Import the DL item from Hotfix Installer.
2. Download DDL script provided by Pega.
3. Run the script.
4. Try to re-install DL item.

​ROOT CAUSE

Grants are not autogenerated unless the Admin data source is configured. User have to explicitly grant  ALL  privilege for the new table introduced with the hotfix.

Resolution



Perform the following local-change:
1. Run the following SQL to grant necessary privilege for the newly introduced table:
  • GRANT ALL ON TABLE <<pegarules>>.<<new table name>> TO <<pegadata>>
2. Install the hotfix DL item.
Suggest Edit

Published June 17, 2016 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us