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

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.