4 Replies Latest reply: Apr 11, 2016 5:36 AM by Gabor Tarnoczai RSS

    Problems with QVD load

    Gabor Tarnoczai

      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.

        • Re: Problems with QVD load
          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 *

            • Re: Problems with QVD load
              Gabor Tarnoczai

              Hi Robert,

               

              As soon as possible, I share a code snippet.

              I!m using still Qlik Sense 1.1 server edition.

               

              G.

              • Re: Problems with QVD load
                Gabor Tarnoczai

                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.

                 

                 



              • Re: Problems with QVD load
                Gabor Tarnoczai

                Hi All,

                 

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

                 

                G.