iVend to SAP Integration Error: System.Runtime.InteropServices.COMException (0x80070008) Not enough

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:
  1. Shrink CXSINTEGRATION Database and its Logs.
  2. 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.