ISSUEWhen 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.
RESOLUTIONRun 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, 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: Backup the database before executing any "delete" statements and execute these in a transaction to avoid data loss.