Today I encountered a list item that had two instances of the same workflow, both stuck on the first step.

“End this workflow” – 0

“Suspend this workflow – 0

Workflow Instances – 4

Having encountered this cockroach of workflows, to PowerShell I went. Hoping that I would be able to terminate the workflow instances.

PowerShell  – 0

Workflow Instances – 6

No matter what I tried, the score kept increasing, and not in my favor.

After working on this all morning, I finally hit “F#(< it” mode and cracked open SQL Management Studio. I expanded the WFInstanceManagementDB > Tables > dbo.Instances and did the unthinkable. “Edit Top 200 Rows”, yes I directly edited the database. I’m crazy like that.

Mousing over the workflow instance on the Items Workflows page will list the Workflow Instance ID at the end of the URL in the bottom of the browser window. Match that in the InstanceId column of the sdo.Instances table and scroll to the right to the WorkflowStatus column. Change the status to Terminated and hit Enter to update.

Back to SharePoint and F5 the workflows page.

Workflows – 6

SharePoint Sheriff – 1 (the one that counts)

*mouse drop* <– like a mic drop but geekier


December 3rd, 2018

Date Table and Extras for Power BI

When dealing with incomplete date sets in Power BI, I often add in a quick and dirty Data table to […]

February 14th, 2018

Invincible workflows

Today I encountered a list item that had two instances of the same workflow, both stuck on the first step. […]

May 17th, 2017

The case of the missing App Launcher

Today I deleted and recreated a SharePoint 2016 Web application and recreated it, without issue. Well, except that the new […]

March 10th, 2017

The server failed to process the request. Aka, the SharePoint version of PCLoadLetter

It’s Friday so I’ll keep this short The ongoing power struggle between SharePoint and it’s tamers continues. Today we’re faces […]

March 3rd, 2017

Search, search, search, all the day long…

So, I just rolled SharePoint 2016 into a test environment and launch Central Admin, and the first thing my eyes […]

May 5th, 2016

Oh, happy day!

SharePoint 2016 has been released to MSDN! Time to practice different upgrade strategies and see what this baby can do! […]

March 29th, 2016

Branding Gone Wild

Today I ran into a problematic sub-site in my SharePoint 2013 farm. This sub-site, named “Test”, was where I had […]

March 14th, 2016

SharePoint 2016 RTM Released Today

Today marks the beginning of the next chapter for SharePoint as Microsoft released SharePoint 2016 RTM today. Ready to get […]

October 13th, 2015

A SharePoint game of hide and seek!

Today I was tasked with creating a custom list. Pretty normal so far, right? Here’s where it gets interesting. The […]

October 9th, 2015

My first Hadoop install.

So, I built my first single node Hadoop cluster today using Ubuntu 14.04 LTS, Hadoop 2.7.1 and Oracle Java 1.7.0_80 […]