cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Workflow Hero

User Defined Action already exists

we are migrating to SP 2016 and have created a dev site collection, we the copied dev to test and we are getting the error above.  I found a sql query to check for the UDA.  How do we remove it from the database?

IM Renderer Page  

Id StaticId Name Description Category IconUrl ToolboxIconUrl WarningIconUrl ConfigurationPageUrl SiteId WebId
1000003 9ED472A3-BBE1-4B8A-8258-649C8D263F97 ModifyDisplayNameNew User Defined Actions /_layouts/15/NintexWorkflow/Images/Activities2016/common/user-defined-action.svg /_layouts/15/NintexWorkflow/Images/Activities2016/common/user-defined-action.svg /_layouts/15/NintexWorkflow/Images/Activities2016/common/user-defined-action.svg UserDefinedAction.aspx 047B9CA6-98F7-4D7E-900C-34AF6F61BDE9 475E94C7-48D6-46DB-953E-8F2E3F973090
1000004 3C951B71-C0BF-45C1-99BE-657E153F50E2 ModifyDisplayName User Defined Actions /_layouts/15/NintexWorkflow/Images/Activities2016/common/user-defined-action.svg /_layouts/15/NintexWorkflow/Images/Activities2016/common/user-defined-action.svg /_layouts/15/NintexWorkflow/Images/Activities2016/common/user-defined-action.svg UserDefinedAction.aspx 86DE3187-633A-4F30-AE52-CA7B5AB6AD98 B748C4B4-AB75-4590-9731-887055BF2798
0 Kudos
Reply
1 Reply
Workflow Hero

Re: User Defined Action already exists

I had the same issue and was able to resolve. Note that I did the following in a development environment and I assume deleting from the Nintex config database is not supported. This post, http://johnliu.net/blog/2015/3/20/nintex-workflow-modifying-your-farm-uda.html, pointed me in the right direction.

I ran the following against our Nintex config database to find the UDA's I was having trouble with.
SELECT [Id]
,[StaticId]
,[Name]
,[Description]
,[Category]
,[SiteId]
,[WebId]
FROM [SP2010_Dev_Config_Nintex_Workflow].[dbo].[UserDefinedActions]

This gave me a site id which referred to a site that no longer existed. I then deleted the offending record from the Nintex config database and could then upload my UDA. This allowed me to import some production workflows into dev and not have to reconfigure each UDA workflow activity.
DELETE FROM SP2010_Dev_Config_Nintex_Workflow.dbo.UserDefinedActions
WHERE Id = '1000061';

0 Kudos
Accept as Solution Reply