SharePoint Sync Job Failure

Recently I noticed on a situation where the sync jobs were failing on a MOSS implementation. Everything else was working great except for the features that surface the “Sites that you are a member of” and “My SharePoint Sites” in office. Looking into the ULS logs I found:

SharePoint Portal Server
User Profiles
Aborting sweepsynch for guid instance due to null or non-online content database

Turns out that the content database had been set to “Offline” to prevent the creation of new sites. Changing the content database to “Ready” status and setting the site limit to the current number of sites solved the problem and now new site memberships are working correctly.

FYI, You may also need to manually delete the old sync databases with “stsadm -o sync -deleteolddatabases 0” but be sure to read these two excellent posts first.

Andrew Woodward:

Paul Liebrand:

|| Administration

comments powered by Disqus

Let's Get In Touch!

Ready to start your next project with us? That’s great! Give us a call or send us an email and we will get back to you as soon as possible!