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;