Wednesday, June 25, 2014

How to enable SharePoint Library "Open in explorer"

To resolve this please do the following steps.

1) Open the “Service.msc” (Press Windows + R Enter Service.msc)2)  Search “WebClient” -> right click -> Properties -> Set Startup Type Properties to Automatic and start the service
3) Restart the System.
4) Browse SharePoint Library and you should be able to use "Open with explorer" option.

Friday, June 20, 2014

Microsoft SharePoint Word Web App - Unable to open word files in client

When I tried opening word documents from a SharePoint library it was opening in in WebApps. When ti tried to open in word it was throwing a following error.
I thought something is wrong in my workstation. Then I found that I was using 64bit IE and switched to 32 bit IE. I am now able to open word documents using 32 bit IE. Wondering what could be the reason? Can any one help me?

Wednesday, June 18, 2014

Unable to display this web part error.To troubleshoot the problem, open this Web page in a Microsoft SharePoint Designer

Me and my colleagues were getting this error "Unable to display this web part. To troubleshoot the problem , open this page in ......" on a particular web application.

I analyzed and found that this is due to XSLT error. As I have to fix this issue quickly ,  I stopped the web application and started it again. The problem is gone but I was not happy with the way I handled this issue. 

Hence I analyzed further and found that I need to increase the XSLT transformation time out. I wanted to check the default time for XSLTTransformtimeout in my farm , and by using the following powershell command I found that it was set to 1.  

$farm = Get-SPFarm

As a precautionary measure, I increased the XSLTTranfromtimeout to 5 and till now the problem did not occur. 

$farm = Get-SPFarm
$farm.XSLTTransformTimeout =5

Now I have to check in the forthcomingdays, if this problem will be shown again or not. Do you recommend that this fix will work?. Please help me with your suggestions.

FYI: XSLTTransformTimeout property is available with the Feb 2012 CU for SharePoint 2010 Server. 

Tuesday, June 17, 2014

How to delete users from UserInformation hidden List

Today, one of the user reported that he has re-joined the company , and he is not able to access any of the SharePoint sites. The site-collection owner gave permission to this user , using the old identity, because the people picker will show identities from UserInformation List(hidden list)

As you know SharePoint maintains a hidden list called UserInformation list to store identities located at http://<SiteCollectionUrl>/_catalogs/users/detail.aspx . I used the following power-shell script , just to refresh his identity in User Information List. It did not work.

$web=Get-SPWeb ""
$web|Set-SPUser -identity "Domain\UserID" -SyncFromAD

After further digging, I found a way to delete the user's old identity from the  UserInformation List. Here are they.

1) Choose any  SharePoint groups in the Sitecollection. It will route to the following URL(http://<SiteCollectionUrl>/_layouts/people.aspx?MembershipGroupId=XXXXX)
2) Replace XXXXX with 0.
3) You should be able to see all the users
4) Delete the user whom you want to delete

After performing these steps , now the UserInformation List shows the recent identity of the user and the user was able to access the SharePoint sites.

BTW: Does anyone have any Power Shell script to do this activity?

Monday, June 16, 2014

Increase SiteQuota SharePoint 2010

Yesterday , a site-collection administrator got an automated email from my SharePoint 2010 farm stating that "You are receiving this e-mail message because you are an administrator of the following SharePoint Web site, which has exceeded the warning level for storage".

I was notified of this email and I immediately accessed CA->Site Collection Quotas and Limits and bumped up the "Limit site storage" 20GB, but still the site-collection administrator was receiving the same email. Then I realized that I did not bump up the "Send warning email when site storage reaches" as the current storage was more than that.

Then after bumping up the "Send warning email when site storage reaches" value , the site-collection administrator was not getting reminder email. So the lesson for me is when you increase the "Site storage" make sure you also increase the warning email value as well


Tuesday, June 10, 2014

MOSS 2007 sitecollections locked

Well, yesterday morning , none of our MOSS 2007 users were able to do anything on our MOSS 2007 web applications.  I checked my Content DB & Config DB whether it is set to read-only , but it is not. I checked for Quiescing , but it is not.

Finally used control point and , found that all the Site collections were set to read only. Due to the urgency of the situation I executed this script to unlock more than 2000 site collections one by one.
stsadm -o setsitelock -url <URL name> -lock {none | noadditions | readonly | noaccess}

Prior to executing this script, I used stsadm -o enumsites -url <URL name> and stored the url in a file.

Does anyone have a comprehensive script , which can iterate through the Site collections to unlock it , using stsadm? I am now investigating how site collections got locked. Any suggestions?