Question

7
Replies
1234
Views
Simone Tedeschi (SimoneT1)
Pegasystems Limited

Pegasystems Limited
IT
SimoneT1 Member since 2017 1 post
Pegasystems Limited
Posted: August 24, 2017
Last activity: August 28, 2017
Posted: 24 Aug 2017 9:25 EDT
Last activity: 28 Aug 2017 10:32 EDT
Closed
Solved

Problem after update from Pega 7.2.2 to 7.3

Hello everybody,


I have installed the Pega 7.2.2 software on a windows server 2012 R2 virtual machine.

I have installed in the same machina the database Postress (9.5.6.1 x64) and the application server Apache tomcat (8.5.11) with java 8.121 (jre and sdk).

The installation of Pega 7.2.2 is gone all fine.

I'm try to update to Pega 7.3 with the update package and setup is gone all fine.

When When I have try to restart the application server, it crash with this exception:


2017-08-24 12:48:58,553 [ PEGADEV] [ ] [ ] [ ] ( internal.access.DatabaseImpl) INFO - Driver version: PostgreSQL 9.4.1212.jre6

2017-08-24 12:48:58,553 [ PEGADEV] [ ] [ ] [ ] ( internal.access.DatabaseImpl) INFO - Version of JDBC supported by driver: 4.0

2017-08-24 12:49:08,116 [ PEGADEV] [ ] [ ] [ ] ( internal.access.Opener) ERROR - ***** Caught exception during open

com.pega.pegarules.pub.database.DatabaseException: Database-General There was a problem opening a database instance RULE-APPLICATION PEGARULES 07.10 0 42501 ERRORE: permesso negato per la relazione pr4_rule_application

DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: access deny for relation pr4_rule_application

| SQL Code: 0 | SQL State: 42501

Hello everybody,

I have installed the Pega 7.2.2 software on a windows server 2012 R2 virtual machine.
I have installed in the same machina the database Postress (9.5.6.1 x64) and the application server Apache tomcat (8.5.11) with java 8.121 (jre and sdk).
The installation of Pega 7.2.2 is gone all fine.
I'm try to update to Pega 7.3 with the update package and setup is gone all fine.
When When I have try to restart the application server, it crash with this exception:

2017-08-24 12:48:58,553 [ PEGADEV] [ ] [ ] [ ] ( internal.access.DatabaseImpl) INFO - Driver version: PostgreSQL 9.4.1212.jre6
2017-08-24 12:48:58,553 [ PEGADEV] [ ] [ ] [ ] ( internal.access.DatabaseImpl) INFO - Version of JDBC supported by driver: 4.0
2017-08-24 12:49:08,116 [ PEGADEV] [ ] [ ] [ ] ( internal.access.Opener) ERROR - ***** Caught exception during open
com.pega.pegarules.pub.database.DatabaseException: Database-General There was a problem opening a database instance RULE-APPLICATION PEGARULES 07.10 0 42501 ERRORE: permesso negato per la relazione pr4_rule_application
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: access deny for relation pr4_rule_application
| SQL Code: 0 | SQL State: 42501

at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.store.AutoCommitTransaction.performQuery(AutoCommitTransaction.java:387) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Opener$1.getResultPageFromDatabase(Opener.java:731) ~[prprivate.jar:?]

I have check also the datebase log for more information and i find this:

2017-08-24 12:49:09 CEST ERROR: access deny for relation pr4_rule_application
2017-08-24 12:49:09 CEST ISTRUZIONE: select pzPVStream , pxCommitDateTime from pega_rules.pr4_rule_application where pzInsKey = $1

Someone can help me?
Thanks

System Administration Installation and Deployment
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.