Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Peter
Did you have any luck finding an answer?
I have a nearly identical script and the exact same problem.
regards
Terje Knappen
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.
Thanks Miguel!
Unoptimized form solved my problem!
/Terje
Thanks Miguel, it solved my problem too..
-Kiran
Thanks Miguel, it solved my problem too..
-Kiran
Thanks Miguel!
Andrea
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?
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