Reload error on server works fine on Desktop

[rajni_batra]

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

[fosuzuki]

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?

[rajni_batra]

But my all other applications are getting reloaded except this one..

[fosuzuki]

The app has section access? If so, the login configured to run the QV services is listed in the section access?

[rajni_batra]

yes , in fact it is working fine with windows batch file.

i have QV 11 IR installed is this the reason? any bug

[#6]

Did you get any solution to this problem? I am facing the same issue.

[hallquist_nate]

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.

[#8]

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.