executecommand doesnt run a batch

[BigG]

Hi there, searched around but couldnt find any thing specific.

My TI runs an execute command for a batch, the batch file runs correctly if I manually run it. But TI does not run the process

the batch calls a vb script eg. C:\windows\system32\Cscript.exe E:\TM1_... ###.vbs

If I put a file create eg. dir > E:\TM1_...dir.txt it creates the file so the settings in the executecommand are pointing correctly.

Is there a setting in the batch file I would need to make so it can call a vbs?

thanks in advance.

[winsonlee]

I have tried running vbs file from a batch file using the TI execute command and it works.
Have you check if permission is given to the vbs file ?

did you try running other vbs script to see if it works ? Below is a sample script to create a directory and file which works when i run it.

Code: Select all

Option Explicit
Dim objFSO, objFSOText, objFolder, objFile
Dim strDirectory, strFile
strDirectory = "c:\tempx"
strFile = "\Summer.txt"

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set objFolder = objFSO.CreateFolder(strDirectory)
Set objFile = objFSO.CreateTextFile(strDirectory & strFile)
Wscript.Echo "Just created " & strDirectory & strFile

Wscript.Quit

[Andy]

Hi BigG,

does your batch needs any parameters?

Can you show us your TI script?

In my opnion it should not be a problem to run batch files from a TI process.
I just did it a few weeks ago.

By the way:
Which TM1 version do you use?

[asutcliffe]

Depending on your OS and the nature of your vbs script, you might be encountering the problem I ran into here - http://www.tm1forum.com/viewtopic.php?p=33913#p34024.

[BigG]

thanks for the replies, answers to questions:

It seems we are onto something with
viewtopic.php?p=33913#p34024. as it is also calling xml excel create vbs
creating C:\Windows\SysWOW64\config\systemprofile\Desktop folder

and it works!!!