topic Re: qvw with section access in QlikView

qvw with section access

omyahamburg — Tue, 28 May 2013 05:41:01 GMT

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

Re: qvw with section access

Gysbert_Wassenaar — Tue, 28 May 2013 08:02:53 GMT

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

Re: qvw with section access

omyahamburg — Tue, 28 May 2013 08:22:51 GMT

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.

Re: qvw with section access

Gysbert_Wassenaar — Tue, 28 May 2013 08:33:27 GMT

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

Re: qvw with section access

omyahamburg — Tue, 28 May 2013 08:42:26 GMT

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.

Re: qvw with section access

markodonovan — Tue, 28 May 2013 08:43:56 GMT

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)

Re: qvw with section access

omyahamburg — Tue, 28 May 2013 08:47:57 GMT

Mark, there are no pictures attached.

Re: qvw with section access

markodonovan — Tue, 28 May 2013 09:08:10 GMT

Hi Joerg,

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

Task reload

QDS settings (System - Setup - Distribution settings)

Re: qvw with section access

omyahamburg — Tue, 28 May 2013 10:31:33 GMT

Hi Mark

Yes, the reload is enabled.

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

I only have this:

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.

Re: qvw with section access

markodonovan — Tue, 28 May 2013 10:52:48 GMT

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

Re: qvw with section access

omyahamburg — Thu, 30 May 2013 06:07:31 GMT

Hi Mark

It is amazing, today the reload worked without error.

Thank for your help.

Joerg