Archive for December, 2013

December 20, 2013

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:

sharepointfeed_error_1I 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

sharepoint_Feed_error_3

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

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

Advertisements
December 8, 2013

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: probsOne 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 :

final