SKYPE for Business – RGS Reports – BUG

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 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *