Sunday, 4 December 2011

Profile Synchronisation Jobs not updating user details in Sharepoint 2007 sites


I have seen that many site admins periodically reports the issue of Profile Synchronisation jobs not updating the details of their users in the sharepoint site. In all the cases people have reported that the user details were updated in AD and the details were updated in SSP as well after profile import. However the same was not updated in site.
So I am mentioning some points here about this issue:

1. The profile synchronisation jobs responsible for updating these details from SSP to sites only updates details for the active users.
2. The active users are considered as the users who have carried out any change in the site ever in any form of add, update or delete.
3. The active users are marked at the database level. In the content database there is a table UserInfo used to store details of all site users.
4. In this table there is a column named as "tp_IsActive". This column is a type of bit column and will carry the values 0 or 1. the value 1 stands for an active user and 0 for an inactive user.  Refer this:

Now to get this to work following steps can be taken:

1. Ask the user to carry out any changes in the site collection.
2. Try resolving his correct name by adding him to any any user group.
3. If the first way is not feasible because of your security policies and second is not working out to you then delete the user from site collection and add him once again.

I hope this will help you out.

Rahul Rashu

No comments:

Post a Comment