Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
omyahamburg
Creator II
Creator II

qvw with section access

Hi All

I have several qvw with section access which are running fine.

Also the automatic reload via management console works fine.

Now I created a new qvw where I copied the same section access details in my hidden script.

Opening the qvw with the desktop version and relaoding works perfect.

But the automatic reload via the management console does not work.

Strange, because both - server and desktop qlik installations are running on the same computer.

BTW, I have updated the machine with both the latest version von qlik, server and desktop version.

Thanks for your help.

Joerg

10 Replies
Gysbert_Wassenaar

Make sure the service account QVS runs as is defined as ADMIN in Section Access.


talk is cheap, supply exceeds demand
omyahamburg
Creator II
Creator II
Author

The section access loads this:

Section Access;LOAD * INLINE [
    ACCESS, NTNAME, GROUP
    Admin, EMEA\klikjo1, ADMIN
     Admin, EMEA\bargmth1, ADMIN
  
]
;Section Application;star is *;


LOAD * INLINE [
    GROUP, Verkäufer
    ADMIN, *
   
]
;

And the service is running under EMEA\klikjo1.

service.png

Gysbert_Wassenaar

As far as I know the level needs to be all capitals and I think the NTNAME too. Try

Section Access;

LOAD * INLINE [
    ACCESS, NTNAME, GROUP
    ADMIN, EMEA\KLIKJO1,
    ADMIN, EMEA\BARGMTH1, ADMIN

edit: try leaving the reduction field blank so it can read all records


talk is cheap, supply exceeds demand
omyahamburg
Creator II
Creator II
Author

Acc. to my experience there is no difference.

Also all my other apps with same NTNAMEs are running fine for automatic reload.

I gave it a try, but reload fails also if in capitals.

markodonovan
Specialist
Specialist

Hi Joerg,

Silly question but have you check that there isn't a section access user already setup in the reload task\qds settings.

Thanks

Mark

Task reload

QDS settings (System - Setup - Distribution settings)

omyahamburg
Creator II
Creator II
Author

Mark, there are no pictures attached.

markodonovan
Specialist
Specialist

Hi Joerg,

I pasted the images before.  Hopefully this time I added them correctly below:

Task reload

task_reload.PNG

QDS settings (System - Setup - Distribution settings)

qds_sectionaccess.PNG

omyahamburg
Creator II
Creator II
Author

Hi Mark

Yes, the reload is enabled.

Where do I find "QDS settings (System - Setup - Distribution settings)" ?

I only have this:

setup.png

Edit:

I found the error. One of the paths in my script was a different one in our network.

Although the machine EMEA\klikjo1 was able to reload (or any other) from desktop,

QMC was not able to reload.

Which is strange for me, as all Qlik services are running under EMEA\klikjo1

and this user has definetively access.

markodonovan
Specialist
Specialist

Hi Joerg,

I think this is because I have a publisher license on the server.

I'll see if I can get a screenshot on a server without publisher.

You could try settings the 'Generate logfile' option on in Settings-Document Settings - General tab.

To see if there are any errors logged when you reload.

Also the server logfiles in C:\ProgramData\QlikTech\QlikViewServer such as the Sessions\Events_*.log files might show an error.

If you can remove and sensitive info feel free to attachment the doc and I can have a quick look at it or email it to info@practical-qlik.com.

Thanks

Mark