SharePoint 2013 ::: How to restore the deleted "Suggested sites to follow" Web Part from a user's MySite

Hi all,

Today’s challenge is to restore the Web Part “Suggested sites to follow” that was deleted by the user himself.

So, do not lose your time in trying to find the Web Part in the Add Web Part page of the mySite, it is not available.

After googleling, I found this link to a Microsoft article to remove the concerned Web Part using PowerShell.

The script, provided by Microsoft, that put me on the track is:

Add-PsSnapin Microsoft.SharePoint.PowerShell

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.WebPartPages")

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Publishing")

$useraccount = "useraccount"

$url = "http://" + [System.Net.Dns]::GetHostName() + "/my/personal/" + $useraccount

$site = get-spsite $url

$web = $site.RootWeb

$pageUrl= "Social/Sites.aspx"

$webPartManager =  $web.GetLimitedWebPartManager($pageUrl, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared);

$webPart = $webPartManager.WebParts | where-object { $_.WebBrowsableObject.GetType().Name -eq "ProjectSearchBrowseWebpart" }

if($webPart -ne $null)

{

    $webPartManager.DeleteWebPart($webPart)

}

$web.Update();

In the script, I found the name of the Web Part "ProjectSearchBrowseWebpart", and the page to find it.

Then, I decided to compare the code of both pages “Social/Sites.aspx” from my mySite and from the user’s mySite, using SharePoint Designer 2013.

I found then the difference at the end of the code:

Hereunder is the code from my mySite, and in yellow, the missing code in the user’s mySite code:

            <div class="ms-contentFollowing-sitesRightZone ms-tableCell ms-verticalAlignTop">

                <div class="ms-contentFollowing-bottomZoneContainer">

                    <WebPartPages:WebPartZone runat="server" FrameType="None" ID="RightZone" Title="<%$Resources:sps,LayoutPageZone_RightZone%>" Orientation="Vertical"><ZoneTemplate>

                                                                           <SPSWC:ProjectSearchBrowseWebpart runat="server" CategoryString="Site" AllowEdit="False" ChromeType="TitleOnly" Description="The recommendations web part suggests content a user may wish to follow within a farm." Title="Suggested sites to follow" ID="projectSearchBrowseWebPart" __MarkupType="vsattributemarkup" __WebPartId="{344EF58F-509A-3DE1-T3DG-ID0T674FOR6Z}" WebPart="true" __designer:IsClosed="false" partorder="2"></SPSWC:ProjectSearchBrowseWebpart>

                                                                           </ZoneTemplate></WebPartPages:WebPartZone>

                </div>

            </div>

        </div>

    </div>

</asp:Content>

So, I simply made a copy/paste of the missing line, save the user’s “Social/Sites.aspx” page, and made a refresh of his mySite in the browser.

 ==>Problem solved.

---

Voilà,

That’s all Folks !!!

Diagnose and Clean MissingWebPart and MissingAssembly issues

Hi all,

Today I found useful cmdlets to diagnose and clear those errors in the Content DB of my SharePoint 2010 Farm.

How to:

Step 1:

 - Test-SPContentDatabase -name <ContentDB_Name> -webapplication <Web App URL>

Step 2:

 - Select the WebPart Class GUID

Step 3:

 - Run this command with the related WebPart Class GUID:

Run-SQLQuery -SqlServer "SRV_DATABASE" -SqlDatabase "SharePoint_Content_sharepoint_db_name" -SqlQuery "SELECT * from AllDocs inner join AllWebParts on AllDocs.Id = AllWebParts.tp_PageUrlID where AllWebParts.tp_WebPartTypeID = '9812863c-ee62-dab6-57f5-79e9d4d36022'" | select Id, SiteId, DirName, LeafName, WebId, ListId, tp_ZoneID, tp_DisplayName | Format-List

Step 4:

 - The result will give the below info:

Id                            : a5da7b36-083f-4d07-b50b-8f1fc8d7bbe9

SiteId                      : 53061278-8b1d-4d6d-9dce-8568f90c5574

DirName                 : Sites/blahblasite/Sandbox/TestWSServiceLevelDashboard

LeafName               : default.aspx

WebId                     : 2ab691b1-0d74-4bf2-9524-c6b1d969cfac

ListId                      :

tp_ZoneID              : Left

tp_DisplayName     :

 - The URL to use is:                http://shareppoint.contoso.com/Sites/blahblahsite/Sandbox/TestWSServiceLevelDashboard/default.aspx?contents=1

 - So, here are the steps that I follow to remove the “ErrorWebPart”:

     1- select the Error rows

     2- click on “Close” to set them as “No” for the “Open on Page?” column

     3- select the same Error rows then Delete them

Step 5:

 - Execute again the “Test-SPContentDatabase” to check that all entries for the MissingWebPart are gone.

Thanks all folks

MissingWebPart Error in SharePoint 2010

Hi all,

Today I found useful cmdlets to diagnose and clear those errors in the Content DB of my SharePoint 2010 Farm.

How to proceed:

Step 1: Inspect the DB

-          Test-SPContentDatabase -name <ContentDB_Name> -webapplication <Web App URL>

Step 2:

-          Select the WebPart Class GUID

Step 3:
           -     Create the SQL Function and execute it into PowerShell:

function Run-SQLQuery ($SqlServer, $SqlDatabase, $SqlQuery)
{
    $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
    $SqlConnection.ConnectionString = "Server =" + $SqlServer + "; Database =" + $SqlDatabase + "; Integrated Security = True"
    $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
    $SqlCmd.CommandText = $SqlQuery
    $SqlCmd.Connection = $SqlConnection
    $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
    $SqlAdapter.SelectCommand = $SqlCmd
    $DataSet = New-Object System.Data.DataSet
    $SqlAdapter.Fill($DataSet)
    $SqlConnection.Close()
    $DataSet.Tables[0]

}

-          Run this command with the related WebPart Class GUID:

Run-SQLQuery -SqlServer "SRV_DATABASE" -SqlDatabase "SharePoint_Content_sharepointWorkgroup17" -SqlQuery "SELECT * from AllDocs inner join AllWebParts on AllDocs.Id = AllWebParts.tp_PageUrlID where AllWebParts.tp_WebPartTypeID = '9812863c-ee62-dab6-57f5-79e9d4d36022'" | select Id, SiteId, DirName, LeafName, WebId, ListId, tp_ZoneID, tp_DisplayName | Format-List

Step 4:

-          The result will give the below info, with the URL where the Missing Web Part is located:

Id                         : a5da7b36-083f-4d07-b50b-8f1fc8d7bbe9

SiteId                   : 53061278-8b1d-4d6d-9dce-8568f90c5574

DirName              : Sites/WW12000012/Sandbox/TestWSServiceLevelDashboard

LeafName            : default.aspx

WebId                 : 2ab691b1-0d74-4bf2-9524-c6b1d969cfac

ListId                   :

tp_ZoneID           : Left

tp_DisplayName  :

-          The URL to use is:        http://sharepoint.contoso.com/Sites/WW12000012/Sandbox/TestWSServiceLevelDashboard/default.aspx?contents=1

                  Adding at the end of the URL "?contents=1" will let SharePoint to show the "Web Part Page"

-          So, here are the steps that I follow to remove the “ErrorWebPart”:

1- select the Error rows

2- click on “Close” to set them as “No” for the “Open on Page?” column

3- select the same Error rows then Delete them

Step 5:

-          Execute again the “Test-SPContentDatabase” to check that all entries for the MissingWebPart are gone.

That's all folks