Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Section Access Reload from QVD fails

Hi,

I'm trying to reload a Section Access table from a QVD that's generated by another QV app. This other app contains nothing more than the following script:

SA_Accounts:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, DEPT
ADMIN, Admin, Admin,
USER, Peter, Peter, ZSW
USER, Ilse, Ilse, WSZ
];
STORE SA_Accounts INTO SA_Accounts.qvd (qvd);

SA_Depts:
LOAD * INLINE [
DEPT, TEXT
ZSW, Department Z
WSZ, Department W
];
STORE SA_Depts INTO SA_Depts.qvd (qvd);



The Reload script in the main app looks like this:

Section Access;
LOAD [ACCESS],
[USERID],
[PASSWORD],
DEPT
FROM SA_Accounts.qvd (qvd);

Section Application;
Star is *;
Directory;
LOAD DEPT,
TEXT
FROM SA_Depts.qvd (qvd);



Executing this script will generate a General Script Error (?). Apparently the script crashes on the Section Access LOAD statement.
See failing QVW and both QVDs in attachment.

What am I doing wrong here? BTW I'm running QVD9SR4.

Kr, Peter

Tags (2)
8 Replies
terjeknappen
Contributor

Section Access Reload from QVD fails

Hi Peter

Did you have any luck finding an answer?

I have a nearly identical script and the exact same problem.

regards

Terje Knappen

Section Access Reload from QVD fails

Hello Peter and Terje,

First, you must load all fields from external sources when in section access in uppercase:

Section Access;LOAD UPPER(ACCESS) AS ACCESS, UPPER(USERID) AS USERID, UPPER(PASSWORD) AS PASSWORD, UPPER(DEPT) AS DEPTFROM SA_Accounts.qvd (qvd);


Besides, try to load the section access table in an unoptimized form, changing the following line:

FROM SA_Accounts.qvd (qvd) WHERE 1=1;


See if that helps.

terjeknappen
Contributor

Section Access Reload from QVD fails

Thanks Miguel!

Unoptimized form solved my problem!

/Terje

Not applicable

Section Access Reload from QVD fails

Thanks Miguel, it solved my problem too..

-Kiran

Not applicable

Re: Section Access Reload from QVD fails

Thanks Miguel, it solved my problem too..

-Kiran

andrea_monico
New Contributor II

Re: Section Access Reload from QVD fails

Thanks Miguel!
Andrea

Not applicable

Re: Section Access Reload from QVD fails

Hi Miguel!

My case it's a little more serious. My app crashes when I enable the reduction data. I'm not loading the section access from a QVD, I wrote the section access in the qvw:

Section Access;

Star is *;

LOAD * INLINE [

    ACCESS,   PASSWORD, NTNAME,                                 USERID,  COD_GRUPO

    ADMIN,    ADMIN,                  *,                                          ADMIN,      *

    USER,     *,                  ALTENBURG\QLIKVIEW.ADMIN,           *,         1

    USER,     *,                  ALTENBURG\DIETMAR.PISKE,             *,         1      

    USER,     *,                  ALTENBURG\EDUARDO.CUCO,            *,         2

    USER,     *,                  ALTENBURG\FABIO.SIMON,                 *,         1   

    USER,     *,                  ALTENBURG\CRIS,                               *,         2   

    USER,     *,                  ALTENBURG\JACQUELINE.GONCALVES, *,         2       

    USER,     *,                  ALTENBURG\JACIARA.WERKA,             *,         2           

    USER,     *,                  ALTENBURG\JOSE.JUNIOR,                   *,         5

    USER,     *,                  ALTENBURG\FERNANDO.DALRI,             *,         4   

    USER,     *,                   ALTENBURG\GLAUCIO.GIL,                    *,         2

    USER,     *,                  ALTENBURG\EDGARD.MACHADO,          *,         4   

    USER,     *,                  ALTENBURG\ROBERT.BERTHIER,           *,         5       

];

Section Application;

What should I do? May you help me?

Not applicable

Re: Section Access Reload from QVD fails

Hi Eduardo , If you are using NTNAME you dont need a Password and UserID because the NTNAME will authenticate the user. Please try Like Below:

Section Access:

STAR is * ;

LOAD * INLINE [

ACCESS , NTNAME , COD_GRUPO

] ;

Please make sure check the "Initial Data reduction by Section Access" option on Document Properties --> Opening Tab

Community Browser