Support Portal ContactGet in touch

Error Deactivating or Activating Business Process Flow after Upgrade of Dynamics CRM

   Words by Paul McQuillan

   on 29/11/2018 15:00:00

imageAfter upgrading CRM 2011, 2013 or 2015 to Dynamics 365, we can see a problem where the Default Business Process Flows that come with Dynamics 365 fail to Deactivate or Activate from the Processes area in CRM – instead reporting a stock error which is not much use in tracing to the root cause of the problem.

This is where the upgrade has left invalid records in the WorkflowBase Table that we can correct via a SQL Update.

NOTE: As with any Direct-to-SQL modification with Dynamics, this is best avoided if possible and should only be done following a full SQL Backup so we have a rollback point if anything goes wrong – but otherwise will fix this problem.

The SQL here is as follows:


       (Name = 'Opportunity Sales Process' OR Name = 'Phone to Case Process') AND

       [BusinessProcessType] is NULL


update dbo.WorkflowBase

set BusinessProcessType = 0


       (Name = 'Opportunity Sales Process' OR Name = 'Phone to Case Process') AND

       [BusinessProcessType] is NULL

This corrects the problem as the WorkflowBase records should have a ‘BusinessProcessType’ of 0 instead of NULL – where the [Name] is the Text Name of the Business Process Flow we need to fix. (this can also be done using the GUID for WorkflowId, but other the real-world name here is easier to work with)

This then allows the Dynamics UI to correctly interpret the record behind the Business Process Flow and so fixes the error on Activating or Deactivating.

All credit to the following article for providing the resolution to this error post-upgrade of Dynamics: 

Error Log

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #7AA39F47Detail:
< OrganizationServiceFault xmlns:i="" xmlns="">
  < ActivityId>99bd6e08-f189-4f23-a8ad-43605b93f1fa</ActivityId>
  < ErrorCode>-2147220970</ErrorCode>
  < ErrorDetails xmlns:d2p1="" />
  <Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #7AA39F47</Message>
  < ExceptionSource i:nil="true" />
  < InnerFault>
    < ActivityId>99bd6e08-f189-4f23-a8ad-43605b93f1fa</ActivityId>
    < ErrorCode>-2147220970</ErrorCode>
    < ErrorDetails xmlns:d3p1="" />
    <Message>An unexpected error occurred.</Message>
    < ExceptionSource i:nil="true" />
    < InnerFault i:nil="true" />
    < OriginalException i:nil="true" />
    < TraceText i:nil="true" />
  < OriginalException i:nil="true" />
  < TraceText i:nil="true" />
< /OrganizationServiceFault>

Share this Article

Search Articles

Filter Articles

CRM Tech DocMan

Recent Articles

CRMCS Quick Start Guide: How To Produce a Microsoft Teams Live Event Dynamics 365 Marketing: Lead Scoring and Sales Acceptance Designing and Developing Microsoft Power Apps Portals Thank You for Attending CRMCS’ Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Thank You for Attending Our Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Webinar: Discover How CRMCS Have United Dynamics 365, SharePoint and Microsoft Teams To Create Sales Excellence Ignite your workflow by adding DocDrive365 to Office 365 The CRMCS guide to everything you need to know about integrating Teams with Dynamics 365 Saving Time By Keeping Documents In One Place TDE Database Encryption with On Premise Dynamics The Key to Successful Compliance in 2020 Part 2: Let’s get GDPR Compliant with Microsoft Power Automate Top 3 Essential Tips for Remote Working Dynamics 365 Marketing: Top 5 Best Features Dynamics Day in the Life - Puma Investments Can you use Teams to amplify collaboration in Dynamics? Part 1: Using a Scheduled Power Automate to Trigger Expiry Date Reminders The secrets of successful document collaboration in Dynamics CRMCS launches new AppSource approved DocDrive365 Dynamics Day in the Life - Moneypenny Release Management Add the App to Dynamics DocDrive365 Security: Day One - Getting Started with Dynamics to SharePoint Permissions Building a New Scheduled Process using Flow
  • "Paul has made a real difference to how my team of 24 people record and store valuable customer data and sales opportunities. Highly recommended."

    James, Operations Director

  • "Understanding your business allows us to advise when to implement aspects of CRM and, likewise, when not to."

    Paul McQuillan, Managing Director

  • "Dynamics 365 and CRMCS have made a real lasting difference to our business, allowing us to replace older systems that were holding back our performance."

    Grahame, Chief Operating Officer

  • "James worked well with us to help connect CRM with Outlook and relate how this might benefit our team using CRM for Property Care."

    Natalie, Property Care Supervisor

  • "Matt was really good with helping us run User Testing on the new Compliance Module of our CRM System."

    Tom, Compliance Administrator

Prefer to go old-school?

Write to us using the below addresses.

Head Office
CRM Consultancy
61 Oxford Street
M1 6EQ

London Office
CRM Consultancy London
Grosvenor Avenue

Content © CRM Consultancy.