Skip to main content
Notice removed Draw attention by CommunityBot
Bounty Ended with no winning answer by CommunityBot
Notice added Draw attention by Mark L
Bounty Started worth 50 reputation by Mark L
added 580 characters in body
Source Link
Mark L
  • 4.1k
  • 7
  • 66
  • 133

Recently we have patched our SharePoint 2013 on-premise farm to Configuration database version: 15.0.4763.1000. We found that after patch all site collections' popularity trend report shows zero count after the date of patch. The counts before patch date are correct.

I cannot find any bug report about it. Could you please advise where to check?

UPDATE: I checked the EventStore folder (C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Analytics_{GUID}\EventStore) contains folders with date before patch. So it means the patch make the EventStore stop update. Also I checked the Usage File Creation at D:\LOGS\RequestUsage\. The ImportProgress.ini file is up-to-date according to last modified date.

In the WSS_Logging database I query: Select top 20 userlogin,RowCreatedTime,DocumentPathOriginalCasing from dbo.RequestUsage (nolock) where RequestType='GET' order by RowCreatedTime desc The last valid record RowCreatedTime is dated before patch.

UPDATE2: Checked again the D:\LOGS\RequestUsage\ImportProgress.ini file is NOT up-to-date on one of WFE server. It stopped update since the day of patch. The same file is up-to-date for other WFE and APP servers. Also in the event viewer for the problematic server, it shows

The Execute method of job definition Microsoft.SharePoint.Administration.SPUsageImportJobDefinition (ID <GUID>) threw an exception. More information is included below.

Index was outside the bounds of the array. 

Seems I am close to the problem but I don't know how to solve it.

Recently we have patched our SharePoint 2013 on-premise farm to Configuration database version: 15.0.4763.1000. We found that after patch all site collections' popularity trend report shows zero count after the date of patch. The counts before patch date are correct.

I cannot find any bug report about it. Could you please advise where to check?

UPDATE: I checked the EventStore folder (C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Analytics_{GUID}\EventStore) contains folders with date before patch. So it means the patch make the EventStore stop update. Also I checked the Usage File Creation at D:\LOGS\RequestUsage\. The ImportProgress.ini file is up-to-date according to last modified date.

In the WSS_Logging database I query: Select top 20 userlogin,RowCreatedTime,DocumentPathOriginalCasing from dbo.RequestUsage (nolock) where RequestType='GET' order by RowCreatedTime desc The last valid record RowCreatedTime is dated before patch.

Recently we have patched our SharePoint 2013 on-premise farm to Configuration database version: 15.0.4763.1000. We found that after patch all site collections' popularity trend report shows zero count after the date of patch. The counts before patch date are correct.

I cannot find any bug report about it. Could you please advise where to check?

UPDATE: I checked the EventStore folder (C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Analytics_{GUID}\EventStore) contains folders with date before patch. So it means the patch make the EventStore stop update. Also I checked the Usage File Creation at D:\LOGS\RequestUsage\. The ImportProgress.ini file is up-to-date according to last modified date.

In the WSS_Logging database I query: Select top 20 userlogin,RowCreatedTime,DocumentPathOriginalCasing from dbo.RequestUsage (nolock) where RequestType='GET' order by RowCreatedTime desc The last valid record RowCreatedTime is dated before patch.

UPDATE2: Checked again the D:\LOGS\RequestUsage\ImportProgress.ini file is NOT up-to-date on one of WFE server. It stopped update since the day of patch. The same file is up-to-date for other WFE and APP servers. Also in the event viewer for the problematic server, it shows

The Execute method of job definition Microsoft.SharePoint.Administration.SPUsageImportJobDefinition (ID <GUID>) threw an exception. More information is included below.

Index was outside the bounds of the array. 

Seems I am close to the problem but I don't know how to solve it.

Tweeted twitter.com/StackSharePoint/status/696433673470656512
added 252 characters in body
Source Link
Mark L
  • 4.1k
  • 7
  • 66
  • 133

Recently we have patched our SharePoint 2013 on-premise farm to Configuration database version: 15.0.4763.1000. We found that after patch all site collections' popularity trend report shows zero count after the date of patch. The counts before patch date are correct.

I cannot find any bug report about it. Could you please advise where to check?

UPDATE: I checked the EventStore folder (C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Analytics_{GUID}\EventStore) contains folders with date before patch. So it means the patch make the EventStore stop update. Also I checked the Usage File Creation at D:\LOGS\RequestUsage\. The ImportProgress.ini file is up-to-date according to last modified date.

In the WSS_Logging database I query: Select top 20 userlogin,RowCreatedTime,DocumentPathOriginalCasing from dbo.RequestUsage (nolock) where RequestType='GET' order by RowCreatedTime desc The last valid record RowCreatedTime is dated before patch.

Recently we have patched our SharePoint 2013 on-premise farm to Configuration database version: 15.0.4763.1000. We found that after patch all site collections' popularity trend report shows zero count after the date of patch. The counts before patch date are correct.

I cannot find any bug report about it. Could you please advise where to check?

UPDATE: I checked the EventStore folder (C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Analytics_{GUID}\EventStore) contains folders with date before patch. So it means the patch make the EventStore stop update. Also I checked the Usage File Creation at D:\LOGS\RequestUsage\. The ImportProgress.ini file is up-to-date according to last modified date.

Recently we have patched our SharePoint 2013 on-premise farm to Configuration database version: 15.0.4763.1000. We found that after patch all site collections' popularity trend report shows zero count after the date of patch. The counts before patch date are correct.

I cannot find any bug report about it. Could you please advise where to check?

UPDATE: I checked the EventStore folder (C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Analytics_{GUID}\EventStore) contains folders with date before patch. So it means the patch make the EventStore stop update. Also I checked the Usage File Creation at D:\LOGS\RequestUsage\. The ImportProgress.ini file is up-to-date according to last modified date.

In the WSS_Logging database I query: Select top 20 userlogin,RowCreatedTime,DocumentPathOriginalCasing from dbo.RequestUsage (nolock) where RequestType='GET' order by RowCreatedTime desc The last valid record RowCreatedTime is dated before patch.

added 381 characters in body
Source Link
Mark L
  • 4.1k
  • 7
  • 66
  • 133

Recently we have patched our SharePoint 2013 on-premise farm to Configuration database version: 15.0.4763.1000. We found that after patch all site collections' popularity trend report shows zero count after the date of patch. The counts before patch date are correct.

I cannot find any bug report about it. Could you please advise where to check?

UPDATE: I checked the EventStore folder (C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Analytics_{GUID}\EventStore) contains folders with date before patch. So it means the patch make the EventStore stop update. Also I checked the Usage File Creation at D:\LOGS\RequestUsage\. The ImportProgress.ini file is up-to-date according to last modified date.

Recently we have patched our SharePoint 2013 on-premise farm to Configuration database version: 15.0.4763.1000. We found that after patch all site collections' popularity trend report shows zero count after the date of patch. The counts before patch date are correct.

I cannot find any bug report about it. Could you please advise where to check?

Recently we have patched our SharePoint 2013 on-premise farm to Configuration database version: 15.0.4763.1000. We found that after patch all site collections' popularity trend report shows zero count after the date of patch. The counts before patch date are correct.

I cannot find any bug report about it. Could you please advise where to check?

UPDATE: I checked the EventStore folder (C:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Analytics_{GUID}\EventStore) contains folders with date before patch. So it means the patch make the EventStore stop update. Also I checked the Usage File Creation at D:\LOGS\RequestUsage\. The ImportProgress.ini file is up-to-date according to last modified date.

Source Link
Mark L
  • 4.1k
  • 7
  • 66
  • 133
Loading