10 Replies Latest reply: Sep 24, 2013 8:09 AM by Biplab Roy RSS

    Problem with QVD creation

      Hi Friends

      I am a beginner in QlikView. Currecntly i am facing a problem to creating QVDs and Store into hard drive for future use. I am using this sample codes for all tables:

      I am using just 35 tables.

       

      let qvdpath='E:\path...................................................\';

      store *from TableName1 into $(qvdpath) TableNm1.qvd;

       

      error i am getting...

       

      "Execution of script failed. Reload the old data?"

       

      Let me know any alternative methods.

       

      Thanks in advance.

       

      Roy

        • Re: Problem with QVD creation
          Erik van hout

          Hi Roy

           

          This is what works for me:

           

          LET qvdpath= 'E:\path\';

          STORE TableName1 into '$(qvdpath)TableNm1.qvd' (qvd);

          • Re: Problem with QVD creation
            dhiraj kumar

            Hi ,

             

            Kindly use the below line to set the path.

            set qvdpath='E:\path...................................................\';

             

            Thanks,

            D J

            • Re: Problem with QVD creation
              bhupesh gupta

              Hi

               

              Try by replacing the qvdpath var in store statement with the actual path. If it works then use what dhiraj has suggested.

               

              Regards

              Bhupesh

              • Re: Problem with QVD creation
                Ali Hijazi

                may be windows permission problem; check that the user / process running the QlikView has the write permission on the path specified/p>

                • Re: Problem with QVD creation
                  jagan mohan rao appala

                  Hi,

                   

                  Try this

                   

                  Store TableName1 into $(qvdpath)TableNm1.qvd;

                   

                  If not working check whether the path exists or you have access to this folder.

                   

                  Regards,

                  Jagan.

                  • Re: Problem with QVD creation
                    Friedrich Hofmann

                    Hi Biplab Roy,

                     

                    why do you bother with a variable at all for a task as simple as creating a qvd file?

                    We have lots of those in our company-wide rollout - in a three-tier architecture - and I have a few in my apps to abuse QlikView for creating a history...

                    We have the "use relative paths" box checked and just written it out every time and we have no problems.

                     

                    Also, it might be that your Server (I assume you have that app running on a server) cannot use the drive-letter E? That was my issue for some time.

                     

                    HTH

                    Best regards,

                     

                    DataNibbler

                    • Re: Problem with QVD creation
                      Jonathan Dienst

                      Hi

                       

                      This error usually occurs because the write operation fails - possible causes are:

                      • user does not have write access to the path specified
                      • the path does not exist (the write command does NOT create the folder if it does not exist). If you have a space between $(qvdpath) and TableNm, this could be the problem. The file name and path should be enclosed in square brackets if the path contains spaces.  ie like [$(qvdpath)TableNm.qvd].
                      • the file is locked and cannot be overwritten. This can be caused by a failed QV reload that was aborted, but left the QV.exe running. Close all instances of QV.exe processes in the task manager.

                       

                      Regards

                      Jonathan

                      • Re: Problem with QVD creation

                        Hi, there was a problem with a key table, i found while i testing those object. Now its working fine. Its creating 13 Qvds with-out loop and able to recollect using store..,

                        (I guess that was the problem, because i had already done  what you all suggested)

                         

                        Thanking you all and Qliking

                         

                        Roy