Error itgendhb212: External error in Invantive Data Hub. (out of memory)

The itgenoda061 error is something from the Exact Online server and has no relationship with the OutOfMemoryException thrown. For the itgenoda061 Data Hub should retry a few times automatically and then bail out. Please check whether the error occurred at a time when Exact Online might be down for maintenance. When it lasts longer than 10-15 minutes you might receive such an error.

The OutOfMemoryException is triggered in the code (method SaveFactsOnDisk) due to a current limitation. Starting release 20.0, Data Replicator maintain an on-disk copy in addition to the database replica created. This on-disk copy is stored locally, often in %USERPROFILE%\invantive. However, when the on-disk copy exceeds a size of 4 GB for one partition (something in the range of 1-4 million general ledger transactions) this error occurs.

Invantive is working on an improved algorithm to still maintain the on-disk copy even for large result sets. For now, you have to disable the on-disk copy using the connector attribute beta-store-facts-on-disk. From documentation:

Whether to store facts in the disk cache.

The attribute must be defined in the Data Cache connection string on the <connection> tag in the settings*.xml file:

## Corrected Connection String
    <connection 
      name="..." 
      dataCacheConnectionString="provider=SqlServer;beta-store-facts-on-disk=false;connectionString={Server=...;Database=...;User Id=...;Password=...;Encrypt=false}"
    >

This setting beta-store-facts-on-disk=false applies to all providers; it is a generic Data Replicator feature.