Problems with QVD load

[undergrinder]

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.

[robert_mika]

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]

Hi Robert,

As soon as possible, I share a code snippet.

I!m using still Qlik Sense 1.1 server edition.

G.

[undergrinder]

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 · Accepted solution]

Hi All,

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

G.