DWH Job fails with "The semaphore timeout period has expired"

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Load Data Warehouse fails with error:

INFO  2023-05-12 02:24:27,109 [dwh_mssql_error_handling UUID: 9ac5c522-ea6c-4a2d-a068-8c2c31618628] dwh.event Error for table 'DWH_TME_ENTRY_NOTE' - Error Number 121 'TCP Provider: The semaphore timeout period has expired.

Environment

Release : Any Clarity with SQL Server

Cause

The issue is with SQL server network connectivity:

Resolution

1. Ask the DBA team to look into this error, here is some info they can use: 

https://bobcares.com/blog/the-semaphore-timeout-period-has-expired/

2. They may have to engage the Network team as well.