Java Heap Space error on Excel Writer - please help?

KNIME Analytics Platform
3

@taylorpeter55 just to be sure: you restarted the KNIME platform after you made the changes to the knime.ini?

https://docs.knime.com/latest/analytics_platform_installation_guide/index.html#_configuration_settings_and_knime_ini_file

Then:

  • 4 GB is not that much (sorry). I would suggest you give KNIME 2/3 of you memory and stopp using all other programs for the time being
  • I have a collection of hints about KNIME and performance, maybe you want to explore: A meta collection about KNIME and performance and performance tuning and some problems – KNIME Hub
  • of course you can reconfigure your workflow, save the paths and variables in a table and do the export later
  • maybe also make sure the Excel files are initially empty or not there (if your use case allows that)
  • then: maybe try a later version of KNIME (4.6.1) and see if that does work and also the latest Excel Writer
  • then: maybe you can tell us a little more about what you are doing
  • do you use the garbage collection after each iteration?
  • then: you could think about not storing some intermediate data in your workflow just the result (Save Workflow without data - #2 by qqilihq)
  • if nothing else does work you could save your intermediate results as KNIME table and then do a seperate job with exports to Excel (might be a meassure of last resort)
6 Likes