Some days ago, I posted a post abot sync the User profile with the SSP database. This method I mentioned can work in some situation. But, this time, it can work for use.
The SSP maintains a user profile database which import user profile from AD. But , every site collection maintains an userinfo list themselves, which record user’s information when user visit the site collection first time.
Now, if a employee, whose display name is AAA, left the company. After a full import from SSP, the display name should becomezzDelete2009/08/25_AAA. If you view the employee’s information from the SSP, you would find that his display name is changed. But, every site collection does not sync the information with the SSP. For example, some items’ Created By column are still AAA, not zzDelete2009/08/25_AAA.I follow some instructions below:
1. Make sure the content database is online.
2. stsadm –o sync –deleteolddatabases 0
3. stsadm –o sync
4. stsadm –o execadmsvcjobs
These commands work for some site collections. For some other site collections, the display name is still AAA.
Then we find there is a table named SiteSynch in the SSP database. Those site collections in which the display name has been changed has a record in this table. Some content database do not have record in this table.
We also try to delete the employee information from the userinfo list and the site collection’s content database, but it doesn’t work.
Then we have another solution:
Delete the site collection and ContentDB from the central administrator and SQL Server.
Create a new Database and site collection.
Restore the site collection.
stsadm -o sync -deleteolddatabases 0
Then waiting...waiting...waiting...then works
Subscribe to:
Post Comments (Atom)
Try this:
ReplyDeleteDownload SharePoint Manager 2007.
Click around and find your site collection and click on it. The right hand side will give lots of information. Make note of the ID. That is what we are after.
Open Microsoft SQL Server Management Studio Express. Open The Shared Services Database. Mine was called SharedServices1_DB. Find the table called dbo.SiteSych. Right click on it and choose Open Table. Locate your SiteID in the SiteID column. This is the ID you found by using SharePoint Manager 2007. Find the moving column. Does it say True? If so, change it to False and click out of that record to save it. Run stsadm –o sync. For those that get errors running that command, do not copy and paste it; type it manually.
Check your profiles and see if they are synched. Mine were!
Hi Mike
ReplyDeleteThank you very much for your suggestion! I will try your method when I meet this problem again, because I have not meet this problem again since last time.
Best Regards,