topic Re: AllowexecuteCommand Setting Violate in QlikView

AllowexecuteCommand Setting Violate

pkpandey — Tue, 29 Mar 2016 05:17:17 GMT

Hi All

I am getting the error while running the "EXECUTE" command in my script though I have checked the "Script(Allow Database Write and Execute Statement" in the User Preferences and also ticked the "Can Execute External Programs" in settings.

Re: AllowexecuteCommand Setting Violate

tresB — Tue, 29 Mar 2016 05:20:29 GMT

What is the error message you are getting? Are you trying on access point? If so, have you checked the related setting on server (QMC)?

Re: AllowexecuteCommand Setting Violate

pkpandey — Tue, 29 Mar 2016 05:40:41 GMT

Hi Tresesco

I am getting the error "AllowExecuteCommand Setting Violation detected" in the Log file of the script. I have not tried in the access point. What are the related setting in QMC? Please suggest. I have added the record AllowExecuteCommand=1 in the setting.ini also

Re: AllowexecuteCommand Setting Violate

tresB — Tue, 29 Mar 2016 05:48:36 GMT

What is your QV version?

Re: AllowexecuteCommand Setting Violate

pkpandey — Tue, 29 Mar 2016 06:25:36 GMT

Hi Tresesco

My QV Version is 12

Regrds

PKP

Re: AllowexecuteCommand Setting Violate

tresB — Tue, 29 Mar 2016 06:29:54 GMT

After making the changes in Settings.ini , Did you restart the services? If not try doing so.

Re: AllowexecuteCommand Setting Violate

pkpandey — Tue, 29 Mar 2016 07:32:16 GMT

HI Tresesco

Yes After making the changes in the settings.ini I have restarted the services. Though it is giving the same error

Re: AllowexecuteCommand Setting Violate

tresB — Tue, 29 Mar 2016 07:43:53 GMT

Do you have multiple servers running QDS? If so, make sure the change is done in all of them.

Re: AllowexecuteCommand Setting Violate

pkpandey — Tue, 29 Mar 2016 08:03:42 GMT

Hi Tresesco

I am having only one Qlikview Server running QDS and I do not have publishers.

Best Regards

PKP

Re: AllowexecuteCommand Setting Violate

tresB — Tue, 29 Mar 2016 08:18:13 GMT

One last try I would do like:

1. Set the AllowExecuteCommand=0

2. Save he ini file

3. Restart the services

4. Check now if the error comes

5. Reset the value to 1/0 (whichever suits)

6. Repeat Step 2-4

If this doesn't help, try contacting Qlik support or wait for some more inputs from experts here.

Re: AllowexecuteCommand Setting Violate

pkpandey — Tue, 29 Mar 2016 08:52:03 GMT

Hi Treseco

I have done the same as per your instruction but it is giving the same error "AllowExecuteCommand setting violation detected"

Best Regards

PKP

Re: AllowexecuteCommand Setting Violate

sujoybardhan — Thu, 31 Mar 2016 12:45:39 GMT

Hi Pradeep,

Please do one thing, go to Edit script, then select the Settings Tab in the script and enable the "Can Execute External Programs" check box. Now Save & Reload your script.

It will works for you.

Regards,

Sujoy

Re: AllowexecuteCommand Setting Violate

pkpandey — Fri, 01 Apr 2016 08:36:59 GMT

Dear Sujoy

I have done that but the result is same.

Regards

PKP