topic Re: Section Access Document Open Fails From QVS Auto-Reload in QlikView

Section Access Document Open Fails From QVS Auto-Reload

cranium144 — Tue, 13 Jan 2015 12:40:26 GMT

I've been able to get Section Access to work. When I am using QV to edit the dashboard, it reloads just fine. When QVS performs a reload, I received an error. It's something about the username and password, which I thought I had set correctly. All the other non Section Access documents reload just fine through QVS. The error is below:

The task "Outside Sales - TEST.qvw" failed. Part of the log file follows:

1/6/2015 3:20:43 PM Error Document open call failed. The document might require username and password.
1/6/2015 3:20:43 PM Error The document failed to open. Bad Username and password is the most likely cause of this problem.
1/6/2015 3:20:44 PM Error Document could not be opened
1/6/2015 3:20:44 PM Error The task "Outside Sales - TEST.qvw" failed. Exception: QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: D:\Documents\Outside Sales - TEST.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)

Re: Section Access Document Open Fails From QVS Auto-Reload

Gysbert_Wassenaar — Tue, 13 Jan 2015 13:08:23 GMT

Did you enable the option Section Access on the Reload tab for the document in the QMC and enter a user name and password?

Re: Section Access Document Open Fails From QVS Auto-Reload

cranium144 — Tue, 13 Jan 2015 13:15:10 GMT

Yes. I have tried domain\username and just username. I receive the same error.

Re: Section Access Document Open Fails From QVS Auto-Reload

Gysbert_Wassenaar — Tue, 13 Jan 2015 13:23:14 GMT

If you're using NT security you may have to include the service account the QDS service runs as in the section access table. At least that's what these three discussion suggest:

Re: Section Access Document Open Fails From QVS Auto-Reload

DanielCM — Thu, 14 Mar 2019 18:25:29 GMT

How can I fix this issue, I have a sectin access and I include the NT Administrator account bu still having the issue.

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, GROUP
ADMIN, MXRITQKV11\DAN, A
ADMIN, MXRITQKV11\ADMINQVIEW A
ADMIN, TEVACORP\DCORDOVA, A
ADMIN, TEVACORP\PRODRIGUEZLONGHI, A
USER, TEVACORP\SCORDOBA, B
USER, TEVACORP\NLODOLA02, A
USER, TEVACORP\MCERDEIRA, A
USER, TEVACORP\LFRUGONE, A
USER, TEVACORP\PZANATTA, A
USER, TEVACORP\VPLEON, B
USER, TEVACORP\VHERNANDEZ03, B
USER, TEVACORP\HINFANTEPORTILLO, A
];
Section Application;

LOAD * INLINE [
GROUP, SH00, SH01, SH02, SH03, SH05, SH06, SH07, SH08, SH10, SH11
A, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
B, 1, 0, 1, 1, 0, 1, 1, 0, 1, 1
];

It's the first one on the section access table