topic Section Access Service Account Issue in QlikView

Section Access Service Account Issue

azmeerrehan — Mon, 21 May 2018 22:30:20 GMT

I am using the below script for section access. The issue is that the script works fine on desktop but fails in QMC Task even though I am appeding the service acccount 'VS\SR_QVTEST' to the security file.

The error I get is

" Error: Document open call failed. The document might require username and password"

Looks like its not finding the Service Account.

Any Idea what am I missing here ??

T:

LOAD

'ADMIN' as ACCESS,

UPPER(USER_ID) as NTNAME,

SubField(CUSTOMER_ID, ',') as Customer_ID,

ORGANIZATION as Organization

FROM

[..\QVDs\SECURITY.QVd]

(qvd);

Concatenate(T)

LOAD

'ADMIN' as ACCESS,

'VS\SR_QVTEST' as NTNAME,

SubField(CUSTOMER_ID, ',') as Customer_ID,

ORGANIZATION as Organization

FROM

[..\QVDs\SECURITY.QVd]

(qvd)

Where USER_ID ='XYZ\JOHNDOE';

Section Access;

NoConcatenate

load

ACCESS,

NTNAME,

Customer_ID,

Organization

Resident T;

Section Application;

Drop table T;