topic Re: Section Access Reload from QVD fails in QlikView

Section Access Reload from QVD fails

Peter_Cammaert — Fri, 25 Jun 2010 11:37:11 GMT

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

Section Access Reload from QVD fails

TK_ — Mon, 06 Sep 2010 08:58:08 GMT

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

Miguel_Angel_Baeyens — Mon, 06 Sep 2010 09:31:13 GMT

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.

Section Access Reload from QVD fails

TK_ — Mon, 06 Sep 2010 10:26:48 GMT

Thanks Miguel!

Unoptimized form solved my problem!

/Terje

Section Access Reload from QVD fails

Tue, 27 Sep 2011 12:59:01 GMT

Thanks Miguel, it solved my problem too..

-Kiran

Re: Section Access Reload from QVD fails

Tue, 27 Sep 2011 12:59:15 GMT

Thanks Miguel, it solved my problem too..

-Kiran

Re: Section Access Reload from QVD fails

Anonymous — Fri, 19 Jul 2013 14:41:01 GMT

Thanks Miguel!
Andrea

Re: Section Access Reload from QVD fails

Wed, 22 Jan 2014 11:12:08 GMT

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?

Re: Section Access Reload from QVD fails

Wed, 22 Jan 2014 14:12:26 GMT

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