topic Re: Execute command in the script requires System Access... in QlikView

Execute command in the script requires System Access...

Sun, 28 Jul 2013 09:47:15 GMT

Hi,

I use the following command in the script: Execute cmd.exe /C Move_Winners.cmd

In addition, I checked in the Setting Tab (also in the script window) "Can Execute External Programs"

Also, in the the Setting --> User Preferences --> Security tab I checked the "Script (Allow Database Write and Execute Statement)"

When I run afterwards the document it runs OK.

But after a while, when i try to run the document again, the Checkbox of "Script (Allow Database Write and Execute Statement)" is unchecked by itself (the same one I Checked it before!), and we get the following pop-up message: "The script in this document requires system access to work....", and only after I manually press a button says "Give System Access", the Document continues to run

Why is that? I can't figure out how the "Script (Allow Database Write and Execute Statement)" checkbox "forgets" its setting...

Thanks,

Guy

Re: Execute command in the script requires System Access...

Anonymous — Sun, 28 Jul 2013 19:21:24 GMT

I'm not sure my response will help... Anyway...

As you properly described, this property is in User settings. That means, it is not a Document setting, hence it is not stored in QV application. If you copy the same application onto a different machine or login into the same machine as a different user - the modified User settings are not there. You get the default setings.

If the machine is the same and you login as the same user - I don't have answer.

Regards,

Michael

Re: Execute command in the script requires System Access...

Mon, 29 Jul 2013 09:21:00 GMT

So how can I check the checkbox "Script (Allow Database Write and Execute Statement)" as a defualt to be valid for all the documents in the BI server ?

Thanks,

Guy

Re: Execute command in the script requires System Access...

Anonymous — Mon, 29 Jul 2013 12:27:25 GMT

Well, I was talking about the QV Desktop, not the server.

So, for the Desktop, the User settings are valid for all documents - for the current User on this machine.

As for the QlikView Server - I can't tell for sure where the settings are. Try to post your question on the "Deployment and Management".

Regards,

Michael

Re: Execute command in the script requires System Access...

Mon, 23 Jun 2014 09:26:56 GMT

Guy, did you ever get this resolved, as I am experiencing the same problem. Please post thread if you received a solution

Cheers,

Byron

Re: Execute command in the script requires System Access...

Thu, 05 Nov 2015 07:34:39 GMT

better later than ever..

In the QV document: Settings-> User Perferences -> Security Tab - > check Script(Allow Database Write and execute Statements)

Re: Execute command in the script requires System Access...

Wed, 14 Sep 2016 10:40:15 GMT

Hi,

better later than ever.. It works

Re: Execute command in the script requires System Access...

kommisetty — Mon, 03 Feb 2025 07:50:32 GMT

Hello,

I have same issue and check box is checked in user preferences and it is fine when i am reloading manually in Qlikview desktop and in QMC it shows still error and also updated settings.ini file with flag says allow external command =1 but still not worked.