topic Re: Access denied error while loading Section access script via Excel in Data Movement & Streaming

Access denied error while loading Section access script via Excel

Mounika4 — Wed, 19 Mar 2025 22:11:20 GMT

Hi ,

we are migrating dashboard from qlikview to qlikcloud

getting below error in qlik cloud while load below script

Section Access;

LOAD Access as ACCESS,
UserID as USERID,
Password as PASSWORD,
Cluster as CLUSTER,
Cluster_ABC as CLUSTER_ABC
FROM [lib://Migration shared space:DataFiles/SECTION_ACCESS1.xlsx]
(ooxml, embedded labels, table is [Acesso Cluster]);
Section Application;

can anyone pls help me on this

Thanks in advance!!

Re: Access denied error while loading Section access script via Excel

stascher — Mon, 01 Apr 2024 12:34:14 GMT

Can you show the load/query of the table containing the variable(s) you're reducing on?

I have experienced similar situation with a bizarre root cause; if the cases of the name of the variable being reduced on is the same in both the Section Access and Section Application, then it was necessary to wrap the variable in the Section Application with an Upper() function.