Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
A report reloads fine in desktop mode but fails in the server scheduler.
The log file shows the following:
7/4/2012 01:59:10.2629819 | Information | Starting task 'Final/Advance Energy Application.qvw'. Id:fe653f5b-3cc9-44d6-afeb-c9af3826a379. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c |
7/4/2012 01:59:10.2629819 | Information | Entering Task Execution. |
7/4/2012 01:59:10.2629819 | Information | ClusterID=1 |
7/4/2012 01:59:10.2629819 | Information | QDSID=23d4dc98-6fe2-e0e3-8eb1-c9190df7e4fa |
7/4/2012 01:59:10.2629819 | Information | TaskID=fe653f5b-3cc9-44d6-afeb-c9af3826a379 |
7/4/2012 01:59:10.2629819 | Information | MaxRunTime=06:00:00 |
7/4/2012 01:59:10.2629819 | Information | Max attempts:1 |
7/4/2012 01:59:10.2629819 | Information | Current Attempt=0 |
7/4/2012 01:59:10.2629819 | Information | Task Dependencies are OK |
7/4/2012 01:59:10.2941819 | Information | Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution. |
7/4/2012 01:59:10.2941819 | Information | Opening "D:\QLIKVIEW DEVELOPMENT\FINAL\APPLICATION\Advance Energy Application.qvw" |
7/4/2012 01:59:10.2941819 | Information | Allocating new QlikView Engine. Current usagecount=1 of 2 |
7/4/2012 01:59:10.2941819 | Information | Max retries:5 |
7/4/2012 01:59:10.2941819 | Information | Attempt:01 |
7/4/2012 01:59:11.1365819 | Information | Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=239 |
7/4/2012 01:59:11.1521819 | Information | Loading document "D:\QLIKVIEW DEVELOPMENT\FINAL\APPLICATION\Advance Energy Application.qvw" (13.92 Mb) |
7/4/2012 01:59:12.1661819 | Information | Loading. LoadTime=00:00:01.0296000 |
7/4/2012 01:59:12.6965819 | Error | Document open call failed. The document might require username and password. |
7/4/2012 01:59:12.6965819 | Information | Attempted to load the document without data. |
7/4/2012 01:59:12.6965819 | Error | The document failed to open. |
7/4/2012 01:59:13.3205819 | Information | Closed the QlikView Engine successfully. ProcessID=16832 |
7/4/2012 01:59:13.3205819 | Error | Document could not be opened |
7/4/2012 01:59:13.3205819 | Information | Closed the QlikView Engine successfully. ProcessID=16832 |
7/4/2012 01:59:13.3205819 | Information | Failed to check in document: D:\QLIKVIEW DEVELOPMENT\FINAL\APPLICATION\Advance Energy Application.qvw |
7/4/2012 01:59:13.3205819 | Error | The task "Final/Advance Energy Application.qvw" failed. Exception: |
QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: D:\QLIKVIEW DEVELOPMENT\FINAL\APPLICATION\Advance Energy Application.qvw
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)
7/4/2012 01:59:13.3361819 | Information | Task Execute Duration=00:00:03.0732000 |
7/4/2012 01:59:13.3517819 | Information | TaskResult.status=Finished |
7/4/2012 01:59:13.3517819 | Information | Notifying all triggers of new state:FinishedWithErrors |
7/4/2012 01:59:13.3517819 | Information | Notifying all triggers of new state:FinishedWithErrors - completed |
7/4/2012 01:59:13.3517819 | Information | Saving Task Result |
Thanks,
Rajni
The document might require username and password.
It seems like there is a permission issue. Does the login configured to run the QV services has permission to open the qvw?
But my all other applications are getting reloaded except this one..
The app has section access? If so, the login configured to run the QV services is listed in the section access?
yes , in fact it is working fine with windows batch file.
i have QV 11 IR installed is this the reason? any bug
Did you get any solution to this problem? I am facing the same issue.
You need to be sure to add the admin Section Access Account to the QV Server reload parameters. On the reload tab, that spot is at the bottom of the tab. I see that get missed periodically.
I solved this problem by adding the service account running the QV server to my session access table as the following example shows (I am using AD authentication).
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, NTDOMAINSID
...
ADMIN, <service_account_id>, <nt_domain_id>
];
Remember to reload the document before copying the QVW to the server so the new service account credential is in the document. Then, to verify it, go to QMC, go to Documents> Source Documents, and click the document task. Click the Reload tab. There is a "Open Document" button there. Click it to verify you have no errors. Then, run it as normal and it runs fine for me.
When I got errors, I either forgot to reload the document after the change or had spelling error on the service account ID.
Mine works without passing additional parameters, as Nate suggested.