Saturday, July 26, 2014

SharePoint 2010: Users picture from Mysite are not reflecting in All People group.

Issue: We have some users reporting that their picture is displaying on the mysite but not displaying on SharePoint groups when added.

Error: There was no error as such, however in SharePoint group user picture is not showing as it was showing in the Mysite. 


Have checked the user Pictures and they seem to be fine on users’ mysites

Added my id in the group and my picture does display in 5 min.

There is no issue with the file type and the image size on the mysite.

It’s just not working for those few users.

Changed my picture on the mysite and re-added the id in the group to check if Profile sync timer job has any issue but it did worked fine.

There were no issues with the Profile synchronization and Quick synchronization timer job definitions.


Searched on internet and found a blog, which gave me clue for further investigation.

Why do some Team Sites not update with my details

The main reason for confusion around the updating (sync’ing) of My Profile details into team sites is that it is now based on if the user is Active. As part of the upgrade to V3 Microsoft introduced the idea of users being active in a site rather than just having access.

When you first visit a site a record is recorded in the UserInfo table of the sites Content Database. The field tp_IsActive is defaulted to false, which means you have visited but have not interacted with the site.

The Sync process uses this value to determine if the user info should be replicated from the My Profile details as edited above. 

Following on from the example above you should be able to refresh your team site that you had only visited and see the user name is still the same, it was not updated when the My Site was updated.

How to check if user active in SQL Database:

Go to Start -> Programs -> Microsoft SQL Server 2005/2008/2012 -> Click SQL Server Management Studio.
Connect to the SQL Server instance using the correct User ID and Password.

Note: If you are connecting SQL Server form your client then you may need to connect to SQL Server with special account with the correct permissions on the SQL Server. Run the SQL MS with Run as option in that case.

Expand Databases -> Choose to expand the DB in which your Site collection resides.
Expand Tables in that Database -> Right click on dbo.userinfo table. 

In the new Query editor, write the query:

FROM [Database name].[dbo].[UserInfo]
where tp_login like 'User ID’

After running the above query, it will display all the result of the sites on which that user is having the permissions.
You need to find the site against its ID, you can find the site ID using the PS commands.

PS > $mysite = Get-SPSite 
PS > $

Next steps would be to check if the user is active on the site or not.

You need to find form the result of query the value of the field tp_IsActive is 0, which means users had visited the site in the past but had not interacted with the site much else this value had to be 1.

Steps suggested to user:

Asked user to update their new picture on the mysite. Deleted them from the All Peoples group from the site and Re-added them. After waiting sometime it worked for the user i.e. their pictures were displaying in the SharePoint groups.

If you had any issues executing the above steps do let me know.

Applies to:
  • SharePoint Server 2010,
  • SharePoint Server 2013. 

Thursday, July 24, 2014

Host Named Site collections: SharePoint 2013

I was working on one of the requirement we have taken to set-up SharePoint 2013 from their existing SharePoint 2010 environment.

While working with client he was saying that they need to bind the all the site collections in there and environment to a single web app in SharePoint 2013 set-up and was mentioning about the Host Names site collections.

I have never heard of this term before.

This is a not a new addition to the SharePoint 2013 family but I was surprised to know that it was there in SharePoint 2010 and I didn't not about it. It is preferable method to use in the host the site collection with different URLs on o Web application. 

MS claims that this is the most preferable way to host your site as Office 365 used this method to support multiple clients.  

I read about this in detail on TechNet Site.

There are different opinions of the different experts with this approach such as some organisation doesn't want to use it because security reasons and some prefer it based on the small scale of your environment.

However, my buy on this is basically a mix of both and I would suggest leave it on customer discretion to how they wanted to have their environment set-up.

Please Share your experiences and thoughts in the comment section to this article.

Applies to: SharePoint 2010, SharePoint 2013.


snow flakes

blogger widgets Blogspot Tutorial


Related Posts Plugin for WordPress, Blogger...