SharePoint 2007: Profile Synchronisation Jobs not Updating User Details

SharePoint 2007: Profile Synchronisation Jobs not Updating User Details

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: http://msdn.microsoft.com/en-us/library/c6244ace-4199-450d-a215-d37fa591159d(v=PROT.13)#active_user

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 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.
Leave a Comment
  • Please add 3 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Richard Mueller edited Revision 3. Comment: Modified title casing

  • Patris_70 edited Revision 2. Comment: deleted (en-US) title

  • Arun Kumar Arora edited Revision 1. Comment: Corrected typo mistakes

  • Craig Lussier edited Original. Comment: added en-US to tags and title

Page 1 of 1 (4 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Craig Lussier edited Original. Comment: added en-US to tags and title

  • Arun Kumar Arora edited Revision 1. Comment: Corrected typo mistakes

  • Patris_70 edited Revision 2. Comment: deleted (en-US) title

  • Richard Mueller edited Revision 3. Comment: Modified title casing

Page 1 of 1 (4 items)