Weird Qlikview Problem 'Access denied to this QlikView document'

[#1]

I modified an existing Qlikview file - ****.qvw with Access Section at the begining of the source code.

First I commented out all the contents in Access Sections and after the modification was done in my QlikView version 10,

I reloaded and saved the file, tested everything is ok, then I uncommented all the things in the Access section,

and reloaded it again to test everything works ok, then I saved and closed it.

However it denied me to open it again within my Qlikview version 10, the error message is "Access denied to this Qlikview document."

Does anyone know what happened, and how to fix it, then how to avoid this issue.

Thanks a lot in advance.

Jin

[ashfaq_haseeb · Accepted solution]

Hi

Before Applying section access. Its always recomended to have a backup copy of application.

If its locked by section access You cannot unlock it.

I think you have forgot userid and password of that particular application.

If not If you are 100% sure that you have commented section access part.

Then go the application folder. Apart from application you will find .share and .meta file, Delete this files and then try the open application.

Also In qlikview desktop go to Recently opened documents --> right click on application then open without data.

If it opens then play arount with it to recover.

Hope this helps

Regards

ASHFAQ

[#3]

Hi ASHFAQ,

Thank you very much for your reply.

Just now I recreated the same ****.qvw file and tested the modified code line by line.

Modify - Reload - Save - Open again.

Then I found the denying issue happens after I added A new SQL Server table into the source code, the previous data in the source code are retrieved from cube, the newly added data is from relational table, although they are on the same SQL Server.

My QlikView file structure is as follows:

Section Access;

...

Section Application;

CONNECT TO [Provider=SQLOLEDB.1;Integrated ...

SQL SELECT ...FROM ...

//Then the newly added SQL server relational table is:

SQL SELECT ... From ... // At here there is no error while performing reload, and the data can be seen and inserted into List Object after reload completes

but after the Qlikview file was saved, I can't open it with the application of QlikView version 10, and it throws me an error message, "Denied access to this QlikView document".

What on earth happened? How to avoid this issue? How can I fix it?

Help ... please ... : (

Jin

[ashfaq_haseeb]

Hi

if its locked by section access no one can help you.

What you can do here after is that first try to build the compleate application and then the final step is to apply section access.

But don't forget to take backup that particular application.

Hope this helps

Regards

ASHFAQ

[Miguel_Angel_Baeyens]

Hello Jin,

Are you using some reduction field so depending on the user opening each one sees different records? Create an ADMIN user in the section access to make sure that you will be able at least to open the document in the Desktop application.

Have you checked "Strict Exclusion" in the Settings menu, Document properties? If so, uncheck it and try.

Are all your fields and values in section access uppercase? It's mandatory to do so.

Are you loading your section access from a QVD file? If so you will need to unoptimize the load.

Hope that helps.

[#6]

If it's locked by section Access I can help. I have a method to bypass security.

Try me.

Right now I am doing this for free. You can send me a QVW for me to unlock, comment out the section access security and send back.

If there is a market for this maybe I will start charging in the future.

[#7]

Dear Friends

Thank you all for the kind responses, the problem I had was solved just now.

The cause was that the new table I loaded into Qlikview contained a column named 'NTNAME',

so everytime it denies me to access it again.

Thanks again for everyone who provided help to me.

Jin

[Emmanuelle__Bustos]

quickview

Please mark your post as resolved !

Regards!