Sunday, December 21, 2014

SSRS - Display fixed number of rows per page with report headers.

For one of our KPI report hosted on SharePoint, the users want to have fixed headers when they use horizontal scroll. We tried to use the OOTB features(Fixed data=True) but it does not work out properly for us. Hence decided to have fixed number of rows per page and show the headers in each page.

It was decided to have 10 rows per page. I followed what is given in this blog. The downside of it , the headers were visible only in the first page and the subsequent pages did not show the headers. So found a work around which is to add group header while performing step 1 of that blog.

I copied and pasted the report header as the group header and deleted the report header. Then followed the subsequent steps as given in the blog. Now all the pages had headers with fixed number of rows.

Hope this helps you!!!

Saturday, December 13, 2014

Local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.

One of my newly joined team member was getting this error on his powershell editor. Following has been done to fix this.

Log on to the DB server choose the SharePoint Config DB -> provide the user with the following membership SharePoint_Shell_Access and db_owner. 

Hope this helps you!!!

SiteActions menu is not displaying properly

After we deployed a WSP in our production SP 2010 farm, one of our application did not show Site actions menu properly.
We tried the following steps

1) We checked the WSP\code thoroughly and could not find anything.
2) Checked the permissions of all the users and could not find anything.
3) Retracted the new WSP and deployed the backed up WSP(As a process we always take a backup of  WSP's). It did not work.
4) Checked all other production applications, they did not have any issues.
5) Checked Central Administration -> Manage Content Database Settings , the database was not offline.
6) Checked Central Administration -> Site Collection Quotas and Locks and found that the DB was set to ReadOnly. Removed the lock status and Site Actions menu started showing up.

I hope this helps you!!!

Monday, December 1, 2014

SSRS Parameters\Filters should be displayed only in print.

My business users wanted to display parameters(Country, Street, Phone) on the page header only when it is printed and they do not want to show it while rendering the SSRS report.


To achieve this I did the following

1) Inserted a rectangle in the page header and added the parameters.
2) In the rectangle properties -> Visibility -> Enable Show hide based on an expression.
3) In the expression window add the following expression and save the report.
=IIF(Globals!RenderFormat.Name = "IMAGE", False, True)





Thus the country, street and phone parameters are shown only during print and they are not shown during report rendering.

Hope this helps!!!

Wednesday, November 5, 2014

Could not load file or assembly 'RSSharePointSoapProxy' - Solved

The error showed something to do with Reporting services and check that under general settings of CA. The following application setting was missing.



Then found that we need to downloaded and install "Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010"  . Did the same and then the problems seems to be fixed. Hope this helps you!!!

Tuesday, November 4, 2014

The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded.

After I installed SSRS on SharePoint integrated mode, when I tried to configure SSRS using configuration manager I got the following error.


The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpSecurity.set_StaticCatchAccessDeniedException(Boolean value) at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled) .


The reason for this error is , I installed SSRS on the SQL Server, rather then installing it on the SharePoint farm. Then I corrected my mistake by installing it on the SharePoint farm. Hope this helps!!!

Sunday, November 2, 2014

SSRS native mode reports and SharePoint 2010

I am now developing SSRS reports which will be hosted on native mode. These SSRS reports will be consumed by SharePoint 2010 applications. To consume native mode SSRS reports please follow the below steps.
  1. Copy the RSWebParts.cab to a folder on the SharePoint server. By default the RSWebparts.cab can be found in "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint".
  2. On the SharePoint Server run the STSADM command on the RSWebParts.cab file using the following syntax "STSADM.EXE -o addwppack -filename "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall". -globalinstall is must if you want to create connected web parts.
After these you will be able to use Report Viewer web parts, which are under miscellaneous categories.


Hope this helps you!!!


Friday, October 24, 2014

PerformancePoint Services error code 20700 - Resolved

I was working with Performance Point 2010 application and I got this following error. The performance point application was pointing to a SSAS cube and it was configured to refresh now and then.
Following error was displayed in the event viewer.



I checked the permissions of the page in which the aforementioned error was appearing and nothing has changed. I checked whether something has changed in cube, but nothing appears to be.  Finally I altered the data connection in performance point dashboard designer to point to some other cube(as a precautionary measure) and then back to the original cube.

Then things have started working. Hope this helps you!!!

Saturday, October 18, 2014

Correlation ID - Not found in the ULS logs - Resolved

We are in the process of migrating SharePoint 2010 to SharePoint 2013 using Content DB detach and attach method. After attaching the content DB , when we browsed the default.aspx, we were getting "File not found" error , but the Correlation ID could not be found anywhere in the ULS (even after setting the logging level to verbose).

Finally in the web.config file and did the following settings

1) Set CallStack=True
2) Set Debug = True
3) Set CustomError= OFF

These settings helped me to see the yellow screen of death. After right clicking this screen -> View Source, I was able to see the exact error. Hope this helps you!!




 

Sunday, October 12, 2014

Create a site collection in SharePoint 2013 with SharePoint 2010 user experience

In my organisation there is a need that we need to create a  site collection in SharePoint 2013 with SharePoint 2010 user experience. Here are the steps to accomplish it.

Step 1:
Create/Use a web application in SharePoint 2013.

Step 2:
Open CA->Application management -> Create Site Collections. After filling out the Title and URL , there is a template section and choose Select Experience Version as 2010.

I created a publishing site template and it looks like SharePoint 2010 publishing template.

There will be a notification which will request you to experience what SharePoint 2013 to offer. Click on Remind me later and then you are good to go using the site collection with SharePoint 2010 user experience.



Hope this helps you !!!

Monday, October 6, 2014

PowerShell - Microsoft SharePoint is not supported with version 4.0.30319.18063 of the Microsoft .Net Runtime - Resolved

We tried to Install SPDiag 3.0 for our SharePoint environment, which provides SharePoint administrators with a unified interface that can be used to gather relevant information from a farm,

It also displays the results in a meaningful way, to identify performance issues, and share or export the collected data and reports.


When we tried to create a project , it was throwing the following error.




The error message was " Microsoft SharePoint is not supported with version 4.0.30319.18444 of the Microsoft .Net Runtime".

I did try to change the Psconfig.exe.config to point to .Net 2.0 and it did not solve the problem. So finally decided to uninstall Microsoft Windows Management framework 3.0 from installed windows updates.

After uninstalling , things started working. Hope this helps you.


SharePoint 2010 - Remote Blob Storage Impersonation issue - Resolved

When we configured RBS in our test environment as per this technet arcticle , but when we tried to upload documents, we were unable to upload documents. Further increasing the logging to Verbose we found the following error in ULS log.

Exception thrown storing stream in new SqlRemoteBlob: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Data.SqlRemoteBlobs.RemoteBlobStoreException: The blob store <FilestreamProvider_1> threw an exception. The exception thrown is saved in InnerException. ---> System.ComponentModel.Win32Exception: Either a required impersonation level was not provided, or the provided impersonation level is invalid.

We did so many things without success and finally found this blog which states that the version of the operating system on all the servers in the farm should be identical.

Seconding that , our test environment , the SharePoint environment was on Win 2008 Enterprise SP2 and the DB server was on Win 2008 R2 Enterprise SP1. Hence decided to Install and Configure RBS in another farm where SharePoint environment was on Win 2008 R2 Enterprise SP1 and DB server was on Win 2008 R2 Enterprise SP1.

After installing/configuring RBS, we are able to upload documents and RBS is working like a charm.

Note: OOTB you cannot upload documents which is greater that 2GB when RBS is enabled.

Hope this helps you

Sunday, October 5, 2014

Installing and Configuring PowerPivot in SharePoint 2010

As I had to install and configure PowerPivot in my new farm, I thought that I can share the steps with you.

Pre-Requisites:

1) Must have one or more SharePoint web applications that are configured for classic mode authentication.

2) PowerPivot data access will only work if the web application supports classic mode authentication.

3) SharePoint 2010 SP2 must be installed before you can configure PowerPivot for SharePoint.

Installation Steps

Step 1) Mount the SQL Server Installables in the SharePoint farm's app server or any other server that is in which you want to install PowerPivot. Run the Setup.exe , it will launch SQL Server Installation Center and click on Instalation -> New Installation or add features to an existing installation.

Step 2) You have to install , Setup Support files, and click Install. Make sure you correct the failures.
Step 3)Choose Installation Type as New Installation and add shared features enter the Product Key  accept License Terms and Click Next.

Step 4)Now in the Setup Role choose SQL Server PowerPivot for SharePoint -> Add PowerPivot for SharePoint to -> Existing Farm and Click Next.
Step 5)In this step , you will see pre-selected features and Click Next,
Step 6) Installation Rules will run and make sure you correct the failure and Click Next
Step 7) In the Instance Configuration screen  you might want to accept the default named instance and instance ID. Click Next.

Step 8) It will check for Disk Space Requirements and Click Next.

Step 9) In this step, make sure you provide a dedicated domain account for SQL Server Analysis Services. If you try to provide built in domain accounts the wizard will not accept it. Click Next.
Step 10) In the Analysis Services Configuration screen specify your Analysis Services administrators(they will have unrestricted access to Analysis services).  In the Data Directories and make necessary drive changes. Click Next 
Step 11) Error Reporting screen will appear. Click Next. 
Step 12) In the Installation Configuration screen , make sure you do not have any errors. Click Next

Step 13) In the Ready to Install screen, review the content and click on Install. Installation will continue and you might be asked to restart the server. 

Configuration Steps

Step 1) Once the installation is completed , launch CA -> System Settings > Manage services on server and check the SQL Server Analysis Services and SQL Server PowerPivot System Service are started. Also make sure  Claims to Windows Token Service and Secure Store Service are started.





Step 2) Launch CA -> System Settings > Farm Management > Manage farm solutions. There will be two solutions Powerpivotfarm.wsp and Powerpivotwebapp.wsp. Out of which Powerpivotfarm.wsp is globally deployed. The powerpivotwebapp.wsp is only deployed to SharePoint CA and you have to manually deploy  Powerpivotwebapp.wsp to the web application in which you want to have PowerPivot. 
Step 3) Creating the PowerPivot Service Application
Launch CA ->Application Management -> Service Applications- > Manage service applications. Click on New and select SQL Server PowerPivot Service Application.
Make sure that the “Add the proxy for this PowerPivot service application to the default proxy group” is checked.



Step 4) Configure Excel services and Secure Store. I have configured Excel services and Secure Store Services earlier , but there are lot of articles available for this.  

Step 5)  In your SharePoint Site-> SiteActions->Site Settings > Site Collection Administration > Site Collection Features-> Activate the PowerPivot Feature Integration for Site Collections feature.


You might want to check Step2 (To deploy Powerpivotwebapp.wsp to your  SharePoint Site) before doing this step.

Step 6) In your SharePoint Site ->SiteActions->More Options->Choose PowerPivot Gallery and upload the Pivot Sheets and let the users use it.

Hope this helps you!!!








Sunday, September 28, 2014

Format Commands for PowerShell Output .

I was trying to get the list of timer jobs and their frequency in a table format using powershell. I searched technet and after reading through this  I figured it out.

I tried Get-SPTimerJob |Format-Table -Wrap   -AutoSize -property name,schedul
e,description,webapplication > D:\Timerjobs.txt.

Somehow the output text file showed only the name of the timerjobs with the following message

"WARNING: 3 columns do not fit into the display and were removed."

After a subtle thought I used the following command and got the results in a way I wanted.

Get-SPTimerJob |Format-Table -Wrap  -property name,schedul
e,description,webapplication > D:\Timerjobs.txt

Another interesting parameter you might want to use is ConvertTo-HTML , which will create a HTML report .

Get-SPTimerJob |ConvertTo-HTML -property name,schedul
e,description,webapplication > D:\Timerjobs.htm

Hope this helps you.

Saturday, September 20, 2014

The term 'get-spfarm' is not recognized

I was using Windows Poweshell - ISE for creating some power shell scripts and got the following error.

"get-spfarm : The term 'get-spfarm' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again."

Checked the PowerShell Code and found that I forgot to add powershell snapin and added the following and the script got executed.

Add-PSSnapin "Microsoft.SharePoint.PowerShell" 

Thursday, September 18, 2014

ExecuteOrDelayUntilScriptLoaded with SP.JS

There was a survey that the management wanted to publish depending on the domain of the logged on user. Say if the user belongs to Asia and America, the system should popup a dialog for the survey. We decided to use JavaScript client object model to find the domain of the logged on user.

We used the following code on the home page which already had some JavaScript menus.

ExecuteOrDelayUntilScriptLoaded(init, "sp.js");

function init() 
{
            this.clientContext = new SP.ClientContext.get_current();
            this.oWeb = clientContext.get_web();
            currentUser = this.oWeb.get_currentUser();
            this.clientContext.load(currentUser);
            this.clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed));
    
}

After applying this code the JavaScript menus were not coming up. So checked the code and found that ExecuteOrDelayUntilScriptLoaded has to be used with a function name. Hence changed the code like below and JavaScript menus started coming up.

jQuery(document).ready(function() {
 ExecuteOrDelayUntilScriptLoaded(init, "sp.js");
});
       
  //      ExecuteOrDelayUntilScriptLoaded(init, "sp.js");
         function init() {
            this.clientContext = new SP.ClientContext.get_current();
            this.oWeb = clientContext.get_web();
            currentUser = this.oWeb.get_currentUser();
            this.clientContext.load(currentUser);
            this.clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed));
   
        }

Hope this helps you!!!



Tuesday, September 16, 2014

Merge ULS Logs to find Correlation ID

There was an issues in the BCS settings of my SharePoint 2010 farm and I need to search for a particular message in my farm. I had to login each searver of my farm search through the ULSLogs to find a specific error message.

I did want to find a shortest route for this and found the Merge-SPLogFile Power Shell that will merge all the logs from your farm to a specific directory depending on the parameters.

This will take some time to execute, and at the end you will have the ULS Logs at  one place , which can be used to skim through the errors.

Hope this helps you.



Monday, September 15, 2014

Cannot start service SPAdminv4 on computer . PSConfig fails "InvalidOperation Exception" after SP2 Install

I was setting up a new SharePoint server and after installing SP2, ran the PSConfig wizard which failed with the error "System.InvalidOperationException, “Cannot start service SPAdminv4 on computer ‘.'”.

Found this blog and followed the steps given. It solved the problem for me. Hope it helps you as well.

Powershell to find Orphaned Databases

To get a list of orphaned databases : Get-SPDatabase | where {$_.exists -eq $false}

To delete the orphaned databases : Get-SPDatabase | where {$_.exists -eq $false} | foreach {$_.delete()}

Hope this helps you

Sunday, September 14, 2014

Exception from HRESULT: 0x80131904 -While updating a list item.

We had this issue, in one of our application in my farm. User's were not able to edit a list and it was throwing this error. "System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80131904".

Googling pointed  out that there might be a problem in the content database.

1) So we increased the Content DB Autogrowth size from 50MB to 500MB. This has not resolved the issue.

2) Dropped the indexes and recreated the indexes for the problematic list. This also did not resolve the issue.

Finally found the issue is with UserType look-up fields did not have target list defined and hence cannot locate the users it needs to. So had to update the affected fields to the correct reference of User Information List, exported the list, deleted the original list item from the list settings (Make sure you have content DB backup) and import the list again. This solved the problem.

Many people had different way of fixing the "HRESULT: 0x80131904" error , but in my case it was for look up column. Hope it helps.



Thursday, August 28, 2014

Powershell Command to get List Schema.xml in ClipBoard

Please use the following Power Shell command

$web = Get-SPWeb XXXX
$list= $web.lists[Your Lists]
$list.Fields.SchemaXml | clip


Tuesday, August 19, 2014

SharePoint Crawl DB size was too large

Our SharePoint 2010 farm's crawl DB was at 250 GB which is very unusual. According to this post the size of the crawl DB should be 0.046 × (sum of content databases). Sum of my content DB size is around 1TB and the crawl DB size should be around 46 GB.

Finally decided to reduce the size of it by applying host distribution rules or shrink the crawl DB. I chose to do the second option and did the following. Now the crawl DB size is close to the 45 GB .

1) Central Admin-> Search service admin -> Index Reset. This will erase all the content Index.
2) DB Server->Choose the Crawl DB ->Shrink the Crawl DB files. This will shrink all the mdf/ldf files and size of your DB will be meager.
3) Kicked off a full crawl.

But the shortcoming of these steps is I lost the entire crawl history. Hope this post helps you as well.

Tuesday, July 29, 2014

'\MSOLAP$POWERPIVOT:Memory\Memory Limit High KB' performance counter could not be found

I had problems in doing a data refresh for PowerPivot sheets. In the ULS logs I was getting the following error

System.ServiceModel.FaultException`1[[System.ServiceModel.ExceptionDetail, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken= ]]: The '\MSOLAP$POWERPIVOT:Memory\Memory Limit High KB' performance counter could not be found.  System error - Server stack trace:  

I checked the PerfMon and found that the MSOLAP counters were missing.

I tried the load the counters given in this link. But I got an error saying that the counters are already present. After lot of digging and discussion with Microsoft found that I need to set the following in the registry. For 64 bit Go to->  HKLM \ System \ CurrentControlSet \ Services\MSOLAP$POWERPIVOT\ Performance and set Disable Performance Counters = 2 .

For 32 bit installations set it to 0.

Restart the server that hosts the power-pivot and you should be able to see the  MSOLAP performance counters in PerfMon and PowerPivot data refresh should work.

In the first instance I do not know how the performance counters were disabled. Can anyone throw light on this?

Saturday, July 19, 2014

PDF will not open in client application in SharePoint 2010

My users preference is not to save the PDF's when they try to open it from a SharePoint Document Library.


My preference is, they should be able to open the PDF in PDF Viewer like word/excel client applications. We thought it is browser specific problem, and tested it in IE, Chrome and Firefox. IE requests the user to save the PDF document as given in the above picture and Chrome downloads the PDF's automatically.
So we concluded that this is not a browser issue and found the following solution.

The solution is to

  1. SharePoint 2010 Central Administration -> Application Management -> Manage Web Applications
  2. Select the choice of your web application
  3. Click General Settings in the ribbon
  4. Scroll down to Browser File Handling and choose Permissive
  5. Click OK to save the settings.


Also I checked the settings of "Opening Documents in the Browser " of user's document library is set to "open in client application". Now the users are able to open the PDF's in client application. Hope this helps you.

Thursday, July 17, 2014

How to change default open behavior for documents in a document library

One of my user asked me to find a way to set  the default open behavior for  documents in a document library as "Open in client application". He has many document libraries in his site.


I requested him to activate the site collection feature "Open Documents in Client Applications by Default" which will change the default open behavior for all the document libraries(Documents, Form Templates, Site Pages, Style Library etc) but not for Customized Reports document library.

Once he activated that feature, the default open behavior has been set to "Open in client application".
Can anyone tell me why the site collection feature "Open Documents in Client Applications by Default" did not change the default open behavior setting for Customized Reports document library?

Create a site collection which is already present in a web application

I wanted to check how SharePoint behaves, when we try to create a site collection with a title which is already present in the same web application.

SharePoint OOTB it prevents it by throwing a message "Another site already exists".

Saturday, July 12, 2014

Word WebApp encountered an unexpected error /Excel WebApp unable to process the request

In one of my newly created web application, the users tried to open Excel/Word documents using browsers. They were getting the following error and I had to investigate.




 I checked all the services on the WFE and Word viewer service, Excel calculation service were running. When i checked the event viewer for errors, I found the following in event viewer, which ringed the bell


Then I checked the Central Admin->Application Management-> Select the web application -> Service connections -> Configure service application associations and found that Excel Service and Word viewing service is not configured for this web application. When I enabled those for this application, users were able to view Excel/Word using browser. Hope this helps for you!!!

Friday, July 11, 2014

MyContent Link is missing/not visible in My Site

One of my user reported that he is not able to see the My Content link in his MySite.


All my users were able to see My Content link , but this user was not. Out of curiosity I checked the following

1) Central Admin -> Application management -> My site web application -> Self service site creation - It was enabled.
2) Central Administration->Application management -> Select User Profile Service ->MySite Settings-> All the configurations (My Site Host, Personal Site Location, Site Naming Format, Read Permission Level, Security Trimming Options etc) are correct.
3) Central Administration->Application management -> Select User Profile Service ->People->Manage User Permissions -> Added the user -> Enabled permissions for User personal features, Create personal site, Use social features. Now the user was able to see the My Content link and clicking on it created his personal site.

In my organisation , instead of enabling "User personal features, Create personal site, Use social features" for employees individually we created an AD group and enabled aforementioned permissions to that AD group. Finally I added the user who reported this error into that AD group which solved the problem.

Hope this helps for you as well!!!




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
$farm.XSLTTransformTimeout

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

$farm = Get-SPFarm
$farm.XSLTTransformTimeout =5
$farm.Update()

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 "http://ABC.com/sites/XYZ"
$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


.