SQL Server Agent LcsLog purge job fails with error in certain scenarios in Skype for Business Server

Applies to: Skype for Business Server 2015Skype for Business Server 2019

Symptoms


The LcsLog purge job may fail with the following error message in Microsoft Skype for Business Server 2019 or Skype for Business Server 2015:
Message: The DELETE statement conflicted with the REFERENCE constraint "FK_FocusJoinsAndLeaves_4". The conflict occurred in database "LcsLog", table "dbo.FocusJoinsAndLeaves". The statement has been terminated.​

Resolution


To fix this issue, install one of the following updates: