Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

cranium144
Contributor

Section Access Document Open Fails From QVS Auto-Reload

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)

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

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:


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
cranium144
Contributor

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

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

MVP & Luminary
MVP & Luminary

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

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:


talk is cheap, supply exceeds demand
DanielCM
New Contributor

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

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