SharePoint 2013 My Newsfeed ‘Everyone’ Internal error code 55

I came across an error in Share Point News Feeds. When I clicked on ‘Everyone’ in the My newsfeed. The following error occurred:

I had to give the service account that is running the User Profile Service application pool full control permissions for the User Profile Service Application.

Follow the below steps:

SharePoint Central Administration–> Application Management–> Manage service Applications

In Service applications Page, select User profile service application–> select permissions in the top ribbon

Assign full permissions for the account used to run User profile service application

Upon following the steps above the feeds started to work as usual. 🙂

SQL Database State stuck in Restoring

Suddenly one of the production SharePoint site in one of our client site was down. When tried to browse the site was getting the error “Cannot connect to the configuration database. So i logged into the database server and was able to see the following: One of the database was get stucked in the restoring mode. The rest of the databases was in the mode of restoring. I was waiting for more than one hour to let the restoring process get finish and unfortunately nothing happened. 😦

So the resolution is to:

Execute the following command in any case if your database get stucked at the time of restoring:

RESTORE DATABASE [DATABASENAME] WITH RECOVERY;

Once i execute the above i was getting the following error:

Msg 3104, Level 16, State 1, Line 1
RESTORE cannot operate on database ‘kiainternet01’ because it is configured for database mirroring. Use ALTER DATABASE to remove mirroring if you intend to restore the database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

i didn’t aware the above database is configured for mirroring. So i had to switch off the mirroring temporarily using the following command:

ALTER DATABASE [DATABASENAME] SET PARTNER OFF;

upon that executed the following command:

RESTORE DATABASE [DATABASENAME] WITH RECOVERY;

finally the databases were online :