Section Acess

[janardhan]

Hi Friends,

I have developed one application with section access and deployed that application into server (Without Publisher).

I have scheduled the extractor and application daily at 12AM. Extractor was running successfully but my application was failing. I saw the logs about failing , In the log file i got a message like : Require UserName and Password. I had given NTNAME and Password what i have specified in the section access part. Again it was throwing an error like Bad UserName and Password.

Can anyone help me , Thanks in Advance

Jana

[ashfaq_haseeb]

Hi,

Go through this attached document

An Example

SECTION ACCESS;

LOAD

UPPER(Level) AS ACCESS,

UPPER(DomainName) AS NTNAME,

UPPER(PASSWORD) AS PASSWORD

FROM Access.XLSX;

SECTION APPLICATION;

You need to make sure your service account is added to Excel file and his access is define as ADMIN.

Regards

ASHFAQ

[janardhan]

Hi Mohammed,

Inline

           Access    NTNAME  Sheet

like this

[deepakqlikview_123]

thanks Ashfaq

[ashfaq_haseeb]

Hi,

Can you post your section access script here.

Regards

ASHFAQ

[janardhan]

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, DEPT_CODE

    ADMIN, xxGROUP\QVADMIN,

    USER, xxGROUP\UJANA, 101

];

Section Application;

[ashfaq_haseeb]

Hi,

That's good

now modify it as below

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, DEPT_CODE

    ADMIN, xxGROUP\QVADMIN,*

    ADMIN, xxGROUP\Service Account,*

    USER, xxGROUP\UJANA, 101

];

Section Application;

Note:

Here Service Account is the one that you run QlikView Services.

And add service account credentials in that part as specified by Gysbert Wassenaar.

Regards

ASHFAQ

[janardhan]

Document open call failed. The document might require username

still i am getting error

[ashfaq_haseeb]

Ok

Can you tell me how did you pass credentials.

Did you enter user name Prefixed with domain.

Mydomain\Service account

Regards

ASHFAQ

[janardhan]

Hi Mohammed,

I am getting message like the document require userid and password.

I have attached the log file message.

Pls Help me out

Thanks

Janardhan

[Bill_Britt]

Hi,

The service account needs to be added to the access list with Admin rights. If you are doing data reduction you also need to put a * in the reduction filed.

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, TEST

    ADMIN, SERVICEACCOUNT, *

    USER, USER1, RED

    USER, USER2, WHITE

];

Section Application;

bILL