topic Session Access configuration on server in QlikView

Session Access configuration on server

Mon, 12 Sep 2011 07:41:59 GMT

Hi,

I have a document, using Session Access in it's script to load the data.

I have configured the reload of this document on the server but each time I try to reload it: it fails.

Do I have to use the "Session Access" section of the reload form of the admin portal (see attached screenshot)?

And if yes, what credentials do I have to use?

Thanks in advance for any clues!

Lilian

Session Access configuration on server

kaushiknsolanki — Mon, 12 Sep 2011 08:04:41 GMT

Hi,

It fails cause you need to pass the username and password of admin to the shown place in your image.

This admin is the one defind in the Section Access.

Regards,

Kaushik Solanki

Session Access configuration on server

Mon, 12 Sep 2011 11:17:38 GMT

Hi Mr Solanki,

Thanks for the quick answer!

My session access is based on a MS Excel file (see the new file attached to the discussion).

The "admin" is set with the user id used to log on the QV server machine (BTW a virtual machine).

Even with the same user put in the document reload form of the web console, the reload still fails!

Could this be because the Active Directory domain of the QV server is the machine's local domain and not the company domain?

Best regards,

Lilian Cardonne

Session Access configuration on server

kaushiknsolanki — Mon, 12 Sep 2011 11:50:29 GMT

Hi,

Will you please post the log file here.

Regards,

Kaushik Solanki

Session Access configuration on server

Miguel_Angel_Baeyens — Mon, 12 Sep 2011 14:23:45 GMT

Hi Lillian,

You need to add to the section access the user the QlikView services are running under, as ADMIN in the ACCESS fields. Then you can set either this account in the form DOMAIN\USERNAME leaving blank the field password, or any other ADMIN user in your section access. Check here for a very similar and recent issue.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Session Access configuration on server

Tue, 13 Sep 2011 06:58:42 GMT

Hi Miguel,

I'm totaly in the situation your advising!

In my session access MS Excel file I have a row with 'ADMIN' and 'MACHINE_LOCAL_DOMAIN\MACHINE_USER'.

In the web admin portal form "Section Access" is checked and "Username" is set to 'MACHINE_LOCAL_DOMAIN\MACHINE_USER'.

But whether I put the password or not in the 'Password' field of the web admin portal form, the document fails to reload.

The full log I get is:

(2011-09-13 08:37:44)Information: Executing ClusterID=1, QDSID=21dc982f-14ff-6228-e7d2-656a34d96a5bQDSMain.DistributeTask

(2011-09-13 08:37:44)Information: Starting task "fmis/FMIS_Budget_Analysis.qvw" (Attempt 1of 1)

(2011-09-13 08:37:44)Information: Max run time: 06:00:00

(2011-09-13 08:37:44)Information: Document is marked for refresh; Initializing Reload.

(2011-09-13 08:37:44)Information: Opening"C:\QLIKVIEWPORTAL\FMIS\FMIS_Budget_Analysis.qvw"

(2011-09-13 08:37:44)Information: Allocating QlikView Engine(2011-09-13 08:37:44) Information:Allocating new QlikView Engine. Current usagecount=1 of 2

(2011-09-13 08:37:44)Information: An instance of the QlikView Engine is being created(2011-09-1308:37:44) Information: Starting QlikView Engine

(2011-09-13 08:37:44)Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2,Ticket=17

(2011-09-13 08:37:44)Information: Loading document"C:\QLIKVIEWPORTAL\FMIS\FMIS_Budget_Analysis.qvw" (13.58 Mb)

(2011-09-13 08:37:45)Information: Loading. LoadTime=00:00:01.0000064

(2011-09-13 08:37:47)Information: Loading. LoadTime=00:00:03.0000192

(2011-09-13 08:37:48) Error:Document open call failed. The document might require username and password.

(2011-09-13 08:37:48) Error:The document failed to open. Bad Username and password is the most likely causeof this problem.

(2011-09-13 08:37:48)Information: Closed the QlikView Engine successfully. ProcessID=1504

(2011-09-13 08:37:48)Information: Initializing Checkout (0), Loading document (234), Initializingload (234), Checking read (234), Creating QlikView Engine (234), Checking Size(250), Load (S&A) (2250), Load Completed (3594)

(2011-09-13 08:37:48) Error:Document could not be opened

(2011-09-13 08:37:48)Information: Document could not be opened (0)

(2011-09-13 08:37:48)Information: Initializing (0), Finished (0)

(2011-09-13 08:37:48) Error:Reload failed because the document could not be opened successfully.DocumentState=CouldNotOpenDocument

(2011-09-13 08:37:48) Information:Initializing (0), Finished (0)(2011-09-13 08:37:48) Error: Reload failed.Distribution skipped.

(2011-09-13 08:37:48) Error:The task "fmis/FMIS_Budget_Analysis.qvw" failed. ErrorCount=5

All the QV processes qnd services are running under MACHINE_LOCAL_DOMAIN\MACHINE_USER.

To be complete, I can add that the qvw reads the MS Excel session access file then loads qvd files generated by another application. Everything works fine when I reload the qvw file with the QV client on the machine.

Lilian

P.S.:

1) MACHINE_LOCAL_DOMAIN\MACHINE_USER has sufficient rights on all the involved files on disk!

2) In my session access Excel file I do not have a 'PASSWORD' column is that an issue?

Session Access configuration on server

Tue, 13 Sep 2011 06:59:06 GMT