Excel file import error: caused by: IOException: Zip bomb detected!

Oh_Lily Dataiku DSS Core Designer, Registered Posts: 12

I am trying to import an excel file in my flow and I get this error:
Tried format excel but configuration is not OK: Failed to open Excel file, caused by: OpenException: Failed to open file, caused by: IOException: Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data. This may indicate that the file is used to inflate memory usage and thus could pose a security risk. You can adjust this limit via ZipSecureFile.setMinInflateRatio() if you need to work with files which exceed this limit. Uncompressed size: 515868, Raw/compressed size: 5120, ratio: 0.009925 Limits: MIN_INFLATE_RATIO: 0.010000, Entry: xl/styles.xml

Any sugestions please anyone ?
Thank you in advance

Operating system used: Windows


Best Answer

  • Catalina
    Catalina Dataiker, Dataiku DSS Core Designer, Registered Posts: 135 Dataiker
    Answer ✓

    Hi @Oh_Lily

    The message shows the error "Zip bomb detected" which refers to an attack vector in which a small zip file expands to an extremely large size when uncompressed to the point that it exhausts server resources - https://stackoverflow.com/a/44900653.

    Unfortunately this file cannot be read using DSS, as the setting of the excel parsing library that controls the max allowed compression (i.e. ZipSecureFile.setMinInflateRatio()) ratio isn’t settable from the DSS UI.

    ​The solution to this issue is to open the file in Excel, export as a CSV, and then import the CSV into DSS.


Setup Info
      Help me…