Question

Production environment Database connection failure.

Hi Team,

Please find the Production environment Database connection failure error below.

2017-11-06 18:32:46,208 [ PegaRULES-Batch-4] [ STANDARD] [ ] [ PegaRULES:07.10] (ion.context.GlobalContextCache) ERROR - Error in counting records in the pr_sys_app_hierarchy_flat table for appHash=PegaRULES!en_US__shared!PRPC:Agents!07.10$20e212aa01214ead2b194eb1f2a19e66

com.pega.pegarules.pub.database.ConnectionException: Database-General Problem encountered when getting connection for database pegarules 0 08S01 The connection to the host DBP_CTRAN2, named instance ctran2p failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

From: (B50B045CA1DC52919EE5A4D05BA235FFB)

Caused by SQL Problems.

Problem #1, SQLState 08S01, Error code 0: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host DBP_CTRAN2, named instance ctran2p failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

Please suggest.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

November 29, 2017 - 12:33am

Hi Pradeep,

If you are facing this consistently then once have a look at 

https://community.spiceworks.com/topic/372789-sqlstate-08s01-08001-connection-failure

If it happened only once then it might be because of temporary network issue.

Regards,
Ujjwal

December 21, 2017 - 10:28am
Response to UjjwalShukla_GCS

Hi Ujjwal,

The article that you have mentioned doesnt have precise information about the RCA of the issue.

This issue has been happening on regular basis.

Please suggest.