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

 Satish Kumar Lade (SatishKumarL5551)
Areteans

Areteans
NZ
SatishKumarL5551 Member since 2018 50 posts
Areteans
Posted: May 5, 2020
Last activity: Mar 8, 2021
Posted: 5 May 2020 7:27 EDT
Last activity: 8 Mar 2021 14:28 EST
Closed
Solved

Issue when starting 8.4 Personal Edition

Hello,

I see that 8.4 personal edition does not start sometimes. This doesnt seem to be an issue with 8.4 as I have seen same issue with 8.1 PE too and both instances have the same error. I have attached the tomcat log file which has error details observed during startup and below is an extract from the log file-

04-May-2020 13:04:15.855 SEVERE [localhost-startStop-1] org.postgresql.Driver.connect Connection 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.

It would be helpful if someone can review the log error and suggest the reason for this behaviour and how to address it.

Thanks,

Satish

 

***Edited by Moderator Marissa to update Platform Capability tags****

To see attachments, please log in.
Pega Platform 8.4
System Administration
Senior System Architect

  • Nirup Cherlakola

Accepted Solution

Posted: 4 years ago
Updated: 4 years ago
Posted: 22 Jun 2020 22:56 EDT
Updated: 23 Jun 2020 8:21 EDT
Satish Kumar Lade (SatishKumarL5551)
Areteans

Areteans
NZ

The issue is resolved by starting the DB server using below command and then starting the tomcat instance-

D:\PRPCPersonalEdition\pgsql\bin>pg_ctl -D D:\PRPCPersonalEdition\pgsql\data start

Above highlighted could change based on the personal edition installation.

However I was expecting starting tomcat instance would take care of starting DB server as well as I havent explicitly started DB server for personal edition in the past.

 

Thanks,

Satish

To see attachments, please log in.
Posted: 4 years ago
Posted: 5 May 2020 23:50 EDT
Satish Kumar Lade (SatishKumarL5551)
Areteans

Areteans
NZ

Hi Kevin,

I dont think PE is able to connect to pgsql. Attached the tomcat logs for this behaviour. Do you mind taking a look at the log and suggest.

Appreciate in case of suggestions.

Thanks,

Satish

To see attachments, please log in.
Posted: 4 years ago
Posted: 5 May 2020 19:45 EDT
Satish Kumar Lade (SatishKumarL5551)
Areteans

Areteans
NZ

No only one at a time as I assume both might use the same ports. But please do let me know if i can run both at a time by updating the ports for each and how that can be done.

To see attachments, please log in.
Posted: 4 years ago
Posted: 5 May 2020 9:37 EDT
Venkata Chalapathi Janapati (janav)
PEGA
Principal Engineer, Technical Support - Runtime Engine and Search
Pegasystems Inc.
IN

Hi Satish,

This probably not an issue with Pega PE. Can you please check the postgresql version and JDBC driver that you are using.

Also, the maximum number of parallel connections that you DB is accepting.

Can you also please check:-

https://stackoverflow.com/questions/20825734/postgresql-connection-refused-check-that-the-hostname-and-port-are-correct-an

 

Warm Regards,

Venkat

To see attachments, please log in.
Posted: 4 years ago
Posted: 5 May 2020 23:45 EDT
Satish Kumar Lade (SatishKumarL5551)
Areteans

Areteans
NZ

Hi Venkat,

I am not sure which version of pgsql comes with PE for 8.4. However noticed that pgadmin4 client is of the version 1.1 and tomcat is configured to use org.postgresql.Driver as per below tomcat settings in context.xml

    <Resource name="jdbc/PegaRULES"               auth="Container"               type="javax.sql.DataSource"               maxTotal="100"               maxIdle="30"               maxWaitMillis="10000"               driverClassName="org.postgresql.Driver"               url="jdbc:postgresql://localhost:5432/postgres"               username="postgres"               password="postgres"/>

 

Do you mind taking a look at the tomcat log attached which has the error details when this behaviour is observed.

To see attachments, please log in.
Posted: 4 years ago
Posted: 6 May 2020 3:34 EDT
Prakhar Aggarwal (Prakhar_GCS)
PEGA
Principal Engineer, Technical Support
Pegasystems Inc.
GB

Hi,

In logs it clearly says that unable to connect to database.

04-May-2020 13:04:15.865 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 PoolableConnectionFactory (Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
	at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2303)

Also check below link, try the solution given and let us know

https://collaborate.pega.com/question/unable-connect-database-will-only-use-properties-file

To see attachments, please log in.
Posted: 4 years ago
Posted: 15 Jun 2020 7:51 EDT
Rimjhim Srivastava (srivr1)
Pegasystems Inc.
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,

Please check the context.xml and setupdatabase.properties files if the ports and DB details are mentioned or not.

Please verify the same with your database configuration.

To see attachments, please log in.

Accepted Solution

Posted: 4 years ago
Updated: 4 years ago
Posted: 22 Jun 2020 22:56 EDT
Updated: 23 Jun 2020 8:21 EDT
Satish Kumar Lade (SatishKumarL5551)
Areteans

Areteans
NZ

The issue is resolved by starting the DB server using below command and then starting the tomcat instance-

D:\PRPCPersonalEdition\pgsql\bin>pg_ctl -D D:\PRPCPersonalEdition\pgsql\data start

Above highlighted could change based on the personal edition installation.

However I was expecting starting tomcat instance would take care of starting DB server as well as I havent explicitly started DB server for personal edition in the past.

 

Thanks,

Satish

To see attachments, please log in.
  • Pradeep Patnam Cristobal Hernandez Ashwani Mishra
Posted: 4 years ago
Posted: 21 Oct 2020 16:05 EDT
Cristobal Hernandez (hernc)
PEGA
Senior System Architect
Pegasystems Inc.
US

I also had this problem when installed on Windows Server 2019. The problem was that it didn't have VCRUNTIME140.dll. needed to run the DB. To fix it I had to install Visual C++ Redistributable for Visual Studio 2015.

To see attachments, please log in.
Posted: 3 years ago
Posted: 8 Mar 2021 12:56 EST
Cristobal Hernandez (hernc)
PEGA
Senior System Architect
Pegasystems Inc.
US

@Suma Perumalla Just download and install "Visual C++ Redistributable for Visual Studio 2015". This would install the library that is needed.

Show More

@Suma Perumalla Just download and install "Visual C++ Redistributable for Visual Studio 2015". This would install the library that is needed.

 
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