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

Error on installing hotfix package using Installation wizard



Error occurs when installing the hotfix package using the Pega installation wizard:
  • HFix-46621
  • HFix-48578
  • HFix-48491
  • HFix-48492
  • HFix-41402
  • HFix-42307
  • HFix-39276
  • HFix-39478
  • HFix-39836
  • HFix-40241
  • HFix-40356
  • HFix-43974
  • HFix-39836​​

Error Messages

[xxxxxx] [TABTHREAD1] [ ] [PegaRULES:07.10] (nager.install.InstallerAPIImpl) ERROR xxxxxx| xxxxxx@xx- There are problems applying changes to the database object: pr_History_PegaMKT_Data__53503
[tp-apr-8080-exec-123] [TABTHREAD1] [ ] [PegaRULES:07.10] (nager.install.InstallerAPIImpl) ERROR txxxxx| xxxxxx@xxxx - SQL : ALTER TABLE mktdata.MKT_CONTACT_SUMMARY ADD COLUMN "pysubjecttype" VARCHAR (96) Database-General    Problem executing SQL to update database schema    0    42501    ERROR: must be owner of relation mkt_contact_summary
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: must be owner of relation mkt_contact_summary
 | SQL Code: 0 | SQL State: 42501

at ~[prprivate.jar:?]
at ~[prprivate.jar:?] 
at ~[prprivate.jar:?] 
at ~[prprivate.jar:?]
at com.pega.pegarules.updatemanager.install.InstallerAPIImpl.applyDDL( ~[prprivate.jar:?] 
at com.pegarules.generated.activity.ra_action_pzinstallselectedhotfixes_f759d644a2d2d5af30aa3d1e1180a30f.step3_circum0( ~[?:?] 
at com.pegarules.generated.activity.ra_action_pzinstallselectedhotfixes_f759d644a2d2d5af30aa3d1e1180a30f.perform( ~[?:?]
at org.apache.coyote.http11.AbstractHttp11Processor.process( ~[tomcat-coyote.jar:7.0.88] 
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process( ~[tomcat-coyote.jar:7.0.88] 
at org.apache.tomcat.util.your_net.AprEndpoint$SocketProcessor.doRun( ~[tomcat-coyote.jar:7.0.88] 
at org.apache.tomcat.util.your_net.AprEndpoint$ ~[tomcat-coyote.jar:7.0.88] 
at java.util.concurrent.ThreadPoolExecutor.runWorker( [?:1.8.0_171] 
at java.util.concurrent.ThreadPoolExecutor$ [?:1.8.0_171] 
at org.apache.tomcat.util.threads.TaskThread$ ~[tomcat-coyote.jar:7.0.88] 
at [?:1.8.0_171]
Caused by: org.postgresql.util.PSQLException: ERROR: must be owner of relation mkt_contact_summary

Steps to Reproduce

Install the hotfix package using the Pega installation wizard.

Root Cause

The user did not have the necessary privileges to update the relation mkt_contact_summary table.


Perform the following local-change:
  1. Select the hotfix package to reinstall. In the hotfix installation wizard, the system identifies the database change and prompts for the type of install: Automatic or Manual. 
  2. Select Manual install.
  3. Download the SQL file and install the SQL script manually. Proceed with the hotfix installation.

Published August 15, 2019 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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