AnsweredAssumed Answered

Why does Assign Flexi Task Error with "Subquery returned more than 1 value"

Question asked by dominic.shields@ons.gov.uk on Feb 8, 2017
Latest reply on May 21, 2018 by marcinp

I have a simple workflow without escalation or delegation where I am using a Flexi Task to have a three way decision point : Approve, Reject and Changes Required.

Without fail the workflow errors with the message: 

"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."

I have found three previous forum posts/questions where people report this

https://community.nintex.com/message/47012
https://community.nintex.com/message/34020
https://community.nintex.com/message/25632

But other than a tantalising idea that deleting rows in an undefined table will fix it (something my system admins said sounds highly suspect), there doesn't seem to be a solution posted.

I'd appreciate any help.

Outcomes