7 Replies Latest reply: Sep 21, 2017 6:14 AM by Peter Cammaert RSS

    Issue with Refreshing QlikView data

    Hariprasad Acharya

      HI Team,

       

      We have some problems with refreshing QlikView data from DSX(Demand Planning Software) Database. This job ideally takes 1:20 hrs to complete, but some time it just keeps running and fails or we must kill the process manually. We are seeing this happening quite frequently in our production server.  Please can you point us in a direction to see what might be causing this issue? Below is the screen shot of today’s run which we had to kill the process after running for 6 hrs. We have to update QlikView everyday as this tool is being used by the S&OP team for running reports on DSX data.

        • Re: Issue with Refreshing QlikView data
          Vishwarath Nagaraju

          Did you see all the document logs for these failed tasks? What do they say?

            • Re: Issue with Refreshing QlikView data
              Hariprasad Acharya

              I see the follwing error in the logs.

               

              2017-09-13 15:25:08) Error: The task "Reload of CreateQVD_DSX v2.3.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted. || at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) || at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext) || at SolutionGlobal.ThreadPool.ThreadPoolJob.SafeWaitEvent(WaitHandle eventWaitHandle) || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

              (2017-09-13 15:25:08) Error: Task failed with exception