ERP Integration issue from iVend to SAP Subquery returned more than 1 value. This is not permitted

ERP Integration issue from iVend to SAP Subquery returned more than 1 value. This is not permitted

Product Version 

6.5 Update 6


Problem Statement

Sale stuck in Integration Failure Monitor with error message


System.Exception:Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression


Proposed Solution

This issue generally comes when there is more than one product data in fulfillment detail.

(INC0012221)


Steps if any 

We are required to follow the steps below.


1.Extract source key from RepIntegrationlog


2.Run Stored procedure Exec Integration_Transaction 'Transactionkey'

it will return an error Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression


3.Check data on table TrxTransactionFulfillmentDetail if found duplicate data against sourcekey then confirm with customer correct data and delete the data with the help of sql query.


4.Retry the transaction and it will integrate successfully.


Constraints / Scenarios

NA