iVend to SAP Integration Error: System.Runtime.InteropServices.COMException (0x80070008) Not enough
Environment-
IVend 6.6
Problem statement:
iVend to SAP Integration Error: System.Runtime.InteropServices.COMException (0x80070008) Not enough storage is available to process this command
Symptoms:
Sale Transactions is not integrating from ivend to SAP B1
Below error message shown in iVend to SAP integration failure monitor:
System.Runtime.InteropServices.COMException (0x80070008) Not enough storage is available to process this command. (Exception from HRESULT 0x80070008) at SAPbobsCOM.CompanyClass.GetBusinessObject(BoObjectTypes Object) at ReplicationSBOIntegrationWinSer.In
Reason/Cause:
This problem occurred due to CXSINTEGRATION database size was huge approx. 150400.00 MB (CXSINTEGRATION MDF Size: 19440 MB CXSINTEGRATION LDF Size: 130960 MB)
Resolution/Work Around:
Steps are below:
- Shrink CXSINTEGRATION Database and its Logs.
- Restart iVend Integration Services
After performing above mentioned steps then checked stuck Sale Transactions get integrated successfully from iVend to SAP B1.
Recommendations /Suggestion:
Make sure to have a working backup copy of the SQL database before making any changes /operation on the databases.