Developer forum

Forum » Integration » Subquery returned more than 1 value.

Subquery returned more than 1 value.

Aki Ruuskanen
Reply

Hi,

I got this during an import of users with a CSV file as source. Does anyone know what field might have caused this error?

 

Job Failed with the following message: failed to move data from temporary table [dbo.AccessUserTempTableForBulkImport] to main table [dbo.AccessUser]. Reason: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

 

Regarsd / Aki

 


Replies

 
Dmitriy Benyuk
Reply
This post has been marked as an answer

Hi Aki,
this error is regarding some duplicates. Check if you don't have several users with the same User Name or E-mail or in the source field which is mapped to the selected option in the drop-down "User key field".

 

Regards, Dmitrij

Votes for this answer: 1
 
Aki Ruuskanen
Reply

Yes, thanks. 

Found the error but forgot to update this thread. It was exactly that. Duplicates in the User Key field.

Regards / Aki

 

You must be logged in to post in the forum