Are you aware of the new AllowExecuteCommand switch in SR11?
I believe the default in SR11 is allow, and you didn't say your script was failing, so this is probably not the issue.
Do those bat files refer to drive letters or something that won't work in a service? Do you see any orphaned cmd.exe tasks in Task Manager on the server?
Can you try ECHO a message from the bat file to a file to see if the task is actually executing?
thanks for your suggestions. Apparently due to security settings, I was using network paths and that is not allowed when I launch cmd.exe in my server. It actually was not just that I was using paths to launch the stuff I needed, it is also the path where it starts as we use a network file share machine to store the qvw.
When a cmd is launched from there, It tries to use that folder as it's starting point, but due to security settings, it takes you back to Windows directory.
Then, relative paths from there don't work as it's not your qvw folder so it won't work at all.
In addition to the starting folder for the CMD it's the network paths not being recognized properly when executing enything else, so fixed straight await with this:
I just added an execute command at the beggining of the script to map to a drive the network path I wanted and after that I changed all paths to use that unit instead of network \\whatever paths
execute cmd.exe c/ NET USE Z: "\\path"
Now it works from Publisher without any problem at all.
I've searched for the AllowExecuteCommand in my settings.ini file and it's not there, but as you say in your useful blog post, it is by default set to 1 so I guess either I looked in the wrong place or it doesn't need to be declared in the settings file to be 1 as it's the default.
Anyway. It's working now.
Edit: I'm marking my answer as correct so It appears as solved.
Hi @Diego Perez,
I am facing the same issue.
On my Qlikview server I have R installed, on the E drive I have the R script, which is being Called by a Batch file (ReloadR.bat)
In Qlikview Script I am using following:
EXECUTE cmd /C "E:\Project\R Analytics\ReloadR.bat";
It works fine locally, but when used with Publisher, it completes running without running the batch file.
All execution done on one server machine, nowhere are network paths being used.
Have you checked all permissions are correctly set?
Try opening the doc in Desktop client, go to Settings > User Preferences > Security tab
Then check if it's unchecked the option that says :
"Script (Allow Database Write and Execute Statements)"