Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have a problem to complete QlikView Task complete in QMC. We are getting the error as below (log file )
We followed the approaches found in Qlik Community related to the error , but we are failed to fix .
Someone from Qlik support team help us to fix this issue.
(01/12/2023 12:50:16) Information: DistributeTask[90671fb9-60b9-4d8e-843c-5f1c2eb675bb] ("ETL02_TransactionAnalysis"): TryStart - Starting task. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c. ExecID:c8fa664f-4a6b-40ba-97c6-309fd52cbce6
(01/12/2023 12:50:16) Information: Entering Task Execution.
(01/12/2023 12:50:16) Information: ClusterID=1
(01/12/2023 12:50:16) Information: QDSID=75c55e01-c75e-7a05-9d66-3ef8b461d6b7
(01/12/2023 12:50:16) Information: TaskID=90671fb9-60b9-4d8e-843c-5f1c2eb675bb
(01/12/2023 12:50:16) Information: ExecID=c8fa664f-4a6b-40ba-97c6-309fd52cbce6
(01/12/2023 12:50:16) Information: MaxRunTime=1.00:00:00
(01/12/2023 12:50:16) Information: MachineName=vmneurqlkprd01
(01/12/2023 12:50:16) Information: Task execution max attempts=1
(01/12/2023 12:50:16) Information: Task execution current attempt=1
(01/12/2023 12:50:16) Information: Task Dependencies are OK
(01/12/2023 12:50:16) Information: The task "ETL02_TransactionAnalysis" is starting
(01/12/2023 12:50:16) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(01/12/2023 12:50:16) Information: Opening "D:\QvSourceDocs\ROOT\ETL02\ETL02_0_TransactionAnalysis.qvw"
(01/12/2023 12:50:16) Information: Allocating new QlikView Engine. Current usage count=1 of 4 (of type non-reader).
(01/12/2023 12:50:16) Information: Max retries:5
(01/12/2023 12:50:16) Information: Attempt:01
(01/12/2023 12:50:17) Information: Opened the QlikView Engine successfully. ProcessID=3608484
(01/12/2023 12:50:17) Information: Allocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=522.
(01/12/2023 12:50:17) Information: Loading document "D:\QvSourceDocs\ROOT\ETL02\ETL02_0_TransactionAnalysis.qvw" (0.27 Mb)
(01/12/2023 12:50:17) Information: Physical FileSize=0.27 Mb. Memory Allocation Delta for this file=8.55 Mb. Available Physical Memory Before Open=257295.61 Mb. Available Physical Memory After Open=257271.64 Mb. Total Physical Memory=393215.55 Mb.
(01/12/2023 12:50:17) Information: Attempted to load the document without data.
(01/12/2023 12:50:17) Information: The document was loaded successfully.
(01/12/2023 12:50:17) Information: Document was opened successfully
(01/12/2023 12:50:17) Information: Starting reload
(01/12/2023 12:50:17) Information: The Source Document is being reloaded. DocumentPath=D:\QvSourceDocs\ROOT\ETL02\ETL02_0_TransactionAnalysis.qvw
(01/12/2023 12:50:18) Information: Reloading.
(01/12/2023 12:50:19) Information: Reloading..
(01/12/2023 12:50:20) Information: Reloading...
(01/12/2023 12:50:21) Information: Reloading....
(01/12/2023 12:50:22) Information: Reloading.....
(01/12/2023 12:50:23) Information: Reloading......
(01/12/2023 12:50:24) Information: Reloading.......
(01/12/2023 12:50:25) Information: Reloading........
(01/12/2023 12:50:26) Information: Reloading.........
(01/12/2023 12:50:27) Information: Reloading..........
(01/12/2023 12:50:28) Information: Slow down logging. Log every <2> seconds.
(01/12/2023 12:50:28) Information: Reloading
(01/12/2023 12:50:30) Information: Reloading.
(01/12/2023 12:50:32) Information: Reloading..
(01/12/2023 12:50:34) Information: Reloading...
(01/12/2023 12:50:36) Information: Reloading....
(01/12/2023 12:50:38) Information: Reloading.....
(01/12/2023 12:50:40) Information: Reloading......
(01/12/2023 12:50:42) Information: Reloading.......
(01/12/2023 12:50:44) Information: Reloading........
(01/12/2023 12:50:46) Information: Reloading.........
(01/12/2023 12:50:48) Information: Reloading..........
(01/12/2023 12:50:50) Information: Slow down logging. Log every <10> seconds.
(01/12/2023 12:50:50) Information: Reloading
(01/12/2023 12:51:00) Information: Reloading.
(01/12/2023 12:51:11) Information: Reloading..
(01/12/2023 12:51:21) Information: Reloading...
(01/12/2023 12:51:31) Information: Reloading....
(01/12/2023 12:51:41) Information: Reloading.....
(01/12/2023 12:51:51) Information: Reloading......
(01/12/2023 12:52:01) Information: Reloading.......
(01/12/2023 12:52:11) Information: Reloading........
(01/12/2023 12:52:21) Information: Reloading.........
(01/12/2023 12:52:31) Information: Reloading..........
(01/12/2023 12:52:41) Information: Slow down logging. Log every <60> seconds.
(01/12/2023 12:52:41) Information: Reloading
(01/12/2023 12:53:41) Information: Reloading.
(01/12/2023 12:54:41) Information: Reloading..
(01/12/2023 12:55:41) Information: Reloading...
(01/12/2023 12:56:41) Information: Reloading....
(01/12/2023 12:57:42) Information: Reloading.....
(01/12/2023 12:58:42) Information: Reloading......
(01/12/2023 12:59:42) Information: Reloading.......
(01/12/2023 13:00:42) Information: Reloading........
(01/12/2023 13:01:42) Information: Reloading.........
(01/12/2023 13:02:42) Information: Reloading..........
(01/12/2023 13:03:42) Information: Slow down logging. Log every <300> seconds.
(01/12/2023 13:03:42) Information: Reloading
(01/12/2023 13:05:46) Information: The Source Document reload complete. DocumentPath=D:\QvSourceDocs\ROOT\ETL02\ETL02_0_TransactionAnalysis.qvw
(01/12/2023 13:05:46) Information: Memory Allocation Delta for this file=123.07 Mb. Available Physical Memory Before Reload=257268.32 Mb. Available Physical Memory After Reload=249236.41 Mb.
(01/12/2023 13:05:47) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\QvSourceDocs\ROOT\ETL02\ETL02_0_TransactionAnalysis.qvw.
(01/12/2023 13:05:47) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
(01/12/2023 13:05:47) Information: Reload was aborted.
(01/12/2023 13:05:47) Information: Closing the document.
(01/12/2023 13:05:47) Information: Closing the document.
(01/12/2023 13:05:47) Warning: Document was forcibly closed. Clean close was not possible. Exception: System.NullReferenceException: Object reference not set to an instance of an object. || at QVBWrapper.Document.NiceCloseThread(ILogBucket i_LogBucket)
(01/12/2023 13:05:47) Information: Closed the QlikView Engine successfully. ProcessID=3608484
(01/12/2023 13:05:47) Error: The task "ETL02_TransactionAnalysis" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.ThreadPoolJobStillRunningException: Aborting reload. Error: QDSMain.TaskResult || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)
(01/12/2023 13:05:47) Information: Task Execute Duration=00:15:31.2586208
(01/12/2023 13:05:47) Information: Sending Alert mail
(01/12/2023 13:05:48) Information: Closed the QlikView Engine successfully. ProcessID=3608484
(01/12/2023 13:07:53) Warning: Failed to send mail to analytics@jato.com
(01/12/2023 13:07:53) Information: TaskResult.status=Finished
(01/12/2023 13:07:53) Information: Notifying all triggers of new state: "FinishedWithErrors"...
(01/12/2023 13:07:53) Information: Notifying all triggers of new state: "FinishedWithErrors" - Completed
Hi Vincent,
Sorry for late response.
With your solution, our issue got fixed and tasks reload completed successfully.
Thank you so much for the quick response to you both @vincent_ardiet_ and @Chip_Matejowsky
@Chip_Matejowsky, we will consider you below point about -129 error and look about that to avoid these issues further.