Integration records are not moving
Version
6.6, not the version-specific
Issue
Integration records are not moving.
For the troubleshooting purpose, customer has start/Stop/Update the integration service and retried all the integration failure from iVend to SAPB1 but most of the events are displaying below error:
System.Runtime.InteropServices.COMException (0xFFFFFBA4) at SAPbobsCOM.CompanyClass.EndTransaction(BoWfTransOpt endType)
at ReplicationSBOIntegrationWinSer.IntegrationObjects.Base.IntegrationBase.CommitTransaction()
at ReplicationSBOIntegrationWinSer.IntegrationObjects.UPCTranslation90.Replicate(Direction From, Direction To, Int32 DatasetRowID) at ReplicationSBOIntegrationWinSer.Integrator.MainStart(DateTime LastRetryAt, Boolean Retried)
Resolution
During the investigation, we found that there were privilege issues with the user over the SAP HANA database which is causing the issue.
Below is the attached screenshot for the same:
So as per above screenshot there is Execute Permission missing for the SBOADMIN user for the corresponding SAP HANA DB.
The customer has to provide read, Write, and Execute permissions on this DB.
Once permissions are granted, issues should be resolved.
This KB article concludes here.
Related Articles
Records in Integration not moving: Error: Could not load file or assembly Interop.SAPbobsCOM
Version 6.6, not the version-specific Issue Records in Integration monitor not moving. This indicates that integration events not moving, neither from SAP to iVend nor from iVend to SAP means all the Integration records are getting stuck in the ...When records are not moving in Sage Integration
Introduction: Sometimes it happens that records do not move in the Sage Integration monitor. Means, Records do not sync from iVend to Sage and vice versa. Which can happen due to any reason. Steps: Below are the basic steps to troubleshoot the issue ...Integration Service Pick the Records in Integration .
Environment: iVend 6.6 with SAP B1 9.3 Problem statement: There are many records in integration from SAPB1 to iVend and iVend to SAPB1 . Will records ( SAPB1 to iVend ) process first as compared to iVend to SAPB1. Symptoms: NA Resolution/Work Around: ...Integration Record were not moving from iVend SAP TO iVend "DI:Update the exchange rate , ''USD''
Environment: iVend 6.6 8567 SAP B1 10.0 Problem Statement: Records were not moving from iVend To SAP, all were in Not Processed, event log was showing below error for CXSINTEGRATION. Error: "DI:Update the exchange rate, ''USD'' Symptoms: User created ...Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"
Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...