0 Replies Latest reply: May 19, 2016 3:20 PM by Giedrius Liubavičius RSS

    QlikSense 2.2.4 and STORE to QVD

      Hello everyone,

           does anyone else experience problems when STORE'ing data to QVD file specifically on 2.2.4 QlikSense??? (2.1.1 works fine)

       

           Example:

      SET QVD_APMOKEJIMAI='apmokejimai.qvd';

      SET QVD_BIUDZETAS='biuzetas.qvd';

      SET QVD_BALANSAS='balansas.qvd';

      SET QVD_DU='du.qvd';

      SET QVD_SANDELYS='nurasymai.qvd';

       

      SET QVD_TOTAL_BAL='summary_balansas.qvd';

      SET QVD_TOTAL_FIN='summary_fin.qvd';

       

       

      SET QVD_STORE=1;

       

      // ----CUTTED, Simplified --- //

       

      If DayStart(Alt(QvdCreateTime('$(QVD_SANDELYS)'),FileTime('$(QVD_SANDELYS)'),0)) < DayStart(Now()) Then

       

       

      [SANDELYS]:

      SQL SELECT

          DATA,

          GRUPE,

          Sum(KIEKIS*SAVIK)    as SUMA

      FROM snd

      GROUP BY DATA,GRUPE

      ;

       

       

      If $(QVD_STORE) THEN

          Store SANDELYS into '$(QVD_SANDELYS)'(QVD);

      END IF;

      ELSE

       

      [SANDELYS]:

      LOAD * FROM '$(QVD_SANDELYS)'(QVD);

       

      END IF;

       

      The following code "fails" on STORE command. The funny thing is: QlikSense successfully runs all the script and does not return any errors in the output. QVD files ARE created succesfully: they appeared in the folder and no errors found by monitoring with SysInternals ProcMonitor.

      qlikerr1.jpeg

      But in the data manager window, errors appear:

      Data load script execution completed with errors. Some tables may not be shown

      qlikerr2.jpeg

      Same thing on next run (that is LOAD'ing from saved cache QVD file):

      qlikerr3.jpeg

       

       

      Worked on QlikSense Desktop 2.1.1.0 !

      SENSE-ID 2.2.4+Build 60.release/ms15