Skip to main content
Search Again

We think these articles could help you:

    See More

    ALERT: This site will be decommissioned at the end of December 2018. All existing and new Nintex knowledge content will be available within the new Knowledge Base area of the Nintex Community site. 

    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