SharePoint mysite is deleted
February 26, 2010 Leave a comment
Issue:
The My Site of Joe Blow is scheduled for deletion. As their manager you are now the temporary owner of their site. This temporary ownership gives you access to the site to copy any business-related information you might need. To access the site use this URL: http://servername/mysite/personal/joeblow.
Cause:
In SharePoint under Central Administration there is a ‘My Site Cleanup Job’ which runs every hour. When a user is deleted or disable in Active Directory, the My Site Cleanup job starts a workflow on that user’s My Site. The default behaviour is to send an e-mail message to the manager with a link to the deleted user’s site. The e-mail message contains a request to the manager to move any documents or data that the manager wants to preserve, because the site might be deleted in the future.
MySite clean up job screen
There is also ‘site use confirmation and deletion’ page under central administration operations which may be checked.
Site use confirmation deletion screen
Solution:
To mitigate this issue I think you can apply any of the following steps.
1. If you have two domain controllers use the domain name and ‘Auto discover domain controller’ option. If the one domain controller goes down SharePoint will look for the other domain controller. Please look at my aricle on ‘Employee Lookup or User Profile searches in SharePoint 2007‘ to find a filter for not importing disable Active Directory accounts.
AD connection auto discovery screen
2. In central administration we can disable ‘My Site Cleanup Job’ and run once a week manually to do cleanup. Not a great options.
3. Potentially you can also call the SharePoint profile stored procedure manually. If you do this you may want to disable ‘My Site Cleanup Job’.
DECLARE @UserID uniqueidentifier DECLARE @NTName nvarchar(400) DECLARE @SID varbinary(512) DECLARE userCursor CURSOR FOR SELECT Userid, NTName, SID from userprofile _full where bdeleted = 1 OPEN userCursor FETCH NEXT FROM userCursor INTO @UserID, @NTName, @SID WHILE @@FETCH_STATUS = 0 BEGIN EXEC profile_RemoveUser @UserID, @NTName, @SID FETCH NEXT FROM userCursor INTO @UserID, @NTName, @SID END CLOSE userCursor DEALLOCATE userCursor
References:
