Question

2
Replies
1298
Views
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 221 posts
Anthem
Posted: November 28, 2017
Last activity: December 21, 2017
Posted: 28 Nov 2017 8:22 EST
Last activity: 21 Dec 2017 10:28 EST
Closed

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.
System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.