Out of memory - import with many rows

Add-ons
#1

I am trying to import an excel file with 4 columns and 106830 rows. After first step, and few minutes of CPU at 100% an exception of java.lang.OutOfMemoryError: Java heap space is raised

#2

hi,

lot’s amount of data can be a problem. In order to narrow down the problem, please see this similar topic: Support large files · Issue #86 · mariodavid/cuba-component-data-import · GitHub

You can instead of using the UI wizard use the DataImportAPI. Furthermore it heavily depends on the settings that you have configured for the data import. Unique configuration will influence that as well as the Trasaction Strategy.

Please provide the following:

  • an minimal example project
  • example import configuration
  • example import file (CSV e.g.)

then I can take a look into it.

Thanks

Cheers
Mario