SharePoint Real Time Errors and Solutions

The workbook cannot be opened ​This is a general issue with many SharePoint users while opening an Excel workbook (.xlsx) in the browser the error "The workbook cannot be opened" or “The site is not added in trusted location”. But if the file is opened with Workbook in the desktop client it will not have any  problems with it. The root cause of this error message is due to below reasons: a)      The URL user is trying to access is not correct/wrong. b)      The document library settings for opening the files in browser mode. So in order to overcome these simple error message we need to make sure that we are using the correct URL and other library settings are in place as per recommendation. a)      On the <document library>: All Documents page, under Library Tools, click Library b)     In the library toolbar, click Library Settings. c)      On the Document Library Setti...

SharePoint 2010 Target Audience not working for Trusted Domain As mentioned ion the above screenshot whenever a user had an issue : User is unable to add audience targeting for  a folder on a site. Issue Details :  When the user navigates to the site--> Site settings --> Navigation and at the bottom usrs selects the folder and is trying to add Audience .When the user selects the search user and is able to find the SharePoint group or Security group , user is able to find the group name in the search,however when the user clicks on the people picker the error as in the screenshot is generated. It is a prerequisite for Audience targeting that User Profile service is setup on the SharePoint farm.Only from the SharePoint service we will enable audience targeting.  In my case the user was facing the issue in an extranet environment. There is a trust relationship setup between the extranet domain and the Internal domain. SharePoint Domain : corp....

Users complained that they are getting  : Internal Server Exception Error  whenever they search on a SharePoint Portal. This error occurs only on the very first search , when the page is refreshed search results appear normally. Explanation : As the Search Functionality whenever a user searched with their query in the search box the query hits the WFE  and from the WFE the request will be processed to the server on which the Search Query and site settings service is configured (Started). Analysis : After looking into the below logs I searched for the above mentioned service (Search Query and site settings service is configured (Started). on all the servers but this error logs were found only 1 server and this is a WFE. It is marked in bold below. The search is not configured on this server , however I noticed that the service for Search Query and site settings service is started on this WFE. So Ideally this service should be running only on the servers w...

Troubleshooting steps: ​Checked the ULS Logs Checked the SMTP Services-->OK  and Logs at  : C:\inetpub\mailroot\Badmail -->OK Checked IIS Manager 6.0 and no issues found. Checked Incoming email settings in the SharePoint Central Administration -->System Settings --> Incoming email settings. Checked the Email settings in the site . ULS Logs Message : The Incoming E-Mail service has completed a batch.  The elapsed time was 00:00:00.  The service processed 0 message(s) in total. Noticed thatt he emails were struck in C:\inetpub\mailroot\Drop Checked the Timer jobs and tried restarting the SharePoint foundation Incoming email service from the server to check if the Timer job is running.The timer job was not found in the running Jobs. Noticed that the Timer Service sv42080oel1191 server was stopped. Restarted teh service and refreshed the C:\inetpub\mailroot\Drop folder and all the emails started clearing. and confirmed tha...