hbsites

 
  • Home
  • Blog
  • Admin
  • Microfeed not working on Team Site - Internal error code 54

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:

Comments (2)

  • Conax

    Conax

    15 August 2015 um 05:04 | #

    It seems like from time to time SharePoint lost necessary permission to SQL objects. I wonder why?

    reply

  • Troy West

    Troy West

    12 August 2016 um 02:51 | #

    Thanks for your post was really helpful when the newsfeed stopped workking on a clients environment after patching.

    reply

Leave a comment

You are commenting as guest.