Question
ROS
GB
Last activity: 15 Feb 2023 7:42 EST
FAIL - Application at context path [/prweb] could not be started
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 ?
Accepted Solution
Updated: 15 Feb 2023 7:42 EST
ROS
GB
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 :
1.
sudo cp /.../postgresql-42.2.8.jar /usr/share/tomcat/lib sudo chown tomcat:tomcat /usr/share/tomcat/lib/postgresql-42.2.8.jar
2. 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
TETCO
SA
@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)
Updated: 13 Feb 2023 12:14 EST
ROS
GB
@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?
Updated: 14 Feb 2023 14:16 EST
ROS
GB
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.
Ford Motor Company
US
@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'
Accepted Solution
Updated: 15 Feb 2023 7:42 EST
ROS
GB
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 :
1.
sudo cp /.../postgresql-42.2.8.jar /usr/share/tomcat/lib sudo chown tomcat:tomcat /usr/share/tomcat/lib/postgresql-42.2.8.jar
2. 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