Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Error "Error in task. Subquery returned more than 1 value"

    Summary
    When 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.

    Solution
    Run 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