Posted by: Diganta Kumar | February 26, 2010

SharePoint mysite is deleted

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

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

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

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:

SharePoint profile stored procedure article

SharePoint Profile Cleanup

White paper on mysite

How To Delete Sharepoint Timer Job Definition

Posted by: Diganta Kumar | February 26, 2010

Project is Locked/ Project in unviewable – Word 2003 macro

Issue:
When try to modify word macro I get “Project is Locked/ Project in unviewable”

Solution:
1. Find the location on the startup folder. Go to Tools > Options > File Locations. See the UNC path of the startup ‘File types’.
2. Open explorer and go the the startup loaction.
3. Move the template.dot file, where you have the macro from the startup folder to any other location.
4. Now open template.dot file and modify the macro, test and then put it back to the startup folder.
5. Open word and you will be able to see the changes.

Visual Studio error:

Error connecting to undo manager of source file ‘C:\Documents and Settings\kumard\My Documents\Visual Studio 2008\Projects\LANSW.Survey\Survey\Default.aspx.designer.cs‘.

Solution:

In the solution explorer find the ‘Default.aspx.designer.cs’ and do the following:

a. Remove Default.aspx.designer.cs

b. Right click on Default.aspx and Convert to Web Application

c. Build your project or solution

d. Run it and it works.

Resources

http://forums.asp.net/t/1100585.aspx

Older Posts »

Categories