We were unable to view the details for all SharePoint 2013 Apps. The following errors were visible:
Event Viewer
Insufficient SQL database permissions for user ‘Name: NT AUTHORITY\IUSR SID: S-1-5-17 ImpersonationLevel: Impersonation’ in database ‘WSS_UsageApplication’ on SQL Server instance ‘********. Additional error information from SQL Server is included below.
The EXECUTE permission was denied on the object ‘prc_CountAppInstanceData’, database ‘WSS_UsageApplication’, schema ‘dbo’.
ULS Viewer
Insufficient SQL database permissions for user ‘Name: NT AUTHORITY\IUSR SID: S-1-5-17 ImpersonationLevel: Impersonation’ in database ‘WSS_UsageApplication’ on SQL Server instance ‘*********’. Additional error information from SQL Server is included below. The EXECUTE permission was denied on the object ‘prc_CountAppInstanceData’, database ‘WSS_UsageApplication’, schema ‘dbo’.
Solution
I have spent a fair share of troubleshooting but could not find a solution where we were able to maintain the Web Analytics data. We created a new Logging Database for the Usage logs (this will remove all previous web analytics) with the following PowerShell command.
Get-SPUsageApplication | Set-SPUsageApplication -DatabaseServer "********" -DatabaseName "WSS_UsageApplication2"
The view works after creating a new database