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”
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.
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.
Users give too much space in the comment section.