Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I am using section access what user name and password do I use for the reload from QMC?
Thanks
Let´s try one more thing
It would be simpler you add the user that runs the Distribution Service to your application Section Access
Here is what I have. I have tried making DBO_QVREADERSVC the User on the QMC with no luck.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PROFITCENTER
ADMIN, DBO_QVREADERSVC,*
ADMIN, ADMTEM, *
USER, MUMAWT, 732271
];
Section Application;
LinkTable:
LOAD * INLINE [
PROFITCENTER, PROFIT CENTER
732271, 732271
];
Is DBO_QVREADERSVC the user that runs your Distribution Service?
Yes
So uncheck "Section access" box. It should be enough.
You can make a double check, logging as DBO_QVREADERSVC and trying to open your qvw using Qlikview Desktop
I removed it from the QMC and got this:
/8/2016 8:04:26 AM Error Document open call failed. The document might require username and password.9/8/2016 8:04:26 AM Error The document failed to open.9/8/2016 8:04:27 AM Error Document could not be opened9/8/2016 8:04:27 AM Error The task "Pesticide with section access" 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\Pesticides\Pesticides with section access.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)
Let´s try one more thing
Thanks....Got it to work.