Missing Stored Procedure - dbo.profilesynch_sweep_GetDBToken

Fri, 26 Jun 2009 16:53:19 Z

My SharePoint site began experiencing strange behavior in that we can no longer access our My Site pages. When we try it returns the error "An error was encountered while retrieving the user profile." When I look at the server event log I see the following error, Event ID: 5554, Description: Failure during sweep synch. Exception was Cound not find stored procedure 'dbo.profilesynch_sweep_GetDBToken.' Does anyone have a fix for this?

Missing Stored Procedure - dbo.profilesynch_sweep_GetDBToken

Fri, 26 Jun 2009 17:04:18 Z

Moving to Social Computing as this is a MySite question

WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx

Missing Stored Procedure - dbo.profilesynch_sweep_GetDBToken

Fri, 26 Jun 2009 19:27:09 Z

First thing I would do is dig into the ULS Logs. The default location is normally c:\program files\common files\microsoft shared\web server extensions\12\logs

If there isn't good info, you can try tweaking some of the diagnostic logging levels in the Central Administration \ Operations section.

Many of the stored procedure errors I've had have been db permissions related. Were any changes made recently to the app pools or service accounts and their access to the database server?

SharePoint Developer | Administrator | Evangelist -- Twitter -- Blog - http://nextconnect.blogspot.com

Missing Stored Procedure - dbo.profilesynch_sweep_GetDBToken

Mon, 29 Jun 2009 03:35:22 Z

The issue could be caused by the exceptions of sync process

You could try the following steps to resolve the issue:

1. Undoes the last preparetomove operation if you tried to move the site or content database.

stsadm -o preparetomove

-contentdb <server name: database name>

-undo

See Preparetomove: Stsadm operation (Office SharePoint Server) (http://technet.microsoft.com/en-us/library/cc262122.aspx) for more information.

2. Clear the profile sync information to allow SharePoint to repopulate the profile sync.

stsadm -o sync

-deleteolddatabases 0

See Sync: Stsadm operation (Office SharePoint Server) (http://technet.microsoft.com/en-us/library/cc263196.aspx) for more information.

3. Wait a hour for the timer job to complete.

Hope the information can be helpful.

-lambert

Lambert Qin | Microsoft Online Support Engineer

How to ask a question in the forum (http://support.microsoft.com/kb/555375)

Posting is provided "AS IS" with no warranties, and confers no rights.