Missing Stored Procedure - dbo.profilesynch_sweep_GetDBToken
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?
- Moved byMike Walsh MVPMVP, ModeratorFriday, June 26, 2009 5:04 PMMySite q (From:SharePoint - Setup, Upgrade, Administration and Operation)
Answers
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 EngineerHow 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.- Marked As Answer byLambert QinMSFT, ModeratorFriday, July 03, 2009 6:33 AM
All Replies
- 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 - 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 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 EngineerHow 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.- Marked As Answer byLambert QinMSFT, ModeratorFriday, July 03, 2009 6:33 AM
