Sunday, May 1, 2011

MOSS 2007 User Profile AD Sync Issue

  • 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.
  • 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.
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: