I am gettting the below error in logs and my Server going down always. I suspect the following error is causing my server to go down
( internal.access.Opener) ERROR - There was a problem opening a database instance SYSTEM-USER-MYRULES INDIVIDUAL!000######!WORKTAB
com.pega.pegarules.pub.database.ConnectionException: There was a problem opening a database instance SYSTEM-USER-MYRULES INDIVIDUAL!000######!WORKTAB: code: 17008 SQLState: 08003 Message: Closed Connection
Please help me to find out the reason for this Error. Please share your resolution if you also came accross the same issue.
Thanks in Advance.
***Updated by moderator: Lochan to update Categories***
The NetException can be occur due to a data packet mismatch between data that is being sent from the database and the data being read by the Application server. "code: 17008 SQLState: 08003 Message: Closed Connection" indicates that the JDBC Connection in the pool was successfully established at some point, but when the application thread tried to use it, the connection was no longer open.
The root cause can be as follows
- The firewall between the application server and the database is timing-out the connections
Check the same with your sysdamin/network team.
- The database server itself is closing the client connections based on a set timeout.
Verify your JDBC Connection Pool configurations.
FYI, Based on your application server and DB, the reference guides for JDBC Connection Pool will be available on vendor website.