MOSS 2007 User Profile AD Sync Issue

MOSS 2007 User Profile AD Sync Issue

I face the issue When working on User Profile Sync, Resolved the issue By performing the below steps. so Thought to Share.

       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 

      I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.