topic Re: Access Denied when loading scripts in QlikView

Access Denied when loading scripts

knightwriter — Tue, 31 Mar 2015 18:01:58 GMT

Hi All,

I have recently been given a new license in Qlikview 11 from a user whom uses Qlikview 9. Would this have anything to do with that I cannot reload or edit any scripts? Its constantly says "Access Denied", then "Execution of script failed. Reload old data?" when I try to run scripts.

I have tried the security tab and both the reload and edit options are selected.

How can I get access and successfully run these?? Many thanks.

Re: Access Denied when loading scripts

Wed, 01 Apr 2015 09:57:37 GMT

have you tried save as? maybe that will help.

Re: Access Denied when loading scripts

knightwriter — Wed, 01 Apr 2015 13:39:10 GMT

Hi Nard,

Im quite sure what you mean by Save As?

There are no other options other than to change the name of the doc.

Re: Access Denied when loading scripts

hic — Wed, 01 Apr 2015 13:41:09 GMT

Most likely there is a component in the script to which you don't have access, e.g. a file or a DB connection. It has nothing to do with the licence.

HIC

Re: Access Denied when loading scripts

terezagr — Wed, 01 Apr 2015 13:44:34 GMT

Do you have a section access applied? Your application might have a section access tight to a Qlikview Serial number. Have a look at this:

Introduction to Section Access

Re: Access Denied when loading scripts

knightwriter — Tue, 19 May 2015 14:10:21 GMT

Hi Tereza,

Thanks for the documentation but it does not cover off my request.

How do I find out what files / DB connection I have and have not access to?

Re: Access Denied when loading scripts

terezagr — Tue, 19 May 2015 14:19:11 GMT

I would have a look at the connection strings and try to connect to the databases specified in those. Same with files.

Re: Access Denied when loading scripts

knightwriter — Tue, 19 May 2015 14:22:11 GMT

Where are the connection strings? In the script?

Re: Access Denied when loading scripts

terezagr — Tue, 19 May 2015 14:54:54 GMT

Usually the first piece of code after Qlikview default variables. They have format such as: OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=**;Initial Catalog=***;Data Source=***;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=***;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is HNUNFYEHGTRNETYYA);