Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Julianonext
Contributor
Contributor

Binary load with section access

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) 

4 Replies
agni_gold
Specialist III
Specialist III

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.

Julianonext
Contributor
Contributor
Author

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
agni_gold
Specialist III
Specialist III

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

Julianonext
Contributor
Contributor
Author

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;