8 Replies Latest reply: Dec 19, 2013 10:58 AM by Ling Bao RSS

    Task failure

    Ling Bao

      I got the following error msg. My understanding is this task failed to reloaded.

      But this task reloaded successfully before and next day.

      Could anyone explain in detail to me what caused this error? And how to prevent it in the future.

       

      Many thanks.

       

        • Re: Task failure
          Aadil M

          as the reload has failed, its difficult to say why would have it failed as it depends on lots of factor, the first being a script error, or in your case, i think this QVW is to extract the data and when it ran the database was down or busy and Qlikview was not able to connect to the database. This could be one reason.

           

          To monitor this, i would suggest you enable the Generate Log File option and also enable the option "Timestamp in LogFile Name" as this will create separate log files for each run, and this way you can verify the hostoric run details also.

           

          Hope this helps.

           

          Regards,
          Aadil

            • Re: Task failure
              Ling Bao

              Thanks Aadil.

              I'll enable "Timestamp in LogFile Name" to create separate log files, in case this happens again.

              • Re: Task failure
                Ling Bao

                Hi,

                   The task failed again. As you suggested, I enabled "Timestamp in LogFile Name", and the log shows "General Script Error". But when I debug the script, there is no errors in script. I reran this task, and it reloaded successfully. Anyone has any idea why my task failed? Many thanks.

                 

                Here is the screenshot from the log.

                 

                  • Re: Task failure
                    Aadil M

                    One of the reason i can tell you is, The QVD was in use with another process. Like, someone was downloading this QVD through Filezilla or you had read this QVD with another instance of qv,exe...

                      • Re: Task failure
                        Ling Bao

                        Thank you all for the thoughts.

                         

                        I exam-med all qvws that may run at the same time when this task is running. And found they are all independent. The only reason I guess is that a couple of large qvws start and end almost at the same time and they may compete limited source(like memory, cpu etc.) , which leads to this task failed to store its own qvd sometimes.

                        Is that possible?

                      • Re: Task failure
                        jagan mohan rao appala

                        Hi,

                        Check whether the file path exists or check while saving using Store command somebody or other apps accessing the file. 

                         

                        Regards,

                        Jagan.

                        • Re: Task failure
                          Bill Britt

                          Hi,

                           

                          If the "F" drive is a mapped drive it will not work. You will need to use an UNC path to the files, serivce accounts do not understand mapped drives.

                           

                          Bill

                      • Re: Task failure

                        As suggested, it could have been a lot of reasons.

                        I would look at script log and tasklog to compare.

                        Also, windows event and application log can give you good info, sort it by critical, warning and error and look at the time of the exception