topic Re: Is there a limit to the number of fields that can be used in Section Access in QlikView

Is there a limit to the number of fields that can be used in Section Access

andrewmcgough — Thu, 24 Sep 2015 04:05:01 GMT

Hi.

We have 9 fields as part of data reduction (Section Access). If I add a 10th field, the script fails (general script failure with no additional information provided in the logs)

I cant seem to find anything in the community that confirms this is a known limitation.

Thanks

Re: Is there a limit to the number of fields that can be used in Section Access

Digvijay_Singh — Thu, 24 Sep 2015 04:36:15 GMT

No such restriction mentioned in reference manual though, just attaching hic‌ blog in case it can help.

Data Reduction Using Multiple Fields

Re: Is there a limit to the number of fields that can be used in Section Access

tresB — Thu, 24 Sep 2015 04:42:40 GMT

Could you post your sample script?

Re: Is there a limit to the number of fields that can be used in Section Access

andrewmcgough — Mon, 28 Sep 2015 05:31:01 GMT

If you run the below it works without any error.

But, if more than 9 fields are listed the code fails, ie if you uncomment "FLAG_J". It doesn't matter which fields are included or excluded, but if there are more than 9 it fails. The logs don't give any reason for the failure.

Section Access;

Star is *;

AuthorisationTable:

LOAD Upper(Trim(ACCESS)) as ACCESS,
Subfield('domainA,domainB,domainC,',',')& '\' & Upper(NTNAME) as NTNAME,
Upper(NTNAME) as MAPPER,
FLAG_A,
FLAG_B,
FLAG_C,
FLAG_D,
FLAG_E,
FLAG_F,
FLAG_G,
FLAG_H,
FLAG_I
// FLAG_J
FROM
[Security Test.xlsx]
(ooxml, embedded labels, table is Reduction);

//----------Add Service Accounts to Section Access
Concatenate (AuthorisationTable)
LOAD * inline [ACCESS,NTNAME
ADMIN,domainA\zzzzzz
ADMIN,domainB\xxxxxxx
ADMIN,domainC\yyyyyyyy
];

//**********************************************************************************
Exit Script;
//**********************************************************************************

Re: Is there a limit to the number of fields that can be used in Section Access

tresB — Tue, 29 Sep 2015 08:07:56 GMT

I can't replicate the issue. I tried with 11 fields and it worked fine with me. Could you post your qvw with sample data that demonstrates the issue?

Re: Is there a limit to the number of fields that can be used in Section Access

swuehl — Tue, 29 Sep 2015 08:12:43 GMT

Is the issue also present when you remove the line

Star is *;

Re: Is there a limit to the number of fields that can be used in Section Access

Gabriel — Tue, 29 Sep 2015 13:48:51 GMT

Hi,

Have you try debugging each section of the script?

Comment out Star is *;

Comment out the last script this section

/----------Add Service Accounts to Section Access
Concatenate (AuthorisationTable)
LOAD * inline [ACCESS,NTNAME
ADMIN,domainA\zzzzzz
ADMIN,domainB\xxxxxxx
ADMIN,domainC\yyyyyyyy
];

It's possible that the issue is not the number of fields loaded

Re: Is there a limit to the number of fields that can be used in Section Access

andrewmcgough — Tue, 29 Sep 2015 22:55:06 GMT

Hi, If I remove the last section of code “Concatenate (AuthorisationTable)” the code works, but this still doesn’t explain why the original code fails

Re: Is there a limit to the number of fields that can be used in Section Access

andrewmcgough — Tue, 29 Sep 2015 22:58:43 GMT

If "Star is *" is removed the error still occurs.

Re: Is there a limit to the number of fields that can be used in Section Access

Gabriel — Wed, 30 Sep 2015 09:49:15 GMT

Hi,

Try and save this section into QVD and then bring it back in and concatenate it to AuthorisationTable'

/----------Add Service Accounts to Section Access
Concatenate (AuthorisationTable)
LOAD * inline [ACCESS,NTNAME
ADMIN,domainA\zzzzzz
ADMIN,domainB\xxxxxxx
ADMIN,domainC\yyyyyyyy
];

Re: Is there a limit to the number of fields that can be used in Section Access

avinashelite — Wed, 30 Sep 2015 09:52:36 GMT

Hi Andrew,

I feel the concatenation is poising the problem here, try like this have equal number of columns in the 2 table i.e. the concatenation table with dummy fields like 0 as FLAG_1 etc