Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Simone Tedeschi (SimoneT1)
Pegasystems Limited

Pegasystems Limited
IT
SimoneT1 Member since 2017 1 post
Pegasystems Limited
Posted: Aug 24, 2017
Last activity: Aug 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 ( Proprietary information hidden 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

Show More

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 ( Proprietary information hidden 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


Show Less
To see attachments, please log in.
Installation and Deployment

Accepted Solution

Posted: 7 years ago
Posted: 28 Aug 2017 9:39 EDT
Simone Tedeschi (SimoneT1)
Pegasystems Limited

Pegasystems Limited
IT

I have solved the problem. The basic databese user after upgrading don't have full select rights.

So, after run these following query all works fine.

GRANT SELECT ON ALL TABLES IN SCHEMA pega_data TO pega_basic;
GRANT SELECT ON ALL TABLES IN SCHEMA pega_rules TO pega_basic;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA pega_data TO pega_basic;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA pega_rules TO pega_basic;

Thanks.

To see attachments, please log in.
Posted: 7 years ago
Posted: 24 Aug 2017 9:43 EDT
Nick Loving (NickLoving_GCS)
PEGA
Senior Principal Engineer, Technical Support
Pegasystems Inc.
US

Did you ever try to start the application while you were on 7.2.2? It looks like the user running Pega doesn't have correct permissions.

Can the same user run queries on the pega_rules.pr4_rule_application table on a sql client?

To see attachments, please log in.
Posted: 7 years ago
Posted: 24 Aug 2017 9:55 EDT
Simone Tedeschi (SimoneT1)
Pegasystems Limited

Pegasystems Limited
IT

Application server with version 7.2.2 work fine. I have also try to open the postgress sql and run the query with the pega user and query work fine.
 

To see attachments, please log in.
Posted: 7 years ago
Posted: 24 Aug 2017 13:10 EDT
Nick Loving (NickLoving_GCS)
PEGA
Senior Principal Engineer, Technical Support
Pegasystems Inc.
US

Hmmm can you try a different version of the JDBC driver? In the log I see Driver version: PostgreSQL 9.4.1212.jre6 but you are using Java 8 so you should use a driver that supports JDBC 4.2.

To see attachments, please log in.
Posted: 7 years ago
Posted: 25 Aug 2017 4:26 EDT
Simone Tedeschi (SimoneT1)
Pegasystems Limited

Pegasystems Limited
IT

I have try with a different kind of driver(postgresql-42.1.4.jar), but the result is the same:

Show More

I have try with a different kind of driver(postgresql-42.1.4.jar), but the result is the same:

2017-08-25 09:35:13,322 [             PEGAAPP] [          ] [                    ] [                    ] (ary.ClassMapDatabasePageReader) INFO    - Read 18 class group definitions
2017-08-25 09:35:13,603 [             PEGAAPP] [          ] [                    ] [                    ] (ary.ClassMapDatabasePageReader) INFO    - Reading the class definitions
2017-08-25 09:35:16,400 [             PEGAAPP] [          ] [                    ] [                    ] (ary.ClassMapDatabasePageReader) INFO    - Read 5088 class definitions
2017-08-25 09:35:18,212 [             PEGAAPP] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Database product: PostgreSQL
2017-08-25 09:35:18,212 [             PEGAAPP] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Database version: 9.5.6
2017-08-25 09:35:18,212 [             PEGAAPP] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Driver: PostgreSQL JDBC Driver
2017-08-25 09:35:18,212 [             PEGAAPP] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Driver version: 42.1.4
2017-08-25 09:35:18,212 [             PEGAAPP] [          ] [                    ] [                    ] (  internal.access.DatabaseImpl) INFO    - Version of JDBC supported by driver: 4.2
2017-08-25 09:35:22,978 [             PEGAAPP] [          ] [                    ] [                    ] (        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: ERRORE: permesso negato per la relazione 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:?]
    at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:714) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:711) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.store.DataStoreManager.readInTransaction(DataStoreManager.java:70) ~[prprivate.jar:?]


Show Less
To see attachments, please log in.

Accepted Solution

Posted: 7 years ago
Posted: 28 Aug 2017 9:39 EDT
Simone Tedeschi (SimoneT1)
Pegasystems Limited

Pegasystems Limited
IT

I have solved the problem. The basic databese user after upgrading don't have full select rights.

So, after run these following query all works fine.

GRANT SELECT ON ALL TABLES IN SCHEMA pega_data TO pega_basic;
GRANT SELECT ON ALL TABLES IN SCHEMA pega_rules TO pega_basic;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA pega_data TO pega_basic;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA pega_rules TO pega_basic;

Thanks.

To see attachments, please log in.

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

Pega Collaboration Center 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