Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

undergrinder
Valued Contributor II

Problems with QVD load

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!

G.

1 Solution

Accepted Solutions
undergrinder
Valued Contributor II

Re: Problems with QVD load

Hi All,

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

G.

4 Replies

Re: Problems with QVD load

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 *

undergrinder
Valued Contributor II

Re: Problems with QVD load

Hi Robert,

As soon as possible, I share a code snippet.

I!m using still Qlik Sense 1.1 server edition.

G.

undergrinder
Valued Contributor II

Re: Problems with QVD load

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

            A

            ,B

        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

            A

           ,B

     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...

G.



undergrinder
Valued Contributor II

Re: Problems with QVD load

Hi All,

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

G.