Deleted workflows are still shown in Workflow Inventory

Problem

Even though a workflow is deleted, still the deleted workflow is shown on 'Workflows in this site' and 'Workflows in this site collection' pages.

Solution

The site may have more than one databases and the deleted workflow still showing is created on the old database and the site is using current database.

The deleting functionality will remove / delete the workflows from current database only.

Workaround:

Delete the workflows manually by using delete SQL query from the database which is as below.

Sample SQL query to delete the workflow:

USE [NintexWorkflowDB]

GO

Delete from Workflows where SiteId = 'XXXXXX' and WebId = 'XXXXXX' and ListId = 'XXXXX'and WorkflowName = 'Workflow_Name'

Note: To perform the above delete query please keep below points in consideration:

1. Replace SiteId, WebId, ListId and WorkflowName as per your workflow.2. May be the workflow belongs to other content Database, so you need to first search that particular workflow on the content database and if exists then only you need to run the delete query.3. First check all the databases which are binds to your site collection.For that go to Central Administration - Nintex Administration - Database management. Under the content database you can see list of all the databases.4. The deleting operation should be safe if the xoml files are already gone.5. After running the delete query, refresh the page, the workflow will be removed from the list. If it still showing then you need to remove xoml file as well from the directory.