Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, We are using Qlik Sense and Qlik View. The tasks are setup in the Qlik View and monitoring by Qlik View QMC. Till Today morning around 6.40am our task getting successful. But from 6.50 am onwards the task getting failed, suddenly all the reloaded the job getting failed.
How to find the issue, exact root cause and where we need to find the logs. Because this is not related to any particular task. After 6.50 am all the reload task failed.
@Albert_Candelario Yes now not facing the issue. but sometime we are getting the issues like 1 or 2 task failed rarely. Below pasted the error message
Error: Document open call failed. The document might require username and password.
(7/9/2023 7:35:29 AM) Information: Attempted to load the document without data.
(7/9/2023 7:35:29 AM) Error: The document failed to open.
(7/9/2023 7:35:30 AM) Information: Closed the QlikView Engine successfully. ProcessID=181188
(7/9/2023 7:35:30 AM) Error: Document could not be opened
But next run, its working fine. don't what is the root cause for this issue.
This is usually a resource issue:
Error: Document open call failed. The document might require username and password.
Check - QlikView Publisher Task Failing With Error:Error D... - Qlik Community - 1711193
Cheers,
Albert
Hello@balajibc64
The first step would be to look in the task logs to see what error message is recorded. The below article explains how to get the QDS logs.
What version of QlikView are you using? Does a restart of the QlikView Services solve the issue? Restart of the Windows server?
@Maria_Halley Yes. After restart the server now its better. I can able to see the task logs in Qlik View QMC. But how to find the root cause ?
Because those task ran successfully, till 6.30 am. But after that same job getting failed. More over we have nearly 60 reload task .
@Maria_Halley Just wanted to highlight. from 7 AM onwards our task failed. At first alert to our email . and its shows the below error
6/22/2023 7:03:22 AM Error Document open threw an exception. Exception=The currently executing operation was aborted.
6/22/2023 7:03:23 AM Error The task "MPP\2.QVDGen\Q_055_FC_QGN_02.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 QVBWrapper.DocumentPool.Checkout(ILogBucket logBucket, eCheckoutMode checkoutMode, String fileName, Boolean clearAll, Boolean clearLocks, Boolean clearOneAndOnlyOnes, Boolean reduce, String variableName, String variableValue, AbortCallbackCheck abortCallbackCheck, String sectionAccessUsername, String sectionAccessPassword, DocumentRestoreMode documentRestoreMode, Boolean withData, Boolean forceQvbAllocation)
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)
6/22/2023 7:03:23 AM Error Task failed with exception. Exception=The currently executing operation was aborted.
Hello @balajibc64 ,
All the tasks failed? Maybe the file sever or the sever itself was not operational or facing a degradation in performance that lead to the tasks failures?
Cheers,
Albert
@Albert_Candelario Yes. After restart its working fine. But I can paste few logs details below.
6/22/2023 12:33:10 PM Warning The QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).
Also already pasted the logs above my first failure.
@Maria_Halley @Albert_Candelario Also Please suggest why this issue comes ?
The sourcedocument failed to save.. Exception=System.IO.FileNotFoundException: Could not find file '\\servername\QLIK\QlikviewPRD\SourceDocs\IOC\5.Apps\850777cc-0a3b-4ea7-ae7b-6bb8e3aed8cf_Commercial.qvw.tmp'.
Hello @balajibc64,
What kind of storage are you using?
Are the antivirus exclusions in place?
6/22/2023 12:33:10 PM Warning The QlikView Engine is Reloading, it will be killed (Please ignore logged warnings/errors about the kill).
Could you please add the complete log and mask any sensitive information you might consider.
Cheers,
Albert
@Albert_Candelario Sure. I will update the logs. Yes Microsoft Defender Antivirus we installed, and we exclude all the respective exe files related to Qlik.
Also Didn't understand storage are you using ? I mean you are asking about Cluster Storage. We have around 5 servers for all (including Qlik View, Qlik Sense, Qlik NPrinting) for those we are using common cluster storage.
About the storage I was referring it it is a NAS or a SAN or what kind of file server.
Microsoft defender exclusions might be a bit tricky sometimes, so please do not hesitate to double check that all their different components are excluding the paths you want to.
You can also run the ProcessMonitor to ensure that no other undesired software is interacting with such folders.
File Access and Process Monitoring - How to find l... - Qlik Community - 1712539
Cheers,
Albert