Getting zip bomb error when reading Excel file with pivot table via .bat file

[misguzar]

Hi,
I’m trying to read an Excel file that contains a pivot table in KNIME, but I’m getting the following error: “The file would exceed the maximum allowed inflation ratio. This may indicate that the file is used to inflate zip bombs.”

After some research, I found that I should add the following line to the knime.ini file: “-Dorg.apache.poi.util.ZipSecureFile.setMinInflateRatio=0.001”

I added this line to the end of the knime.ini file. When I run the workflow via the KNIME GUI, it works without any issues. However, when I run the same workflow using a .bat file, I still get the same error.

It seems like the JVM argument is not being applied when running from the .bat file. How can I fix this?

Thanks in advance.

[misguzar]

I haven’t found an alternative solution yet.

[mlauber71]

@misguzar welcome to the KNIME forum. have you tried this approach?

Relocate KNIME.ini file

Hi there James! Yes you can. By default the KNIME executable file (knime.exe) will look for a file beside the launcher with the same name and the extension .ini (knime.ini). One way to override this is to use --launcher.ini parameter. I tested it and started KNIME from Command Prompt with following syntax from KNIME installation folder: start knime.exe --launcher.ini test/knime.ini Maybe there is a cleaner solution (corporation like solution) for this Here is a link that helped me: …

Another option could be to use the integrated Python extension with OpenPyxl

Increased Excel file size and Excel Writer sheet append issue with KNIME 4.6.0

@alexkrah you might have found another solution but at least on a Mac, it is possible to write a file of your size into a large existing excel file with the help of the bundled Python and OpenPyxl although I would not necessarily recommend it … [image]