All posts tagged SharePoint 2013

SharePoint Patch Process Fails: System.Data.SqlClient.SqlException – Invalid object name ‘Webs’

I have been working with SharePoint for a long time.  An error was encountered not long ago that I have never seen when patching a SharePoint server (and unfortunately I have seen a lot of errors over the years).  While running the configuration manager I received the following error:

“An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Invalid object name ‘Webs’.”

The error of course was really nice and pointed me to the log file to get more information.  Opening up the log file and searching for ERR (put space at the end to have a better chance of finding an error entry instead of other words containing those letters) I was expecting loads of information to be made available to me so I could easily fix this problem.  I really should have known better as I received the following:

Invalid object name 'Webs' - Log Error Message

At no point in the logs did it tell me where this problem was occurring.  So where do we go from here?

Well let’s dig into it shall we?

Read more

SharePoint Best Practices – Content Types

The other day I decided to start a power user best practice series.  I started with site columns and now the next logical step is content types.  I have found that many times experienced users don’t realise the importance of a properly setup content type.  Because of this, they often are recreating the same data, having to redo the content types  and in some cases blow them away and start over (both of which are a real pain if the CT is already being used).  The intent of this post is to cover the best ways to create your content types.

Read more

SharePoint Best Practices – Site Columns

So today I am starting a new series on SharePoint Best Practices.  This may seem like a fairly simple topic but, I have come to learn that it is an important one.  I am not talking about best practices in setting up and configuring SharePoint or how to best develop a solution in SharePoint.  I am instead wanting to discuss best practices in your day to day usage of SharePoint.  Too many times I have worked with experienced clients that have a decent knowledge of how to do things in SharePoint, but don’t think of the little things that make these best practices.  This is where this series is coming from.  Today I am going to cover site columns.

Read more

Manipulating REST API Calls in SharePoint Designer 2013 Workflows

In my previous post on the different ways to determine the return message from a REST API call in a SPD workflow I covered using a test list and Fiddler to build your web call in a SharePoint Designer workflow.  In this post I want to discuss manipulating REST API calls in SharePoint Designer 2013 workflows.  Basically I want to show how you can determine what your read string is going to look like based on the values coming back from SharePoint.

Read more

Handling REST Responses in SharePoint Designer Workflows – Reading The Response

Years ago when Microsoft released it’s latest version of SharePoint Designer, it came with a few enhancements that really made building workflows with Designer more robust and efficient.  One efficiency enhancement was the ability to copy actions, steps and even entire stages within the same workflow or even between workflows.  Microsoft also allowed for the ability to move back and forth between stages instead of continuing down a parallel path (called a state machine workflow).  While the addition of state machine workflows to Designer (previously only available in Visual Studio workflows) is great; in my opinion the best (by a very small margin) addition to Designer is the ability to call web services.  As your queries get more and more complex however, knowing what is coming back into the workflow can be filled with frustration as you try to determine how to get the data from the response content.  While I it isn’t a new concept, I wanted to discuss handling REST responses in SharePoint Designer workflows.  Or at least how I do it.  The method I use is pretty straight forward and very easy to implement.

Read more