Discussion Board for collaboration related to QlikView App Development.
Hi all,
I had a server of 256 GB RAM.
When I am scheduling more than 6 tasks simultaneously through publisher, I am getting error like:
(2014-02-27 08:59:51) Information: Starting task 'Reload and Distribute of Persistency Dashboard.qvw'. Id:071c6bbc-44cb-48ee-82c0-28865dbe7db3. Triggered by 'TaskCompletedTrigger'. Id:02032bbc-fd3a-4b0c-9f98-45e4452510f9
(2014-02-27 08:59:51) Information: Entering Task Execution.
(2014-02-27 08:59:51) Information: ClusterID=1
(2014-02-27 08:59:51) Information: QDSID=5a02d6bd-e32c-b1e9-c3a4-d5f81c27cca7
(2014-02-27 08:59:51) Information: TaskID=071c6bbc-44cb-48ee-82c0-28865dbe7db3
(2014-02-27 08:59:51) Information: MaxRunTime=1.00:00:00
(2014-02-27 08:59:51) Information: Max attempts:1
(2014-02-27 08:59:51) Information: Current Attempt=0
(2014-02-27 08:59:51) Information: Task Dependencies are OK
(2014-02-27 08:59:51) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2014-02-27 08:59:51) Information: Opening "E:\QV Sales App\Applications\Persistency Dashboard.qvw"
(2014-02-27 08:59:51) Information: Allocating new QlikView Engine. Current usagecount=6 of 10
(2014-02-27 08:59:51) Information: Max retries:5
(2014-02-27 08:59:51) Information: Attempt:01
(2014-02-27 08:59:52) Information: Allocated QlikView Engine successfully. Current usagecount=6 of 10, Ticket=469
(2014-02-27 08:59:52) Information: Loading document "E:\QV Sales App\Applications\Persistency Dashboard.qvw" (104.27 Mb)
(2014-02-27 08:59:52) Error: Document open call failed. The document might require username and password.
(2014-02-27 08:59:52) Information: Attempted to load the document without data.
(2014-02-27 08:59:52) Error: The document failed to open.
(2014-02-27 08:59:53) Information: Closed the QlikView Engine successfully. ProcessID=5260
(2014-02-27 08:59:53) Error: Document could not be opened
(2014-02-27 08:59:53) Information: Closed the QlikView Engine successfully. ProcessID=5260
(2014-02-27 08:59:53) Information: Failed to check in document: E:\QV Sales App\Applications\Persistency Dashboard.qvw
(2014-02-27 08:59:53) Error: The task "Reload and Distribute of Persistency Dashboard.qvw" failed. Exception:
(2014-02-27 08:59:53) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: E:\QV Sales App\Applications\Persistency Dashboard.qvw
(2014-02-27 08:59:53) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-02-27 08:59:53) Error: --- End of inner exception stack trace ---
(2014-02-27 08:59:53) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2014-02-27 08:59:53) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-02-27 08:59:53) Error: --- End of inner exception stack trace ---
(2014-02-27 08:59:53) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2014-02-27 08:59:53) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2014-02-27 08:59:53) Information: Task Execute Duration=00:00:01.5444000
(2014-02-27 08:59:53) Information: TaskResult.status=Finished
(2014-02-27 08:59:53) Information: Notifying all triggers of new state:FinishedWithErrors
(2014-02-27 08:59:53) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2014-02-27 08:59:53) Information: Saving Task Result
Enhance you Hardware Config
Thanks Sujeet. . .
I had 256 GB of RAM; What hardware config needs to be enhanced now?
Hi,
How many qlikview engines have you configured for distribution.
The default is 4 try increasing this value.
Thanks,
Sanjeev