topic Re: Section access load from external table fails in QlikView

Section access load from external table fails

Thu, 15 Sep 2011 16:57:20 GMT

I’ve encountered a bizarre problem with section access in QV 10 while building a simple application.

If I load the section access as inline it works just fine:

Section Access;LOAD * INLINE [
    ACCESS, USERID, PASSWORD
    Admin, rfry, password
    User, 17, password
];Section Application;

However, if I attempt to load the data into a separate external table, and then load that table to handle section access it doesn’t recognize the user ID, and I get locked out of the application.

tmpSectionAccess: LOAD * INLINE [
    ACCESS, USERID, PASSWORD
    Admin, rfry, password
    User, 17, password
];

Section Access;LOAD
    ACCESS,
    USERID,
    PASSWORD

Resident tmpSectionAccess;

Section Application;
Drop Table tmpSectionAccess;

The same issue happens regardless if I load the source table as inline, or from another source table. I have a large number of users to create, and it makes a lot more sense to load them from a source table, but this issue is preventing it. I’ve done this successfully in the past using NT type section access, which is running successfully in 10. So I’m not sure what’s up.

Am I doing something wrong?

Section access load from external table fails

danielrozental — Thu, 15 Sep 2011 17:46:31 GMT

Fry escribió:
The same issue happens regardless if I load the source table as inline, or from another source table.

I don't get it, is inline working for you or not.

I think loading external tables in the section access will not work, doing a resident will not work either unless you change a field or rename it or something.

Section access load from external table fails

Thu, 15 Sep 2011 17:52:58 GMT

Inline works when it is used directly in the section access; statement.

When I load the table first, via inline or from a data source, and then load inside the section access; statement using the resident clause, section access does not work.

I've also just tried a NoConcatenate load inside the section access; section using the resident clause, and this also does not work.

Section access load from external table fails

danielrozental — Thu, 15 Sep 2011 17:56:32 GMT

Noconcatenate will have no effect if you don't change/add or remove any fields. Try doing that in the resident.

Section access load from external table fails

Thu, 15 Sep 2011 18:00:10 GMT

No effect:

tmpSectionAccess:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, FILLER
Admin, rfry, password, 1
User, 17, password, 1
];

Section Access;
NoConcatenate LOAD
ACCESS,
USERID,
PASSWORD
Resident tmpSectionAccess;
Section Application;

Drop Table tmpSectionAccess;

Section access load from external table fails

Fri, 02 Dec 2011 14:35:32 GMT

Does anybody has a solution for this?

I had same kind of problem here.

Thanks

Section access load from external table fails

Mon, 16 Jan 2012 21:14:08 GMT

Experiencing the same issue. Considering opening a ticket unless others already have.

Section access load from external table fails

Tue, 17 Jan 2012 03:21:41 GMT

Hi,

I've also observed such strange behavior during my past assignments. My find is that if we do LOAD Resident for section access then it doesn't work. Alternatively I use to store the table into text file and then load the data from that file in section access, it works fine. May be it could be a bug but I've seen such strange behavior in various versions of QV. I do something like below:

tmpSectionAccess:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, FILLER

Admin, rfry, password, 1

User, 17, password, 1

];

STORE tmpSectionAccess into tmpSectionAccess.txt (txt);

Drop Table tmpSectionAccess;

Section Access;

Directory;

LOAD [ACCESS],

[USERID],

[PASSWORD],

FILLER

FROM

tmpSectionAccess.txt

(txt, utf8, embedded labels, delimiter is ',', msq);

Section Application;

Re: Section access load from external table fails

Tue, 17 Jan 2012 07:38:39 GMT

here is some sample file i am attaching......might it helps you.....in this app see the properties of each sheet.

Re: Section access load from external table fails

msteedle — Wed, 31 Oct 2012 03:29:40 GMT

You can resolve this by either making all of the values in your initial table uppercase or using the upper function when you load each field during the resident load:

Section Access;
LOAD 
    Upper(ACCESS) as ACCESS, 
    Upper(USERID) as USERID, 
    Upper(PASSWORD) as PASSWORD
Resident tmpSectionAccess;
Section Application;

Just taking a guess--QlikView may automatically convert things to uppercase when you load data into a section access table, but it doesn't do that when loading something that was already in memory as mixed case. Might be a bug for a scenario they forgot to account for.

Re: Section access load from external table fails

IAMDV — Mon, 12 Nov 2012 18:57:32 GMT

I understand this is old thread but I thought I'll contribute my understanding...

You need to make the Reduction field and Section Access Fields in UPPER CASE (Field Values). Although, if you are using INLINE Load then QlikView implicitly converts them to UPPER CASE. But if you are loading from Excel / Databases / Other Sources/ Resident Load/ QVD Load then you need to make the field values to UPPER CASE.

As suggested by Michael Steedle it works fine when you change the field values to UPPER Case. I don't think it's a bug and infact it is right behaviour because your INLINE table still holds the Case Type (UPPER or lower) based on what you type. However, only when you load the Section Access table as INLINE Load then it will implicity convert the field values in UPPER case. It completely makes sense to me because whenever you are typing the values in INLINE Load for Section Access and if it doesn't work after typing because it's in lower case then it is very frustrating for the Developer. So QlikTech provided this implicit Case Conversion for Section Access but it still hold original Case Type outside Section Access.

Bottom line: As a thumb rule always do UPPER case wherever you are loading Section Access script and if you are using INLINE Load then you don't have to worry about changing the field values to UPPER case...anyway you can't do that as well!

I hope this makes sense.

Good luck!

Cheers,

www.QlikShare.com