Section Access

[tmumaw]

When I am using section access what user name and password do I use for the reload from QMC?

Thanks

[Clever_Anjos]

It would be simpler you add the user that runs the Distribution Service to your application Section Access

[tmumaw]

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
];

[Clever_Anjos]

Is DBO_QVREADERSVC the user that runs your Distribution Service?

[tmumaw]

Yes

[Clever_Anjos]

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

[Clever_Anjos]

[tmumaw]

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)

[Clever_Anjos · Accepted solution]

Let´s try one more thing

• Log in as DBO_QVREADERSVC 
• Open your app, add a textbox with =UPPER(OSUSER())
• Copy and paste this value this user into your Section Access script
• Copy and paste this value into Section Access section into QMC

[tmumaw]

Thanks....Got it to work.