Issue

Connection to database with BIX breaks repeatedly with an error. This issue occurs with Teradata, Oracle, and PostgreSQL databases.

Error

[com.pega.pegarules.pub.database.ConnectionException: Database-General Connection Exception    0            08001  

HikariPool-164 - Connection is not available, request timed out after 30000ms.

DatabaseException caused by prior exception: java.sql.SQLTransientConnectionException: HikariPool-164 - Connection is

not available, request timed out after 30000ms.

| SQL Code: 0 | SQL State: 08001

com.pega.pegarules.pub.PRRuntimeException: Database instance is not initialized

Explanation

A defect or configuration issue in the operating environment. This issue occurs due to unavailable connection from database connection pool.

Solution

Perform the following local change:

1. Increase maximumConnectionPoolSize from 10 to 20.
2. Increase maximumConnectionTimeout from 30000ms to 60000ms.
3. Restart the Util nodes.

Related content

Database stability and recommended connection pool settings

How to set up JDBC Connection to External Database

Creating and updating external relational database instances with JDBC URLs