Search code examples
dynamics-crmdynamics-crm-2016

Not able to delete the system workflow step in MS CRM 2016 on-premise


I have created a system workflow and deleted the workflow itself long back. But still the workflow is running. I cannot find it under normal process. But when I do the advanced find for process entity, I can find the workflow. When I am open it there is not delete or deactivate button for it.

I tried deleting or deactivating it from the workflow view itself. But it is not allowing me do. Getting the generic error as "Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support" . Could you please help on this. As this work has few email sending steps, so triggering the emails which I want to stop.

I cannot find it under the setting, all process.

enter image description here

But I can find it when I look for the process, use the “New” view and delete all the predefined conditions. In the below screen I click on the result able to find the workflow.

enter image description here

Workflow image

enter image description here


Solution

  • As specified in the below blog was not able to delete those activation type workflows from UI. https://sachinbansal.blog/2018/05/02/error-while-deactivating-workflows-should-be-exactly-1-messageprocessingstep-registered-for-workflow-dynamics-365/

    We have on-premise CRM, so deleted the workflow from CRM database. It is working fine now. Before deleting the workflow took full database backup. Run the select query by proving the workflow GUID. After finding the matching workflow record, deleted them from database. In my case I have found the matching records from the below list of tables in the database.

    1. WorkflowDependencyBase
    2. WorkflowBase
    3. WorkflowBaseIds