Topic
A user defined action (UDA) appears to be used by workflows on another site. This isn't the actual case and the below instructions will correct this.
Instructions
Take note of the following:
Use the following SQL script to clean this up
-- Get UDA Id
SELECT *
FROM UserDefinedActions
WHERE 1=1
AND [Name] = 'UDA Name'
-- Get Published Workflow Id
SELECT *
FROM PublishedWorkflows
WHERE 1=2
OR (WorkflowName = 'Workflow Name' AND [Version] = 3)
OR (WorkflowName = 'Workflow 2' AND [Version] IN (18,19)) --Multiple workflows
OR (WorkflowName = 'Workflow 3' AND [Version] = 4) –Multiple Workflows
-- Find reference records
SELECT *
FROM UdaUsage
WHERE 1=1
AND UdaId = <ID of your UDA>
AND PublishedWorkflowId IN (ID of Published workflow) –Separate multiple workflows with a comma
-- Remove reference records
DELETE
FROM UdaUsage
WHERE UdaId = <ID of your UDA>
AND PublishedWorkflowId IN (ID of Published workflow) –Separate multiple workflows with a comma
- UDA name
- Workflow Name
- Workflow version (in UDA Analyzer)
Use the following SQL script to clean this up
-- Get UDA Id
SELECT *
FROM UserDefinedActions
WHERE 1=1
AND [Name] = 'UDA Name'
-- Get Published Workflow Id
SELECT *
FROM PublishedWorkflows
WHERE 1=2
OR (WorkflowName = 'Workflow Name' AND [Version] = 3)
OR (WorkflowName = 'Workflow 2' AND [Version] IN (18,19)) --Multiple workflows
OR (WorkflowName = 'Workflow 3' AND [Version] = 4) –Multiple Workflows
-- Find reference records
SELECT *
FROM UdaUsage
WHERE 1=1
AND UdaId = <ID of your UDA>
AND PublishedWorkflowId IN (ID of Published workflow) –Separate multiple workflows with a comma
-- Remove reference records
DELETE
FROM UdaUsage
WHERE UdaId = <ID of your UDA>
AND PublishedWorkflowId IN (ID of Published workflow) –Separate multiple workflows with a comma