topic Re: randomly get "Bad Zip File" error when loading .xlsx in QlikView

randomly get "Bad Zip File" error when loading .xlsx

ken_geren — Tue, 03 Jan 2017 15:24:30 GMT

How do I fix this error in QlikView 11.20.12742.? Most of the time the script completes successfully. It seems to occur only after certain people update the file. Could a different version of Excel cause this? The file extension does not change though. It's still .xlsx

Re: randomly get "Bad Zip File" error when loading .xlsx

m_woolf — Tue, 03 Jan 2017 16:03:01 GMT

You should identify those "certain people" and note their Office version. I'm guessing they are using Excel 2003.

Re: randomly get "Bad Zip File" error when loading .xlsx

ken_geren — Wed, 18 Jan 2017 15:59:46 GMT

load fails after file saved using Excel 2007. Need to load file no matter what version of Excel used.

Re: randomly get "Bad Zip File" error when loading .xlsx

petter — Wed, 18 Jan 2017 16:17:54 GMT

If they keep the file open in their Excel while the reload tries to read the file you might get a problem. Do they update directly from the same folder/directory as the server is doing the reload from?

Re: randomly get "Bad Zip File" error when loading .xlsx

ken_geren — Wed, 18 Jan 2017 16:28:07 GMT

It's not an open file issue. The file has extension .xlsx but the user updating the spreadsheet is using Excel 2007 and does not want to upgrade to a newer version of Excel. So based on the version used to save the file the Format-Spec in the FROM statement must be either OOXML or BIFF. How is that done? I can't believe I am the only one having this issue.

LOAD

FROM

[\\remsharepoint\shares\QlikDailyReports\External Data\Segment Input\CRI.xlsx]

(ooxml, embedded labels, header is 1 lines, table is CRI);

Re: randomly get "Bad Zip File" error when loading .xlsx

petter — Wed, 18 Jan 2017 16:39:41 GMT

You will have to set ErrorMode=0 and then check for ScriptError (variable) just after the load and if it fails do a retry in the other format something along this:

SET ErrorMode=0;

LOAD

[\\remsharepoint\shares\QlikDailyReports\External Data\Segment Input\CRI.xlsx]

(ooxml, embedded labels, header is 1 lines, table is CRI);

IF ScriptError <> 0 THEN

LOAD

[\\remsharepoint\shares\QlikDailyReports\External Data\Segment Input\CRI.xlsx]

(BIFF ......);

ENDIF

Re: randomly get "Bad Zip File" error when loading .xlsx

vishsaggi — Wed, 18 Jan 2017 16:41:21 GMT

Look here if you can figure out a solution from:

Bad Zip File Error from reading XLS files

Re: randomly get "Bad Zip File" error when loading .xlsx

alcorndg — Mon, 19 Feb 2018 23:00:01 GMT

Hey Ken,

I have started having this error as well. I know you posted this a year ago, but did you ever find a solution to this problem?

Re: randomly get "Bad Zip File" error when loading .xlsx

ken_geren — Tue, 20 Feb 2018 16:56:10 GMT

It was because of the version of Excel (2007) they were using. Once we had them use Excel 2010, there were not more issues.

Re: randomly get "Bad Zip File" error when loading .xlsx

vinod22kv — Wed, 18 Jul 2018 10:25:19 GMT

Hi,

I am also facing the same problem. only in server. in my local desk top it is working fine and i have deleted the files which is cussing error but i am getting the error with the same file name which i was deleted.

Can you please help me out