Skip to main content

Error - ' Subquery returned more than 1 value This is not permitted when the subquery'

For help when you are unable to import data due to this error.

Written by Emma

Overview

If you cannot import data due to the following error message:

Orchestrate data flow import has failed. The Detailed information is as follows:
​
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <,<=,>,>= or when the subquery is used as an expression.
​
Import command: EXEC [wf].[pr_Merge_Tasks]

This article can provide you with the next steps on resolving this.


What to do next

If you are seeing this error, then rebooting the SQL server (where the ERP system and Orchestrate database are kept) resolves this issue, if you are not hosted with Access, please contact your IT to arrange this.


Need further help?

If you still need help, or you are hosted with us, please contact support, and provide us with the error message in question and when you are seeing this message. We are here to help!!

Did this answer your question?