Qlikview Tasks Failing

vidyarani — Fri, 15 Nov 2024 23:43:05 GMT

Hi All,

Some of QV tasks are failing randomly and quiet often.

Here is the log:

(2020-10-29 07:29:11) Information: Starting task 'Model - Sales Performance'. Id:98109b58-9287-4bc4-948c-f4bfdebe2235. Triggered by 'TaskCompletedTrigger'. Id:fba561f6-48f7-40dc-a2db-3c15f9192762

(2020-10-29 07:29:11) Information: Entering Task Execution.

(2020-10-29 07:29:11) Information: ClusterID=1

(2020-10-29 07:29:11) Information: QDSID=eae38e02-59ab-3305-a2d1-51c8b362403a

(2020-10-29 07:29:11) Information: TaskID=98109b58-9287-4bc4-948c-f4bfdebe2235

(2020-10-29 07:29:11) Information: MaxRunTime=1.00:00:00

(2020-10-29 07:29:11) Information: MachineName=YQVS01

(2020-10-29 07:29:11) Information: Max attempts:1

(2020-10-29 07:29:11) Information: Current Attempt=0

(2020-10-29 07:29:11) Information: Task Dependencies are OK

(2020-10-29 07:29:11) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2020-10-29 07:29:11) Information: Opening "\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw"

(2020-10-29 07:29:11) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).

(2020-10-29 07:29:11) Information: Max retries:5

(2020-10-29 07:29:11) Information: Attempt:01

(2020-10-29 07:29:12) Information: Opened the QlikView Engine successfully. ProcessID=4188

(2020-10-29 07:29:12) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=512.

(2020-10-29 07:29:12) Information: Loading document "\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw" (299.10 Mb)

(2020-10-29 07:29:13) Information: Loading. LoadTime=00:00:01.0000718

(2020-10-29 07:29:15) Information: Loading. LoadTime=00:00:03.0001938

(2020-10-29 07:29:19) Information: Loading. LoadTime=00:00:07.0076113

(2020-10-29 07:29:27) Information: Loading. LoadTime=00:00:15.0127984

(2020-10-29 07:29:43) Information: Loading. LoadTime=00:00:31.0255813

(2020-10-29 07:30:05) Information: Physical FileSize=299.10 Mb. Memory Allocation Delta for this file=89.85 Mb. Available Physical Memory Before Open=167278.67 Mb. Available Physical Memory After Open=167207.62 Mb. Total Physical Memory=196573.38 Mb.

(2020-10-29 07:30:05) Information: Attempted to load the document without data.

(2020-10-29 07:30:05) Information: The document was loaded successfully.

(2020-10-29 07:30:05) Information: Document was opened successfully

(2020-10-29 07:30:05) Information: Starting reload

(2020-10-29 07:30:05) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2020-10-29 07:30:05) Information: Waiting for the document log "\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw" to become available.. Check until 10/29/2020 7:30:35 AM

(2020-10-29 07:30:05) Information: The Source Document is being reloaded. DocumentPath=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw

(2020-10-29 07:30:05) Information: Found a document log. FileName=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw.log

(2020-10-29 07:30:05) Information: Writing documentLog to \\YQASE02\QVLogs\QDS Application Data Folder\1\Log\20201029\072911 - Model - Sales Performance\DocumentLog.txt

(2020-10-29 07:30:06) Information: Reloading.

(2020-10-29 07:30:07) Information: Reloading..

(2020-10-29 07:30:08) Information: Reloading...

(2020-10-29 07:30:09) Information: Reloading....

(2020-10-29 07:30:10) Information: Reloading.....

(2020-10-29 07:30:11) Information: Reloading......

(2020-10-29 07:30:12) Information: Reloading.......

(2020-10-29 07:30:13) Information: Reloading........

(2020-10-29 07:30:14) Information: Reloading.........

(2020-10-29 07:30:15) Information: Reloading..........

(2020-10-29 07:30:16) Information: Slow down logging. Log every <2> seconds.

(2020-10-29 07:30:16) Information: Reloading

(2020-10-29 07:30:18) Information: Reloading.

(2020-10-29 07:30:20) Information: Reloading..

(2020-10-29 07:30:22) Information: Reloading...

(2020-10-29 07:30:24) Information: Reloading....

(2020-10-29 07:30:26) Information: Reloading.....

(2020-10-29 07:30:28) Information: Reloading......

(2020-10-29 07:30:30) Information: Reloading.......

(2020-10-29 07:30:32) Information: Reloading........

(2020-10-29 07:30:34) Information: Reloading.........

(2020-10-29 07:30:36) Information: Reloading..........

(2020-10-29 07:30:38) Information: Slow down logging. Log every <10> seconds.

(2020-10-29 07:30:38) Information: Reloading

(2020-10-29 07:30:48) Information: Reloading.

(2020-10-29 07:30:58) Information: Reloading..

(2020-10-29 07:31:08) Information: Reloading...

(2020-10-29 07:31:18) Information: Reloading....

(2020-10-29 07:31:28) Information: Reloading.....

(2020-10-29 07:31:38) Information: Reloading......

(2020-10-29 07:31:48) Information: Reloading.......

(2020-10-29 07:31:58) Information: Reloading........

(2020-10-29 07:32:08) Information: Reloading.........

(2020-10-29 07:32:18) Information: Reloading..........

(2020-10-29 07:32:28) Information: Slow down logging. Log every <60> seconds.

(2020-10-29 07:32:28) Information: Reloading

(2020-10-29 07:33:28) Information: Reloading.

(2020-10-29 07:34:28) Information: Reloading..

(2020-10-29 07:35:28) Information: Reloading...

(2020-10-29 07:36:28) Information: Reloading....

(2020-10-29 07:37:28) Information: Reloading.....

(2020-10-29 07:38:28) Information: Reloading......

(2020-10-29 07:39:28) Information: Reloading.......

(2020-10-29 07:40:28) Information: Reloading........

(2020-10-29 07:41:28) Information: Reloading.........

(2020-10-29 07:42:28) Information: Reloading..........

(2020-10-29 07:43:28) Information: Slow down logging. Log every <300> seconds.

(2020-10-29 07:43:28) Information: Reloading

(2020-10-29 07:45:43) Information: The Source Document reload complete. DocumentPath=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw

(2020-10-29 07:45:43) Information: Memory Allocation Delta for this file=2941.66 Mb. Available Physical Memory Before Reload=167207.77 Mb. Available Physical Memory After Reload=163233.01 Mb. Total Physical Memory=163233.01 Mb.

(2020-10-29 07:45:44) Error: The Source Document was NOT reloaded successfully. DocumentPath=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw.

(2020-10-29 07:45:44) Information: Closing the document.

(2020-10-29 07:45:45) Information: Closed the QlikView Engine successfully. ProcessID=4188

(2020-10-29 07:45:49) Error: The task "Model - Sales Performance" failed. Exception:

(2020-10-29 07:45:49) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=\\YQASE02\QlikView\2.DataModels\1.Application\Sales Performance Model.qvw.

(2020-10-29 07:45:49) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2020-10-29 07:45:49) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2020-10-29 07:45:49) Error: --- End of inner exception stack trace ---

(2020-10-29 07:45:49) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2020-10-29 07:45:49) Error: --- End of inner exception stack trace ---

(2020-10-29 07:45:49) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2020-10-29 07:45:49) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2020-10-29 07:45:50) Information: Task Execute Duration=00:16:38.9054470

(2020-10-29 07:45:50) Information: Sending Alert mail

(2020-10-29 07:45:50) Warning: No mailaddress found. Recipient=Vidyarani.Hingamire@atoz.com
(2020-10-29 07:45:50) Warning: Dillon.soni@atoz.com

(2020-10-29 07:45:50) Information: TaskResult.status=Finished

(2020-10-29 07:45:54) Information: Notifying all triggers of new state:FinishedWithErrors

(2020-10-29 07:45:54) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2020-10-29 07:45:58) Information: Saving Task Result

Please can anyone help me on this asap.

Any leads will be greatly appreciated.

Thanks and Regards,

Vidyarani

Re: Qlikview Tasks Failing

dplr-rn — Thu, 29 Oct 2020 18:49:12 GMT

this seems to be log from the publisher.

to get details of what failed we need the document log of the qvw which failed . generally will be in same location as qvw

Re: Qlikview Tasks Failing

vidyarani — Thu, 29 Oct 2020 21:09:05 GMT

Hi Dilip,

Thanks for the response.

It says General script error in document log file.

Any idea why this happens?. This is been happening quiet often for most of the tasks.

Please do let me know if you need any additional info ?

Thanks and Regards,

Vidyarani

Re: Qlikview Tasks Failing

Kushal_Chawda — Thu, 29 Oct 2020 22:13:16 GMT

@vidyarani general script errors occurs for many reasons which are not fixed. I would suggest to google Qlik general scrip error and look at the posts and pick if it is similar to your problem. or try to provide document reload log file.

Generally I have observed this issue while storing QVD and at the same time while that QVD is getting read by another qvw file. So try to change the schedule a bit and see if it works.

topic Re: Qlikview Tasks Failing in QlikView

Qlikview Tasks Failing

Re: Qlikview Tasks Failing

Re: Qlikview Tasks Failing

Re: Qlikview Tasks Failing