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

 bhargav kumar (bkumar)
NCS

NCS
SG
bkumar Member since 2016 4 posts
NCS
Posted: Jun 8, 2019
Last activity: Jun 24, 2019
Posted: 8 Jun 2019 10:05 EDT
Last activity: 24 Jun 2019 2:07 EDT
Closed

Unable to startup pega Prpc personal edition

Hi All,

As there are 2 Personal edition is installed in my system. till yesterday both are working fine . pega 8 server was up CMD window is open at the same time I open Pega 7.3 Server as well. Post that i am unable to launch Pega 7.3 application

FYI-

Attaching Log file as well for Server start

DB port -5432

Connection port for pega 7.3- 8084

Connection port for pega 8- 8083

i tried to change server.xml file as well with new port , multiple times server start & stop

i tried to change postgresql.conf file as well with new db port but issue still persist

***Moderator Edit-Vidyaranjan: Updated SR details***

To see attachments, please log in.
Dev/Designer Studio
Installation and Deployment
Data Integration
Support Case Exists

Posted: 5 years ago
Posted: 8 Jun 2019 11:08 EDT
Prakhar Aggarwal (Prakhar_GCS)
PEGA
Principal Engineer, Technical Support
Pegasystems Inc.
GB

Hi,

There are multiple port number in server.xml of you tomcat. 

For both the tomcat, all ports should be unique(Eg. SHUDDOWN port). Try with this, if still not working share both your server.xml file as well as logs.

Regards,

-Prakhar

To see attachments, please log in.
Posted: 5 years ago
Posted: 9 Jun 2019 5:24 EDT
bhargav kumar (bkumar)
NCS

NCS
SG

Hi Prakhar,

Thanks for your response, i changed connector port, shutdown port as well but still same issue 

PFA for both server.xml fille in txt format

<Server port="9003" shutdown="SHUTDOWN">  in pega 7.3

<Server port="9005" shutdown="SHUTDOWN"> in pega 8

log file on cmd is as it is what I attached in earlier post

Regards

B Kumar

To see attachments, please log in.
Posted: 5 years ago
Posted: 8 Jun 2019 23:15 EDT
Waseem Khan (khanw2)
Pegasystems Inc.
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,

Along with above suggestions, I could see below error in logs. 

Cannot create JDBC driver of class 'org.postgresql.Driver' for connect URL 'jdbc:postgresql://localhost:@PG_PORT/postgres'
java.sql.SQLException: No suitable driver

please make sure you have the postgresql jar file in lib directory of tomcat. If the issue is not resolved, please share the server.xml file of Pega 8 and Pega  7.3 along with server start up logs.

Regards,

Waseem Khan

To see attachments, please log in.
Posted: 5 years ago
Posted: 9 Jun 2019 5:29 EDT
bhargav kumar (bkumar)
NCS

NCS
SG

Hello Wasim, 

Postgre SQL jar is already in the correct path

PFB for 7.3-   C:\PRPCPersonalEdition\tomcat\lib\postgresql-42.0.0.jar

For Pega 8-‪ C:\Personal edition 8\PRPCPersonalEdition\tomcat\lib\postgresql-42.0.0.jar

PFB attached server.xml file 

 

Regards

B Kumar

 

To see attachments, please log in.
Posted: 5 years ago
Posted: 9 Jun 2019 6:47 EDT
Waseem Khan (khanw2)
Pegasystems Inc.
Senior Technical Solutions Engineer
Pegasystems Inc.
IN
Hi,
 
I have compared the logs and server.xml of Pega 7 & 8. 
Pega 8 is running on port 8083. I think you didnt sepcify the port for Pega 7 properly. I could see below entry in server.xml for Pega 7 instance.
 
  <Connector port="@TCHTTP" protocol="HTTP/1.1"
               connectionTimeout="20000"
               redirectPort="9443" />
   
It is not able to find the port="@TCHTTP". Below is logged in start up log.
 
 08-Jun-2019 19:43:44.178 WARNING [main] org.apache.catalina.startup.SetAllPropertiesRule.begin [SetAllPropertiesRule]{Server/Service/Connector} Setting property 'port' to '@TCHTTP' did not find a matching property.
 
Please update the port which is not in use and try restarting the server.
 
Regards,
Waseem Khan
To see attachments, please log in.
Posted: 5 years ago
Posted: 9 Jun 2019 7:40 EDT
bhargav kumar (bkumar)
NCS

NCS
SG

Hello Wasim,

Thanks for your quick response

Yes i changed to port="@TCHTTP" during the conversion of HTTP to HTTPS, it was initially working fine . 

Ok as you suggested then just now i changed to new unique port as 8086.  But still same issue persists 

PFB updated server.xml file & cmd starting log for pega 7

Regards

B Kumat

 

 

To see attachments, please log in.
Posted: 5 years ago
Posted: 9 Jun 2019 9:27 EDT
Waseem Khan (khanw2)
Pegasystems Inc.
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,

I have reviewed the start up logs, and could see that the database connectivity is failing. 

09-Jun-2019 17:03:27.387 1050 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Bootstrap datatables schema: data
09-Jun-2019 17:03:27.395 SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database.  Will only use properties from file.
 java.sql.SQLException: Cannot create JDBC driver of class 'org.postgresql.Driver' for connect URL 'jdbc:postgresql://localhost:@PG_PORT/postgres'
        at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2167)
        at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2037)

Could you please check in context.xml in conf folder of tomcat and verify if you have you have defined database details correctly. Please share the context.xml for reference.

Regards,

 

To see attachments, please log in.
Posted: 5 years ago
Posted: 9 Jun 2019 9:43 EDT
bhargav kumar (bkumar)
NCS

NCS
SG

Hi,

Now  i changed url url="jdbc:postgresql://localhost:@PG_PORT/postgres" to  url="jdbc:postgresql://localhost:5432/postgres"

But still server is down

Regards

B Kumar

 

To see attachments, please log in.
Posted: 5 years ago
Posted: 9 Jun 2019 18:15 EDT
Prakhar Aggarwal (Prakhar_GCS)
PEGA
Principal Engineer, Technical Support
Pegasystems Inc.
GB

Hi,

Please check logs, if you are still getting JDBC error or not.

If yes please cross check with you postgres DB, if you have provides all the details correctly.

Regards,

-Prakhar

To see attachments, please log in.
Posted: 5 years ago
Posted: 10 Jun 2019 2:03 EDT
bhargav kumar (bkumar)
NCS

NCS
SG

Yes Prakhar,

i crosschecked eventhough i changed Port & host name then after in log getting error

 org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265)

Regards

B Kumar

To see attachments, please log in.
Posted: 5 years ago
Posted: 10 Jun 2019 0:53 EDT
Pawan Narain Singh (pawann)
Swedbank AB

Swedbank AB
SE

Hello Bhargav,

This works in my local setup, so you might as well give it a go.

<Resource name="jdbc/PegaRULES"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/postgres"
username="postgres"
password="password"
maxActive="50"
maxIdle="5"
maxWait="5000"/>
<Environment
name="prconfig/database/databases/PegaRULES/defaultSchema"
value="pega"
type="java.lang.String"
/>

 

Let us know if it works. If it does not, then kindly attach the latest logs post making the change above.

Thank you,
Pawan

To see attachments, please log in.
Posted: 5 years ago
Posted: 24 Jun 2019 2:07 EDT
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Senior Manager, Technical Support
Pegasystems Inc.
IN

Latest that I see is 

Show More

Latest that I see is 

Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:265)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
        at org.postgresql.Driver.makeConnection(Driver.java:431)
        at org.postgresql.Driver.connect(Driver.java:247)
        at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
        at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:257)
        at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2313)
        at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2299)
        ... 21 more
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
        at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:589)
        at org.postgresql.core.PGStream.<init>(PGStream.java:62)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)

It seems certain that 5432 port is closed.

https://stackoverflow.com/questions/31091748/postgres-server-not-listening

Can you check above. Can you also try to ping PostGres server at 5432


Show Less
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