Issue

When trying to upgrade or alter the mappings for the Nintex Content Database, the following error might occur:

Cannot find the object 'DeleteWorkflows', because it does not exist or you do not have permission.

Resolution

Check the Nintex Content database for duplicates of the dbo.DeleteWorkflows Stored Procedure.

Open the Nintex DB in SQL Manager, and navigate to: Programmability > Stored Procedures > dbo.DeleteWorkflows

If there are duplicate entries, right click on each “dbo.DeleteWorkflows” and open the “Permissions” page.

Verify that Execute permission has been granted.

Once the schema has been corrected, or the duplicate stored procedure has been deleted, retry the DB upgrade/mapping.

Note: The duplicate entry may be located at the bottom of the list of stored procedures.