Only one user with contribute access gets access denied to SharePoint site collection. Every SharePoint admin might have faced this issue atleast once. In my case, user is added to a SharePoint group with Contribute access. Access shows up as Contribute when verified through site permissions – check permission option. Every other person in the…
Category: SharePoint 2010
How To, Miscellaneous, SharePoint 2010, SharePoint 2013
Create alerts on views in SharePoint document library
by Bharath Kumar Arja •
This is one of the most frequently raised question or complaint by end users. Why can’t I create alerts on views in my SharePoint library? When you try to setup alerts on items in a library, sometimes you have the option to set ‘Someone changes an item that appears in the following view: Drop down…
SharePoint 2010, SharePoint 2013, SharePoint Search
Application Server Administration job failed for service instance – SharePoint Search error
by Bharath Kumar Arja •
Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (GUID) – Event 6482, SharePoint Server is popping up in the server running Search service once every minute. Search is working fine without any issues, Content sources are crawled, indexes are created normally. No issue on user side of things.But the above error is flooding the event…
SharePoint 2010, SharePoint 2013
The specified database has an incorrect collation
by Bharath Kumar Arja •
The specified database has an incorrect collation. Rebuild the database with the Latin1_General_CI_AS_KS_WS collation or create a new database – got this error when I was trying to mount a content database to an existing Web application in SharePoint using PowerShell command: Mount-SPContentDatabase “Content.database” –WebApplication “http://mysite.company.com” Error message clearly stated that the database is created with incorrect…
Miscellaneous, SharePoint 2010, SharePoint 2013
There was an error opening this document. Access denied – Adobe Reader error
by Bharath Kumar Arja •
One user started getting this ‘There was an error opening this document. Access denied‘ adobe reader error while trying to open any PDF documents downloaded from any SharePoint site. This error shows up irrespective of level of access in SharePoint. Word documents, excel workbooks and all other office documents open up in office client in…
Miscellaneous, SharePoint 2010, SharePoint 2013
EventCache Table in SharePoint Content Database
by Bharath Kumar Arja •
Every SharePoint content database has an EventCache Table. Changes to the SP objects contained in the content database are logged to this EventCache Table. Every change is added as an entry/row to the table. EventCache table is the change log for objects in database. Columns in EventCache Table: Column name Data Type Description EventTime datetime…
Cumulative Updates, SharePoint 2010
Document Conversions Load Balancer Service fails to start after May 2015 CU – SharePoint 2010
by Bharath Kumar Arja •
After installing May 2015 CU for SharePoint 2010 and running PSConfig,it complains that it cannot start ‘loadbalancerserviceinstance’ and warns you to start it manually. PSconfig continues further without any issues and sucessfully upgrades. Here is the exact warning message PSConfig throws – ‘Failed to start loadbalancerserviceinstance on this server. Start this service manually‘ Issue starts…
Configuration, SharePoint 2010, SharePoint 2013, Upgrades
The upgrade command is invalid or a failure has been encountered – PSConfig error
by Bharath Kumar Arja •
Running PSConfig after installing updates is a stressful experience(atleast for me). Every time is comes up with a different challenge. But unlike some unfriendly errors, psconfig gives us much more details about the failures in the upgrade logs. Okay then, I was updating SharePoint 2010 with May 2015 CU. Everything goes well until – The…
MS Office, SharePoint 2010, SharePoint 2013
Sorry, we couldn’t open .xlsx file – Excel error
by Bharath Kumar Arja •
We had one user constantly having issues while opening Office documents stored in SharePoint site. Sorry, we couldn’t open ‘http://sharepointsite/sites/teams/documents/report.xlsx’ file. Even though it is one user, he had issues with multiple office files. We tried with user logging into another machine and try accessing the file. As expected, all the files open fine. This makes…
Miscellaneous, SharePoint 2010, SharePoint 2013
Move documents to a different library without losing version history
by Bharath Kumar Arja •
There can be many scenarios where you would want to move documents to a different library without losing version history. Either you need to have 3rd party tools for migration or you have to use good old explorer view to migrate the documents. If you try to copy over the files by opening both the…