System.Runtime.InteropServices.COM Exception from HRESULT: 0xFFFFFC17 Stock transfer

System.Runtime.InteropServices.COM Exception from HRESULT: 0xFFFFFC17 Stock transfer

Problem Statement 

Unable to integrate the Stock transfer from iVend to SAP B1.


In the integrationMonitor it show error as “System.Runtime.InteropServices.COMException (0xFFFFFC17): Exception from HRESULT: 0xFFFFFC17”  



Proposed Solution/Workaround 

We check for the Stock transfer data in the Stock transfer table “invStockTransfer”. In the Comment field found that too much space is given by the user.


Remove the excess space from the comment column. Try to re-process the integration.


Steps if any  

The steps are explained below:


1. Take the stock transfer key from the query.


select * from RepIntegrationLog where IntegrationKey ='Integration key'


 2. Check the Comment in stock transfer tables.


select Comments ,* from  InvStockTransfer   where  StockTransferKey='Get Source key from RepIntegrationLog table'


 3. Update the comments.


Begin Tran

UPDATE  InvStockTransfer  SET Comments='New edited Comments'  where  StockTransferKey ='Get Source key from RepIntegrationLog table'

Commit Tran


4. Reprocess for the integration


Begin Tran

UPDATE  RepIntegrationLog  set Flag='0',Status='0'  where IntegrationKey ='Integration key'

Commit Tran


5. Refresh  from the integration monitor, it will integrate.


Constraints/Scenarios  

Users give too much space in the comment section.