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.