topic Re: Binary load with section access in App Development

Binary load with section access

Julianonext — Sat, 16 Nov 2024 20:22:35 GMT

Hi All,

I have created a dimensional model in Qlik sense (server) that i would like to use to feed multiple apps using Binary Load. The Binary Load seems to go smoothly. However some of the apps that i'm building are in need of section Access. When i try and implement section acces either in the qvf that im conducting my binary load from or in the app that im loading Data to im getting an error from Qlik. The error is quite vague and doesn't detail were i should adapt my script. Can anyone help me out.

Section access script is fine worked in a previous app without binary load. The username that is refreshing the app is also in the section access as for the ,INTERNAL\SA_SCHEDULER .

Here ar some details on the error:

Unknown Error:

An error has occured. Connection with the Qliksense Engine has failed due to an unspecified reason. refresh the page or contact your system admin (me).

I'm currently running qliksenseserver 12.44.3 (november 2018 patch 2)

Re: Binary load with section access

agni_gold — Sat, 27 Jul 2019 20:30:39 GMT

Do you have section access in "dimensional model in Qlik sense"? because in binary load section access is also loaded in another app, and you are again applying for section access. this might be causing the problem.

Re: Binary load with section access

Julianonext — Sat, 27 Jul 2019 21:04:15 GMT

Hi Agni_gold thank you for your response.

At the moment I don't have section access implemented in my "dimensional
model" I'm only applying it In the app that I'm doing the binary load in.

Regards Juliano

Re: Binary load with section access

agni_gold — Sat, 27 Jul 2019 21:17:52 GMT

ok, so have you provided Admin access to Qliksense service account in you section access?

Re: Binary load with section access

Julianonext — Sun, 28 Jul 2019 21:14:16 GMT

Yes i've done that.

Here is an example of my section access script:

section access;

Authentication:

LOAD * inline [

ACCESS ,USERID , GROUP ,REDUCTION

USER ,domain\lBob3 , * , 020

USER ,domain\Bob2 , * , 030

USER ,domain\Bob , * , 040

ADMIN ,domain\qsadmin , * , *

ADMIN ,INTERNAL\SA_SCHEDULER , * , *

];

section application;