Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

Server reload problem with section access

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:

DSC@Server

QMS@Server

QVS@Server

QVWS@Server

What service should be included in section access statement and what would that look like?

Thanks.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Server reload problem with section access

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

4 Replies
MVP
MVP

Re: Server reload problem with section access

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

Not applicable

Re: Server reload problem with section access

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?

MVP
MVP

Re: Server reload problem with section access

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

Not applicable

Re: Server reload problem with section access

Thanks for your quick and good response!

Community Browser