Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reload fails in task of qvw with section access

I was checking an option to protect my script with password . I followed the suggestion in this thread.

Password Protection with or without Section Access

but When i use the Section Access option and i want to reload the qvw using task in QMEC. What should be the section access code given the distribution service runs as domain1\user1 account. I just want to enable password protection and my qvw should reload same as before. Its just that no one should be able to open the qvw without entering password.

The reload is failing when i use Acess as ADMIN and password. I am using the below code in hidden script.

Section Access;

LOAD * INLINE [

    ACCESS, PASSWORD

    ADMIN,12345

];

Section Application;

1 Solution

Accepted Solutions
ToniKautto
Employee
Employee

Your section access definition is incomplete. It must contain USERID if you use PASSWORD. You must define int eh server task what user and password the reload should apply in the QVW.

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN,ADMIN,12345

];

If you have a QlikView Publisher license, the distributed QVW will not contain a script. In this scenario your protection is not needed.

View solution in original post

12 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

Have you tried outside the QMEC in QlikView Personal Edition?

Regards,

MB

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Put your entire script in a Hidden Script and password-protect just that (In Script Editor, see File->Create Hidden Script). Nothing else will change and you won't need Section Access. And in any case, Section Access is only able to hide your script from prying eyes by throwing each and every door shut, which may be a bit overkill...

Peter

Peter_Cammaert
Partner - Champion III
Partner - Champion III

BTW in QMC did you try entering this password again in the Username/Password fields (in the bottom left corner of the Reload tab, or - if you have a Publisher - in the Reload->Data Protection section of your Task definition)?

ashok1203
Creator II
Creator II

Hi, Can you try like below:

Section Access;

LOAD * INLINE [

    ACCESS, USER,PASSWORD

    ADMIN,ADMIN,12345

];

Section Application;

AAK
ToniKautto
Employee
Employee

Your section access definition is incomplete. It must contain USERID if you use PASSWORD. You must define int eh server task what user and password the reload should apply in the QVW.

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN,ADMIN,12345

];

If you have a QlikView Publisher license, the distributed QVW will not contain a script. In this scenario your protection is not needed.

ToniKautto
Employee
Employee

Have you tried that? It is not accurate syntax for QlikView. The user field is USERID, as I already mentioned below.

Anonymous
Not applicable
Author

Did you include Qlikview service account in Section access table?

ToniKautto
Employee
Employee

It is required in this scenario, as there is no reduction. The requirement is to add the user credentials in the task configuration.

Not applicable
Author

So if i use the Same user Name and password ( ADMIN,12345)  in qmec task username and password field will it work

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN,ADMIN,12345

];

Section Application;