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.