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"

    Status: Validated

    ISSUE
    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.
    ERROR CODE
    RESOLUTION
    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, 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.

    ADDITIONAL INFORMATION
    This is caused by duplicate values in the "dbo.ConfiguredOutcomes" table in the Nintex database.
    RELATED LINKS