Summary

Error Messages

[xxxxxx] [TABTHREAD1] [ ] [PegaRULES:07.10] (nager.install.InstallerAPIImpl) ERROR xxxxxx|xx.xx.xx.xxx 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|xx.xx.xx.xxx xxxxxx@xxxx - SQL : ALTER TABLE mktdata.MKT_CONTACT_SUMMARY ADD COLUMN "pysubjecttype" VARCHAR (96)
com.pega.pegarules.pub.database.DatabaseException: 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 com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:354) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:333) ~[prprivate.jar:?] 
at com.pega.pegarules.data.internal.access.DBSchemaDDLExecutor.executeDBSchemaDDL(DBSchemaDDLExecutor.java:149) ~[prprivate.jar:?] 
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaDDL(DatabaseImpl.java:3541) ~[prprivate.jar:?]
at com.pega.pegarules.updatemanager.install.InstallerAPIImpl.applyDDL(InstallerAPIImpl.java:694) ~[prprivate.jar:?] 
at com.pegarules.generated.activity.ra_action_pzinstallselectedhotfixes_f759d644a2d2d5af30aa3d1e1180a30f.step3_circum0(ra_action_pzinstallselectedhotfixes_f759d644a2d2d5af30aa3d1e1180a30f.java:315) ~[?:?] 
at com.pegarules.generated.activity.ra_action_pzinstallselectedhotfixes_f759d644a2d2d5af30aa3d1e1180a30f.perform(ra_action_pzinstallselectedhotfixes_f759d644a2d2d5af30aa3d1e1180a30f.java:104) ~[?:?]
(...) 
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1139) ~[tomcat-coyote.jar:7.0.88] 
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) ~[tomcat-coyote.jar:7.0.88] 
at org.apache.tomcat.util.your_net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2555) ~[tomcat-coyote.jar:7.0.88] 
at org.apache.tomcat.util.your_net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2544) ~[tomcat-coyote.jar:7.0.88] 
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_171] 
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_171] 
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-coyote.jar:7.0.88] 
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]
Caused by: org.postgresql.util.PSQLException: ERROR: must be owner of relation mkt_contact_summary

Steps to Reproduce

Root Cause

Resolution

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.