topic Re: Section Access in QlikView

Section Access

Mon, 25 Jan 2016 10:32:18 GMT

Hi All,

I have an application with Section access. I have fields Access, NTNAME ,I have set an auto reload [scheduler] to it on server, when reloading the application I am getting an error field not found, is it because of section access, when application is reloading do I need to provide any user ID

Regards

John

Re: Section Access

t_chetirbok — Mon, 25 Jan 2016 10:40:50 GMT

Hi!

your section access need to look like

SECTION ACCESS;

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, root

ADMIN, x.yyy

ADMIN, t.chetirbok

];

Section Application;

Re: Section Access

Anonymous — Mon, 25 Jan 2016 10:41:19 GMT

What is your SA script??

Which field not found??

Re: Section Access

Anonymous — Mon, 25 Jan 2016 10:41:39 GMT

HI,

You need to add your server's NTNAME (with Access ADMIN) in the section access.

Kind regards

Re: Section Access

swuehl — Mon, 25 Jan 2016 10:42:56 GMT

Have a look at the document log to see which field can't be found or the location in script where the error occurs.

You don't need to provide a USERID, but take care that you are always having access to credentials to open the QVW, to prevent getting locked out, hence an additional USERID / PASSWORD might be a good idea.

Re: Section Access

Mon, 25 Jan 2016 10:54:19 GMT

Thanks Stephen, So your saying that , even we have section access in the application, when the time of application auto reload it will not give a prompt for user id, only I need User id when the application in access point. is my understanding is correct?

Regards

John

Re: Section Access

PradeepReddy — Mon, 25 Jan 2016 11:03:58 GMT

you have to provide the ADMIN ID and Password,

QMC-->Documents--> Select the Application-->Reload Tab--> Section Access(Bottom)

If u already provided this info, see the log for the error message

Re: Section Access

swuehl — Mon, 25 Jan 2016 11:05:56 GMT

The QV service account on the server needs to be able to open the document for reloading, so this account should be part of your section access table, too.

But I don't think this will result in a 'field not found', if this account is not added to section access, so I think you are experiencing a different issue.