Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Hope someone can help me with this problem.
I recently implmeneted section access for a document and now I get the following error message when trying to run scheduled reload:
The task "MO Sales Application.qvw" failed. Part
of the log file follows:
25.07.2012 13:16:48 Error Document open call failed. The document might require
username and password.
25.07.2012 13:16:48 Error The document failed to open.
25.07.2012 13:16:48 Error Document could not be opened
25.07.2012 13:16:48 Error The task "MO Sales 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\Active\MO Sales 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)
I have seen from other post that I might have to include service name in the section access logic in the document but I am not sure how this should be done.
Here is the section access statement:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, SALESOFFICE
ADMIN, XXXX\MKFJ,NMS01
ADMIN, XXXX\MKFJ,UMS01,
];
Section Application;
There are 4 services running:
QMS@Server
QVS@Server
QVWS@Server
What service should be included in section access statement and what would that look like?
Thanks.
Hi,
You have to reload in order to get the section access work with the new changes. You don't need to specify user or password as long as the service account is added to this section access in this document, this should open just fine.
Hope that helps.
Miguel
Hi,
Go to the Windows Services console (Windows button, Run, services.msc) and check the account the QlikView services are running under. Say this account is XXXX\QVADMIN. You must add this account to the NTNAME field as ADMIN in the section access table, leaving a blank in the reduction field so it can read all records:
LOAD * INLINE [
ACCESS, NTNAME, SALESOFFICE
ADMIN, XXXX\QVADMIN
ADMIN, XXXX\MKFJ, NMS01
ADMIN, XXXX\MKFJ, UMS01
];
Hope that helps.
Miguel
Hi,
Ok. I found the correct services name and included into the statement as you mention above.
The service shows in small letters such as XXXX/qvadmin but I entered it as XXXX/QVADMIN.
Still I get the same error message.
I see that there is a section access part under User Documents -> Reload that I have left empty.
Does it have to be a user name and password in this section?
Hi,
You have to reload in order to get the section access work with the new changes. You don't need to specify user or password as long as the service account is added to this section access in this document, this should open just fine.
Hope that helps.
Miguel
Thanks for your quick and good response!