SummaryWhen using a Flexi task action, or simple Flexi task workflow, the following error might occur: Error in task. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
SolutionRun the following query on Nintex Workflow 2010 database:
select [Name], [COUNT] = COUNT(*) from dbo.ConfiguredOutcomes group by [Name] having (COUNT([Name]) > 1)
This will provide a list of all duplicate values in the "ConfiguredOutcomes" table. If the query returns any result, you must make sure to delete all duplicate values (having the same [Name]) using Edit on the table or running a delete statement, for example:
delete from dbo.[ConfiguredOutcomes] where Id = TODELETEID
Note: Please make sure to make a backup of the database before executing any "delete" statements and execute these in a transaction to avoid data loss - http://msdn.microsoft.com/en-us/library/ms188929.aspx