topic Re: Execute command issue in QlikView

Execute command issue

Anonymous — Wed, 12 Jul 2017 04:44:50 GMT

Hello ,

I have been trying to Execute R code from 60 server and that R is installed on 140 server. With below Execute command in QVW.

EXECUTE "\\172.17.114.140\C$\Program Files\R\R-3.3.2\bin\x64\Rcmd.exe" BATCH "\\172.16.19.60\E$\sh\Sh_Changes_Portfolio\ClaimPA_IT-harshal_ErrorFree60.r"

It works fine when i manually reload qvw. but when i scheduled it on QMC its failing everytime with attached error.

Please help on this. I tried executing that command from command prompt it worked. but not working through QMC.

Re: Execute command issue

jonathandienst — Wed, 12 Jul 2017 04:52:18 GMT

Does the QMC service account have access to all the resources referenced by the command (including admin level to access the hidden C$ and E$ shares)?

Re: Execute command issue

PrashantSangle — Wed, 12 Jul 2017 04:57:41 GMT

Try below in Execute Command

wmic /node:YourServerIP /user:userName /password:passWord process call create 'cmd.exe /c call "YourBatPath"'

Modify as per your requirement.

Regards,

Prashant

Re: Execute command issue

Anonymous — Wed, 12 Jul 2017 06:36:11 GMT

is below Execute statement correct as per your command-

EXECUTE wmic /node:\\172.17.114.140 /user:QLIKSENSE\SBILSUADM /password:password process call create 'cmd.exe /c call "E:\sh\Sh_Changes_Portfolio\Fraud R code.bat"';

Re: Execute command issue

Anonymous — Wed, 12 Jul 2017 06:41:57 GMT

I tried above command but its not running R code it just pops up cmd and closes.

Re: Execute command issue

PrashantSangle — Wed, 12 Jul 2017 06:43:28 GMT

Yes..

all command come inside double quote

EXECUTE " Command"

Regards,

Re: Execute command issue

Anonymous — Wed, 12 Jul 2017 09:25:18 GMT

not working Prashant.

I tried above command but its not running R code it just pops up cmd and closes.

Re: Execute command issue

Anonymous — Wed, 12 Jul 2017 12:16:58 GMT

Yes service ID has full rights on that file and folders on other server. I am able to run manually but through QMC its failing.