topic Re: Section Access script fails - just show symbol? in QlikView

Section Access script fails - just show symbol?

Thu, 14 Jul 2016 19:42:35 GMT

I am attempting to add Section Access and my script seems to fail but does not say so. It just finishes in 1 second and shows a symbol => |, / or -

The user running the Reload is the ADMIN user below.

I added section access, reloaded script saved file and re-opened and it worked fine, but then just stopped working after reloading again..

We use a centralized txt file script as the script is used for several applications. Here is the Hidden Script and the table in the main script I am using for the data reduction.

Hidden Script

Section Access;

LOAD upper(ACCESS) as ACCESS, Upper(NTNAME) as NTNAME, Upper(SECLINK) as SECLINK

INLINE [

ACCESS, NTNAME, SECLINK

ADMIN, TUMAC\MyAccount, *

USER, DOMAIN\NTGroupName, *

USER, DOMAIN\USER1, 051

USER, DOMAIN\USER2, 014

USER, DOMAIN\USER2, 096

USER, DOMAIN\USER3, 081

USER, DOMAIN\USER4, 079

USER, DOMAIN\USER5, 081

USER, DOMAIN\USER5, 089

USER, DOMAIN\USER5, 028

USER, DOMAIN\USER5, 014

];

Section Application;

$(Include=\\SERVERNAME\Qlik\data\SalesLoad.txt);

Table from above SalesLoad.txt used for data reduction

Salesperson:

LOAD

SalesNo,

upper(num(SalesNo,'000')) as SECLINK,

SalesName,

SalesMgr,

DeptNo,

Active,

SlsLastName

FROM

[\\SERVERNAME\Qlik\data\StaticTables.xlsx]

(ooxml, embedded labels, table is Salesperson);

When I try and run from QMC schedule reload it gives me.

7/14/2016 12:12:06 PM Error Document open call failed. The document might require username and password.
7/14/2016 12:12:06 PM Error The document failed to open. Bad Username and password is the most likely cause of this problem.

Re: Section Access script fails - just show symbol?

krishnacbe — Thu, 14 Jul 2016 19:48:29 GMT

Hi,

Add the Service account which runs the QMC services into your section access script as ADMIN. Reload in desktop version and try to run in server (QMC).

Re: Section Access script fails - just show symbol?

Anonymous — Thu, 14 Jul 2016 19:49:33 GMT

The Login used for the publisher might not be present in your AUTH sheet. Make sure you add that user in the AUTH sheet and rerun the app manually first. then you can be able to reload through the task.

Re: Section Access script fails - just show symbol?

Thu, 14 Jul 2016 22:00:00 GMT

That worked. Added service accts and it updated through QMC.

Problems:

- Still cannot update manually through desktop client - updating through QMC slower...

Re: Section Access script fails - just show symbol?

krishnacbe — Fri, 15 Jul 2016 13:16:30 GMT

Great!!

For the problem statement the data size might be huge and the server capacity is not good. still you can verify your query and try to optimize the same.