FAIL - Application at context path [/prweb] could not be started

General
, , ,
1

Trying to install the Pega Platform 8.8.1 and the build is successful but still could not start the pega application. It is providinfg this error below

FAIL - Application at context path [/prweb] could not be started

Please find attach the error from catalina.out.

In addition, when the package was downloaded. The ../repos/pega-tomcat/archives/postgresql-42.2.8.jar is not found according to your documentation and searched the downloaded folder and nothing like the postgresql-42.2.8.jar . we downloaded the 42.5.2 instead. Is that might be the reason ?

log-catalina.out_.txt (60.3 KB)

2

@MichaelO16590192

Data base not installed properly and before installing pega, check is there any data base available in your system (if not require delete and try)

3

@Poosala Thanks. The intention is to delete old pegarules schema and recreate new pegarules schema and preserve the pegadata. we are updating pega from 8.4 to 8.8. The database is available in the system and can you check the new attachment here as I just re installed it. Also, is it about JDBC driver causing this issue?

log-catalina2_reinstallation.out__0.txt (130 KB)

4

I also decided to upgrade rather than clean install. I am getting similar error. what is this error now after upgrade :

14-Feb-2023 13:40:58.911 SEVERE [http-nio-8080-exec-13] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database.

I copied the postgresql-42.2.8.jar into this path ``/usr/share/java/tomcat/

It is still same issue am facing. Find the latest log attach for the upgrade as well.

log-catalina2_reinstallation_upgradet.txt (60.4 KB)

5

@MichaelO16590192 I see the error clearly complaining about the DB Connection, The DB connection is failed as it couldnt find a Postgres SQL Driver. Because of this error, bootstrap is not loaded i.e., none of the Start up tasks completed.

13-Feb-2023 17:11:30.556 SEVERE [Catalina-utility-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database.  Will only use properties from file.
java.sql.SQLException: Cannot load JDBC driver class 'org.postgresql.Driver'
6

May be but have resolved this now and prweb is running but login shows and then stop after some time with this message

HTTP Status 503 – Service Unavailable
Type Status Report

Message PegaRULES server not available

Description The server is currently unable to handle the request due to a temporary overload or scheduled maintenance, which will likely be alleviated after some delay.

But when the firewall is disabled, it works without 503. That will be me writing script to allow the network. Resolved now

The steps I used to resolve this :

sudo cp /.../postgresql-42.2.8.jar /usr/share/tomcat/lib
sudo chown tomcat:tomcat /usr/share/tomcat/lib/postgresql-42.2.8.jar
  1. ALTER DEFAULT PRIVILEGES
    FOR USER theuser IN
    SCHEMA pegadata GRANT
    ALL ON TABLES TO theuser

ALTER DEFAULT PRIVILEGES
FOR USER theuser IN
SCHEMA pegarules GRANT
ALL ON TABLES TO theuser