Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Execute command issue

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.Execute issue.PNG

7 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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)?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

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"';

Anonymous
Not applicable
Author

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

PrashantSangle

Yes..

all command come inside double quote

EXECUTE " Command"

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

not working Prashant.

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

Anonymous
Not applicable
Author

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.