Sunday, May 1, 2011

MOSS 2007 User Profile AD Sync Issue

Background:
  • User Profile Import Schedule was not running as per configured Schedules
  • We have to manually run the Incremental crawl which pulled the users from different ADs.
  • Profile Synchronization, Quick Profile Synchronization Jobs were running successfully.
  • There were totally 90000 profiles, pulled from different domains.
Problem:
  • Imported User profile details (changes) were not getting published to the web applications.
  • We were able to see the changes in SSP database in “UserProfileValue“table.
  • On the other hand when we removed the user from site and added him back the changes are reflected in the web application.
Resolution:
Ran following commands to get rid of this issue
stsadm -o sync -listolddatabases
Resulted in number of GUIDs, so ran following command to delete those GUIDs
stsadm -o sync -deleteolddatabases
And then
stsadm -o sync
To check connection between AD and MOSS ran following command
stsadm -o getproperty -propertyname peoplepicker-searchadforests
If its resulted in NO, then we have to set connection between AD and MOSS using following command
stsadm –o setproperty –pn peoplepicker-searchadforests –pv

After that rechecked behavior using stsadm -o sync -listolddatabases and did not get any GUIDs and after that ran Full import which resolved the issues.
Please let me know in case of any questions.

No comments: