Tuesday, September 4, 2012

FAST Down Due to SharePoint Security Token Service Certificate Errors

Good Morning SharePoint!  Walking in the door with a fire to put out is better than coffee.

When browsing to a search page we were getting the following error.

clip_image001

Source: SharePoint Foundation

Event ID: 8311

An operation failed because the following certificate has validation errors:\n\nSubject Name: CN=SharePoint Security Token Service, OU=SharePoint, O=Microsoft, C=US\nIssuer Name: CN=SharePoint Root Authority, OU=SharePoint, O=Microsoft, C=US\nThumbprint: 9057913C61BA802F52787B75CFBE3BFAD0104E43\n\nErrors:\n\n The root of the certificate chain is not a trusted root authority..

A quick search lead me to the following KB article.

How to re-create the local Trusted Root Authority

This article states that an administrator deleted the local trust in CA. But I check and it is there.  I didn’t delete it and no one else has access.

clip_image002

I ran the following command from the article, which added a new local trust relationship.

$rootCert = (Get-SPCertificateAuthority).RootCertificate
New-SPTrustedRootAuthority -Name "localNew" -Certificate $rootCert

clip_image003

I still do not know what caused this to happen.  Will have to look into it later.

Thursday, August 30, 2012

Unexpected error occurred while communicating with Administration Service – When Adding Managed Property

clip_image002

When this error first popped up I thought I was going to have one of those long days troubleshooting SharePoint's guts. 

Looking at the log I found out the managed property I was trying to create already existed. 

Update ManageProperty failed Microsoft.SharePoint.Search.Extended.Administration.Common.AdminException: The  managed property  'Location' already exists.

Cmon Microsoft.  This message is a bit misleading.

Monday, August 13, 2012

Installing Visual Studio 2012 RC on Windows 8 RP Running on ThinkPad T510 (4349)

When trying to install Visual Studio the splash screen for the installer would come up with a black screen and never go away.  I gave up trying to get this to work.  Came back to it this weekend and saw Lenovo released another video driver for Windows 8 on August 9.  Installed the new driver, rebooted and Visual Studio installed with no issues.  FINALLY!

http://support.lenovo.com/en_US/downloads/detail.page?DocID=HT072084

Monday, June 4, 2012

Blogging

I’ve tried to blog for years.  As you can see it is not going well.  I have 100s of drafts and I think 1 published page.  With 4 kids, a wife, a challenging job and a house that is falling apart I just don’t have the time.  I still plan to write some articles but they will be short and sweet.  More like writing notes for myself instead of trying to create the perfect article.

Wednesday, February 16, 2011

SharePoint 2010 Picture Libraries and the Datasheet View

Picture Libraries in SharePoint 2010 appear to support the Datasheet view but it is not available as an option through the UI.

Warning: As always use this method at your own risk.  I have tested it and so far it works fine.  If you run into an issue using this method please leave a comment so that I can update this post.

Brief How To

  1. Go to a document library and open a datasheet view. 
  2. Replace the view URL and the View GUID with a URL and GUID of your picture library 

Detailed How To

image

Go to a regular document library in the same site as your picture library and open the datasheet view.  Copy the URL.  It will look something like this:

hxxp://a.b.com/tests/picgridtest/Shared%20Documents/Forms/AllItems.aspx?ShowInGrid=True&View=%7B4789A2DC%2D357E%2D4046%2D8E0E%2DF84294697D9E%7D&InitialTabId=Ribbon%2ELibrary&VisibilityContext=WSSTabPersistence

The highlighted areas need to be changed to work with your picture library.  The first area needs to be changed to your picture library and the correct view.  The View GUID needs to be changed to the GUID of the picture library view you are going to use.  Note in this example I am going to use the default allitems view.  It may work better for you to create a view just for this purpose because some columns in the allitems view are read-only. 

Go back to your picture library and browse to the view you would like to use.  Copy this URL and paste it into your favorite text editor.

hxxp://a.b.com/tests/picgridtest/Picture%20Grid%20View/Forms/AllItems.aspx

This is the first portion of our new URL. 

Next click modify this view.

image

After the Edit View page loads copy the view GUID out of the URL.  My view URL is below and I copied out the highlighted text.

hxxp://a.b.com/tests/picgridtest/_layouts/ViewEdit.aspx?List=%7B1A5C6954%2DA6CF%2D4EA3%2D815C%2D9CD20B25FABC%7D&View=%7B8AE2BF13%2D0CE3%2D44CF%2DA639%2D16FBF281201B%7D&Source=http%253A%252F%252Fintranet%252Edemo%252Ecom%252Ftests%252Fpicgridtest%252F%255Flayouts%252Fvsmenu%252Easpx%253FList%253D%257B1a5c6954%252Da6cf%252D4ea3%252D815c%252D9cd20b25fabc%257D%2526View%253D%257B8ae2bf13%252D0ce3%252D44cf%252Da639%252D16fbf281201b%257D%2526Source%253Dhttp%253A%252F%252Fintranet%252Edemo%252Ecom%252Ftests%252Fpicgridtest%252FPicture%25252520Grid%25252520View%252FForms%252FAllItems%252Easpx%2526

The highlighted portion of the URL above is the second part of our URL that needs to be changed.

Now we have the two parts we need and we can build the final URL. The following format and text will be used.  Just paste in the text copied out previously into the highlighted areas of the formula.

Formula: [1 View URL]?ShowInGrid=True&View=[2 View GUID]&InitialTabId=Ribbon%2ELibrary&VisibilityContext=WSSTabPersistence

Part 1: hxxp://a.b.com/tests/picgridtest/Picture%20Grid%20View/Forms/AllItems.aspx

Part 2: %7B8AE2BF13%2D0CE3%2D44CF%2DA639%2D16FBF281201B%7D

The final URL will look something like this:

hxxp://a.b.com/tests/picgridtest/Picture%20Grid%20View/Forms/AllItems.aspx?ShowInGrid=True&View=%7B8AE2BF13%2D0CE3%2D44CF%2DA639%2D16FBF281201B%7D&InitialTabId=Ribbon%2ELibrary&VisibilityContext=WSSTabPersistence

Paste this into your browser and you should be good to go.

image

Notes

  • Tested in SharePoint 2010, 14.0.5123.5000
  • I was not able to get this to work in SharePoint 2007
  • This is also possible using an Access view but I ran into many issues trying to copy data from one view to another and still could not drag and copy cells.