- Users fails to enumerate/launch published resources
- VDAs may attempt to re-register with all the delivery controllers
- Event ID 1201 and 1200 logged in application event logs of all the delivery controllers


- Running Get-BrokerServiceStatus from the DDC will intermittently return 'PendingFailure'


- Analyzing SQL side logs shows high number of blockings on [chb_state].[sessions] table where most of the SPIDs entangled in blocking chain will be calling one of our stored procedure [chb_state].[UpdateSessionIdleTimes] simultaneously from all the delivery controllers. 

The fix for bug ID - CVADHELP-14876 has been included with CVAD 1912CU2 and upgrading the CVAD version to CU2 should resolve this issue  

Ref# https://docs.citrix.com/en-us/citrix-virtual-apps-desktops/1912-ltsr/whats-new/cumulative-update-2/fixed-issues.html

 

---

Problem Cause

This issue is caused due to real time wait times inconsistent with the size and increased number of executions of UPDATE activity against [Chb_state].[Sessions] table which subsequently analyze race condition, likely constrained by a default 30 second time out period (SdkSqlQueryTimeoutSecs) hence transaction failure for broker service which trigger event ID 1201 on the delivery controllers.

https://docs.citrix.com/en-us/citrix-virtual-apps-desktops/1912-ltsr/whats-new/cumulative-update-2/fixed-issues.html