Session Access configuration on server

[#1]

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

[kaushiknsolanki]

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

[#3]

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

[kaushiknsolanki]

Hi,

    Will you please post the log file here.

Regards,

Kaushik Solanki

[Miguel_Angel_Baeyens · Accepted solution]

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

[#6]

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?

[#7]

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

Lilian

[Miguel_Angel_Baeyens]

Hi Lilian,

In regards to your second question, no, it should not be a problem not having the PASSWORD field. Actually, if you are using the NTNAME field, you should not to have the PASSWORD field. In your section access, MACHINE_LOCAL_DOMAIN\MACHINE_USER must be under NTNAME field and not under USERID.

Is that correct?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#9]

Yes Miguel,

In the ACCESS and NTNAME columns of my Excel file I have 'ADMIN'

and 'MACHINE_LOCAL_DOMAIN\machine_user' (with this character case).

In the reload configuration form of the document in the web admin console, the "Username" of the "Session Access" is set to 'MACHINE_LOCAL_DOMAIN\machine_user'.

Thanks a lot for your help... There is certainly something obvious in front of me that I don't see 😉

Lilian

[Miguel_Angel_Baeyens]

Hi Lilian,

Set the "machine_user" part uppercase in both the Server console and the excel file.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica