I have recently seen this issue at 2 different customer sites – both with back-end SQL – (Formerly known as Enterprise Edition)
One was inplace upgraded the other one migrated to a clean installed Skype for Busines side-by-side pool
The Response Group usage report is failing – it is trying for a very long time until finally timeout.
The solution is to recreate the index [IX_SessionDetails_CorrelationId_SessionIdTime] on [dbo].[SessionDetails]
I found this posted on a technet forum also – and indeed it seems to work fine 🙂
Run this as a new query against the LcsCDR database in SQL Management Studio
/*
USE [LcsCDR]
GO
DROP INDEX [IX_SessionDetails_CorrelationId_SessionIdTime] ON [dbo].[SessionDetails]
GO
*/
CREATE NONCLUSTERED INDEX [IX_SessionDetails_CorrelationId_SessionIdTime] ON [dbo].[SessionDetails]
(
[CorrelationId] ASC,
[SessionIdTime] ASC,
[ReplacesDialogIdTime] ASC,
[ReplacesDialogIdSeq] ASC,
[CallFlag] ASC,
[MediaTypes] ASC,
[User1ClientVerId] ASC,
[User2ClientVerId] ASC,
[SessionIdSeq] ASC,
[SessionStartedById] ASC,
[User1Id] ASC,
[User2Id] ASC,
[ReferredById] ASC
)
INCLUDE ( [TargetUserId],
[ResponseTime],
[ResponseCode],
[SessionEndTime]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go
/*
USE [LcsCDR]
GO
DROP INDEX [IX_SessionDetails_ReplacesDialogIdTime_SessionIdTime] ON [dbo].[SessionDetails]
GO
*/
CREATE NONCLUSTERED INDEX [IX_SessionDetails_ReplacesDialogIdTime_SessionIdTime] ON [dbo].[SessionDetails]
(
[ReplacesDialogIdTime] ASC,
[SessionIdTime] ASC,
[ReplacesDialogIdSeq] ASC,
[CallFlag] ASC,
[MediaTypes] ASC,
[User1ClientVerId] ASC,
[User2ClientVerId] ASC,
[SessionIdSeq] ASC,
[SessionStartedById] ASC,
[User1Id] ASC,
[User2Id] ASC,
[CorrelationId] ASC,
[ReferredById] ASC
)
INCLUDE ( [TargetUserId],
[ResponseTime],
[ResponseCode],
[SessionEndTime]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
go
Then wait a few minutes a retry the Response Group usage report.
Happy SKYPE’ing – yours truly 🙂
