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.
