Can't reload application in Management console with section access.

[#1]

Hi,

I face an issue with section access:

My application can't be reloaded in management console (Only way in production, no QV desktop).

If section access script is commented, then the application works and can be reloaded.

In attached file you can find my section access script, and the security file (user who runs QV services is DOMAINE\qvservice)

Here is the error displayed in the management console.

01-31 10:55:24) Information: Starting task blabla'. Id:e8226afe-d4d2-4086-9cc6-9c28d0b5d247. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2013-01-31 10:55:24) Information: Entering Task Execution.

(2013-01-31 10:55:24) Information: ClusterID=1

(2013-01-31 10:55:24) Information: QDSID=67e5159d-9ede-a817-9e94-8ef08b0cd72d

(2013-01-31 10:55:24) Information: TaskID=e8226afe-d4d2-4086-9cc6-9c28d0b5d247

(2013-01-31 10:55:24) Information: MaxRunTime=06:00:00

(2013-01-31 10:55:24) Information: MachineName=

(2013-01-31 10:55:24) Information: Max attempts:1

(2013-01-31 10:55:24) Information: Current Attempt=0

(2013-01-31 10:55:24) Information: Task Dependencies are OK

(2013-01-31 10:55:24) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2013-01-31 10:55:24) Information: Opening "D:\...\....qvw"

(2013-01-31 10:55:24) Information: Allocating new QlikView Engine. Current usage count=0 of 3 (of type non-reader).

(2013-01-31 10:55:24) Information: Max retries:5

(2013-01-31 10:55:24) Information: Attempt:01

(2013-01-31 10:55:25) Information: Allocated QlikView Engine successfully. Current usage count=1 of 3 (of type non-reader). Ticket number=206.

(2013-01-31 10:55:25) Information: Loading document "D:\...\....qvw" (8.81 Mb)

(2013-01-31 10:55:26) Error: Document open call failed. The document might require username and password.

(2013-01-31 10:55:26) Information: Attempted to load the document without data.

(2013-01-31 10:55:26) Error: The document failed to open. Bad Username and password is the most likely cause of this problem.

(2013-01-31 10:55:26) Information: Loading. LoadTime=00:00:01.0140390

(2013-01-31 10:55:26) Information: Closed the QlikView Engine successfully. ProcessID=12232

(2013-01-31 10:55:26) Error: Document could not be opened

(2013-01-31 10:55:26) Information: Closed the QlikView Engine successfully. ProcessID=12232

(2013-01-31 10:55:26) Information: Failed to check in document: D:\...\....qvw.qvw

(2013-01-31 10:55:26) Error: The task ".qvw" failed. Exception:

(2013-01-31 10:55:26) 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: D:\...\....qvw

(2013-01-31 10:55:26) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-01-31 10:55:26) Error:    --- End of inner exception stack trace ---

(2013-01-31 10:55:26) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-01-31 10:55:26) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-01-31 10:55:26) Error:    --- End of inner exception stack trace ---

(2013-01-31 10:55:26) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-01-31 10:55:26) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2013-01-31 10:55:26) Information: Task Execute Duration=00:00:02.1528828

(2013-01-31 10:55:26) Information: TaskResult.status=Finished

(2013-01-31 10:55:26) Information: Notifying all triggers of new state:FinishedWithErrors

(2013-01-31 10:55:26) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2013-01-31 10:55:26) Information: Saving Task Result

It works on my developpment environment, but in production...

Any Idea? Help from community will be very appreciated !

[karthickv]

David ,

Pls check whether your absolute path for the excel document (Prod environment) is correct.

Karthick V.

[#3]

Hi Karthick, thanks for your help.

I deployed the same application, with '//' at every line of section access script, and it runs successfully -> So it confirms that my problem is located on section access.

On the generated log, i can see the following line :

28/12/2012 16:53:53: 0005  SET pathSecu='D:\MYFOLDER\SECURITY\'

which is the correct path of the xls security file.

Maybe you were on a false way becaus I change the log, to avoid showing path & name of my applications.

Any other idea ?

Thanks for your help

[karthickv]

Welcome, David ..

Whenever tasks run fine in Development QEMC and we(my team) face a reload failure in the Production QEMC, the first thing we will check for is the Path ... That is wat i was trying to tell you .. Anyways happy to hear that your problem has been solved ..

If you find it as a helpful or correct answer, you can just  mention it in the LEGENDS (on right top below bookmarked by) , so that it would be encouraging  ..

Karthick V.

[#5]

Oh Actually my problem is not solved ! I just find a way to check if it was a path issue and confirm that issue is located on section access.

[#6]

I had same problem with my reports and after few hours of google, i found this on a forum:

"The account that should be entered into the section access is the account of the “Distribution Service” (your screenshot shows “QlikView Server”)"

you can find Distribution Service in Control Panel\All Control Panel Items\Administrative Tools\Services

there, you must enter same user as secction acces admin.

It worked for me

Let us know if it works for you too.

[#7]

Else,

You can just add the user account of the Distribution service to your section access script.

But there is an option in the Reload tab of the QMC to add the service account which can be used to run the task.You can add the account which has access to the QVW file in this tab and run the report.

Try it out and let us know if it worked.

[#8 · Accepted solution]

Hi All,

Thanks for your help.

I find the solution of my problem :

I was using 2 Qlikview server, 1 in dev & 1 in production, and account services are not the same.

I added account of service from production in section access table of developpement, reload it, and after deploying in production it was OK.

Actually the problem was that the qvw delivered was already restricted.

Thanks alls