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

[andrewmcgough]

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

[Digvijay_Singh]

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

Data Reduction Using Multiple Fields

[tresesco]

Could you post your sample script?

[andrewmcgough]

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;
//**********************************************************************************

[tresesco]

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?

[swuehl]

Is the issue also present when you remove the line

Star is *;

?

[Gabriel]

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

[andrewmcgough]

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

[andrewmcgough]

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

[Gabriel]

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
];