Error when opening details view for SharePoint 2013 Apps

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

image

Leave a Reply

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