Unable to login as user into the file in which section access implemented after sometime

[#1]

can any one please tell me, I am Unable to login to the qvw file as user after sometime, but again i am able to login as user after reloading the file by logging as Admin

[#2]

could you please help me with the section access code

How to write, I tried in all my ways

Thanks

[swuehl]

Is your problem reproducible? If so, could you upload a small sample QVW (with some dummy users and data)?

[kkkumar82]

If I am correct In your section access code you don't have the users in capital letters and also in section access code you mentioned user1.. user3 but in the later you don't have them rather you have L1..L3

[Peter_Cammaert]

So the sequence of events is more or less like this:

1. A user cannot log in anymore into your document as USER
2. You can still enter the document using the ADMIN account, you do a reload and you save the document.
3. The same initial user can again enter the document, but cannot save it.
4. ...
5. The same user cannot log in anymore into your document...
6. Go back to step 2

This is a correct depiction of the events?

The missing part 4 is important. QlikView will not do anything to any document when it isn't running. Who is changing the document, or what is happening in between 3 and 5? Does this document reside in a Server Root Directory and does the server perform a reload on its own?

Best,

Peter

[#6]

Hi peter.

yes, the order of events you mentioned is exactly what is happening to me

but, my file is not on server yet, I am doing the reload by login as admin on my desktop in qlikview personal edition

could you check my code to implement section access  that i wrote above once

[#7]

yeah, i am taking the usernames from excel sheet that i uploaded in the useraccess table,

i have the usernames in USERID column of my excel sheet, L1,L2,L3 are my sheet names

please see the image of my excel sheet

Thanks

[kkkumar82]

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SHEET

    ADMIN, RAHUL, Rahul121, *

    USER, USER1, p1, L1

    USER, USER2, p2, L2

    USER, USER3, p3, L3

    , , , PRODUCTION

    , , , ADMIN

];

Section Application;

I was saying about the red marked , I think they should be in capitals

[#9]

Production and Admin are not username they come under sheet column.. as i have to mention all the sheet names under sheet column, since i mentioned * for admin..

anyhow,

but i dont have usernames and admin name all in capitals in my server,,,

if i write the user names in capitals shall i have to create the users on my windows server with the capitals?

[#10]

please see the attached files along with my excel sheet,

again, with this code, everything is working fine for me at this moment

Thank you

[kkkumar82]

If I correctly remember there is no need .