hbsites

 

Microfeed not working on Team Site - Internal error code 54

I installed a SharePoint 2013 farm using AutoSPInstaller. As usually the installation worked well. I then created a new Team Site site collection. The Newsfeed WebPart came up with an error message:

The operation failed because an internal error occurred. Internal type name: Microsoft.Office.Server.Microfeed.MicrofeedException. Internal error code: 54. Contact your system administrator for help in resolving this problem. 

Error Message on Team Site  

First I checked the Distributed Cache. App Fabric Windows Service & Distributed Cache Service were running. The WebParts in MySite were working properly. So Distributed Cache Cluster should be ok. 

I checked the ULS and found the following error message, Level "Unexpected":

SPMicrofeedManager.CommonGetFeedFor: Exception System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'proc_Social_GetSecurityTrimmerEnabled', database 'SP2013_Social', schema 'dbo'. at System.Data.SqlClient.SqlConnection.OnError

Now it became clear that there is a permission issue. The application pool account of the Portal application needs additional rights.

I checked the properties of procedure "proc_Social_GetSecurityTrimmerEnabled" in the Social database:
SpDataAccess

SPDataAccess is the permission that gives the Execute right to the stored procedures. So I grant the role SPDataAccess to the Portal application pool account (here: SP2013_Portal) :
Set SPDataAccess role

Refreshing the site collection the Newsfeed WebPart is working properly: