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.