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

Document created by butlerj Support on Nov 29, 2018
Version 1Show Document
  • View in full screen mode
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

Attachments

    Outcomes