topic Problems with QVD load in App Development

Problems with QVD load

undergrinder — Tue, 05 Apr 2016 20:49:24 GMT

Hi All,

I have an load script, that creates a QVD file.

The new files are loaded, then the QVD as well, concatenating and store to the same QVD.

It worked well, but today I've got the error message, that the file is "unsupported format".

The file has ca 4 000 000 row.

Does have QVD size limitation? Or what could be the problem?

Thanks!

Re: Problems with QVD load

robert_mika — Tue, 05 Apr 2016 21:48:39 GMT

Coudl you post your script?

Did you make any changes to it? or to anything else including new QLikview version?

Look here for some advice

Reload does not complete, just hangs after load *

Re: Problems with QVD load

undergrinder — Wed, 06 Apr 2016 05:58:48 GMT

Hi Robert,

As soon as possible, I share a code snippet.

I!m using still Qlik Sense 1.1 server edition.

Re: Problems with QVD load

undergrinder — Wed, 06 Apr 2016 09:29:13 GMT

Hi Robert,

Here is the code snippet:

I have a table, that contains the new filenames, called 'tmp_Increment_base'

the vMaxRownum variable contains the number of new files.

//Load the new files

If vMaxRowNum>0 then

For iternum = 0 to $(vMaxRowNum)-1

let File = peek('Filename_base',$(iternum),'tmp_Increment_base');

let adatDT = peek('adatdt_base',$(iternum),'tmp_Increment_base');

data:

LOAD

FROM [$(File)]

(ooxml, embedded labels, table is Sheet);

Next

End if

//Read the old files, stored in qvd

//ErrorMode = 0, if the file doesn't exist it still OK

set ErrorMode = 0;

data:

LOAD

FROM [lib://$(FolderAlias)/old_files.qvd] (qvd);

//Store data:

STORE data INTO 'lib://$(FolderAlias)/old_files.qvd' (qvd);

set ErrorMode = 1;

//EOC

Output: The following error occurred: Cannot open file (at old_files.qvd)

If I try load the old_files.qvd I get the following message: Unsupported file format.

I have an other application, with same logic, it works well, I think only it has limitation of size or other at qvd.

Or at filesystem on server...

Re: Problems with QVD load

undergrinder — Mon, 11 Apr 2016 09:36:07 GMT

Hi All,

The problem wasn't related to QVD file format, it was related to network drive filesize limit.