SharePoint Usage Analytics is showing data intermittently and now shows 0

Hi All,

We are stuck in SharePoint 2013 usage analytics as out of fix feature. We had similar issues few months back and we ran the usage import and processing timer job which fixed the issue.

We followed these blogs: http://geekswithblogs.net/bjackett/archive/2013/08/26/powershell-script-to-workaround-no-data-in-sharepoint-2013-usage.aspx (which fixed the issue)

After couple months, there were some errors in event viewer:  

07/08/2015 11:30:04.78    OWSTIMER.EXE (0x1E24)    0x2C98    SharePoint Foundation    Health    i0m6     High    Table RequestUsage_Partition12 has 444959368 bytes that has exceeded the max bytes 444959368

We increased the default logging database (6 GB) to 16 GB (WSS_Logging). usage reports were shown for few days and now again usage analytics is showing 0 in Most Popular Items across in web applications. We following this blog that suggest to increase the logging database http://blogs.msdn.com/b/sharepoint_strategery/archive/2012/04/16/usage-file-and-web-analytics-reports-with-blind-spots.aspx     

However, author mentions The property MaxTotalSizeInBytes is exposed by OM code for the SPUsageDefinition object and can be updated with the example PowerShell snippet below. However, updating this value has no immediate impact because this size only applies when creating a LoggingDB. Therefore, you must create a new LoggingDB for the Usage Service Application. The gotcha: this effectively deletes all prior Usage data because the Usage Service Application can only have a single LoggingDB .

We tried to deleted and created new WSS_Logging database and getting some errors:

Error 1: Usage entry dropped due to exception. System.ArgumentException: Value does not fall within the expected range.

    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)

    at System.Web.Hosting.IIS7WorkerRequest.GetServerVariableInternal(String name)

    at Microsoft.SharePoint.Utilities.SPUserAddressMonitor.get_Value()

    at Microsoft.SharePoint.Utilities.SPUserAddressMonitor.get_NameValuePairs()

    at Microsoft.SharePoint.Utilities.SPMonitoredScope.GetNVPValueFromMonitors(IEnumerable`1 monitors)

    at Microsoft.SharePoint.Utilities.SPMonitoredScope.OnDisposing()

    at Microsoft.SharePoint.Utilities.SPResourceBudget.OnDisposing()

    at Microsoft.SharePoint.Administration.SPRequestUsageMonitoredScope.OnDisposing() StackTrace:  at onetnative.dll: (sig=8299e000-0f80-4b71-8567-479075c2110d|2|onetnative.pdb, offset=28B42) at onetnative.dll: (offset=152A9) at Microsoft.SharePoint.ni.dll: (sig=be6b43b8-d8fe-ae77-9616-faf8f4c97515|1|Microsoft.SharePoint.ni.pdb, offset=3C3E2CD) at Microsoft.SharePoint.ni.dll: (offset=3279927) at Microsoft.SharePoint.ni.dll: (offset=2B94064) at Microsoft.SharePoint.ni.dll: (offset=2B9C812) at Microsoft.SharePoint.ni.dll: (offset=2B9C986) at Microsoft.SharePoint.ni.dll: (offset=560CABB) Error 2: No usage log files to import where found with filter 'SMSPWEBTST11-????????-????-????????-????*.usage'. Flushing usage entry cache to storage (count=30).

We researched and could not find any relevant that help us to resolve the issue.
Any suggestions or pointers would be greatly appreciated. 


August 23rd, 2015 10:49pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics