SharePoint

SharePoint 2010 Social Collaboration Web Parts Missing

Today one of our SharePoint guys messaged me over Lync with a need to setup social web parts in SharePoint. What he noticed was that he was looking for the note board, organization browser, tag cloud , etc. It seems that somewhere in the past this feature was lost. Possibly during the SharePoint upgrade from 2007 to 2010.

To sum this up a bit. After a database attach upgrade of a site collection/content database from SharePoint 2007 to 2010, some of the web parts that you might expect to become available were not.

To fix this we used powershell and did the following:

Disable-SPFeature –Identity PortalLayouts –url http://corp.sharepoint.local

Enable-SPFeature PortalLayouts -Url http://corp.sharepoint.local

The issued was resolved

– jermal

 

SharePoint Server 2010 Windows PowerShell cmdlets

For those looking for essential resources when upgrading from MOSS 2007 to SharePoint Server 2010, I have found some of these very useful

Index of SharePoint Server 2010 Windows PowerShell cmdlets
http://technet.microsoft.com/en-us/library/ff678226(office.14).aspx

Avoid the Warning from Excel Services About Refreshing External Data

If you leave this value set to the default (i.e. Yes), then you’ll be greeted with the following message for each Excel Web Part on a TFS dashboard page:

This workbook contains one or more queries that refresh external data. A malicious user can design a query to access confidential information and distribute it to other users or perform other harmful actions.

If you trust the source of this workbook, click Yes to enable queries to external data in this workbook. If you are not sure, click No so that changes are not applied to your workbook.

Do you want to enable queries to external data in this workbook?

To avoid warnings before refreshing external data in Excel Services:

  1. On the SharePoint Central Administration home page, in the Application Management section, click Manage service applications.
  2. On the Service Applications page, click Excel Services Application.
  3. On the Manage Excel Services Application page, click Trusted File Locations.
  4. On the Excel Services Application Trusted File Locations page, point to the trusted file location that you want to edit (e.g. http://), click the arrow that appears, and then click Edit.
  5. On the Excel Services Application Edit Trusted File Location page, in the External Data section, clear the Refresh warning enabled checkbox, and then click OK.
Manage Excel Services trusted file locations

SharePoint 2010 Cumulative Update = Fail

Today I took on the fun task of updating a SharePoint 2010 Server to server Pack 1 followed by cumulative updates.  Everything seemed to go well up until running the Configuration wizard which bombs at the end.    Now the CU update documentation says ‘nothing’ about rebooting the machine.   In the update logs there is an error about the timer job failing.

ERR:  The exclusive inplace upgrader timer job failed.

I then attempted to restart the timer job and run this again – failed (same error) |Bullshit I think.
So after much to do, I decide to reboot the SharePoint server and attempt to run it again.  And guess what!  It worked.   From what I have read in my quick searching on Google for a solution to this is that  User Account control is the cause of this issue.

So in order to get your CU (or other updates for that matter) for SharePoint 2010 to install correctly I recommend you to disable the User Account Control for you service accounts.

Oh well all is working and 4 hours of work my company owes me for this bloodletting event.