All posts by DaveD

Read XML Data Files Stored in a SharePoint Library with PowerShell

I recently had a need to read data from an xml configuration file that was stored within a SharePoint library.  To make things easier I of course went to Google (or Bing) and checked to see if someone else had yet blogged this.  Couldn’t find anything, so in order to help out someone else that may need to do the same at some point, I wrote up a quick little blog.  Note: this will only work for on-premises versions of SharePoint.  I’ll update with a SharePoint Online version in the future.  I’ll also write up how to add and delete contents in a future post as well.

Read more

An Error Occurred While Running Detection when patching SharePoint Servers

Ugh, patching servers.  Yet another reason to move to SharePoint Online.  I recently started another patching process as the servers were getting out of date and needed to have the environments upgraded.  So while doing one server in particular I ran into a snag where the installer wouldn’t even run past the detection point.  It simply kicked off and immediately returned the error “An Error Occurred While Running Detection”

An Error Occurred While Running Detection - Error Message

I am going to go over the different steps I took to resolve this issue.  I am even going to list the ones that should have worked but didn’t in case they will work for you.

Read more

JavaScript files not Updating in Site Assets or other SharePoint Libraries

So ran into a very weird issue.  I had just finished patching our Dev and Test servers to the November 2017 CU.  And after this occurred, any updates to solutions using JavaScript injection was not working.  I’ll describe the problem in more detail here right away, but I want to make sure I give a call out to Trevor Seward.  Trevor blogs from The SharePoint Farm and kudos goes to him for pointing me at the Blob Cache (but I am getting ahead of myself).

Read more

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

Using Microsoft Flow to Update a Field From a Lookup Column

While planning out a new series I want to do around PowerApps and Flow I realized one of the things I needed to do was get the value of a lookup field into a text field.  Now we all know that using a calculated field for this isn’t going to work since they can’t see lookup fields.  Yes I could use a choice field instead, but in this case I wanted a lookup field so that the users could easily update the choices from the lookup list.  There are a number of examples of doing this with a SharePoint Designer Workflow.  So I got thinking, but about Flow?  I found a number of examples of users asking for ways to do this or having problems doing it, but nothing really concrete.  So I decided to write something up quick as it really is very easy to do with flow.

Read more