Run command won't run in Alteryx server

Hi all,

I have a run cscript to run an Excel macro, it works well when running in the Alteryx Designer Desktop. so I uploaded it onto the server and scheduled it to run, but it doesn't do what it's supposed to do - the workflow was "completed" but no files were produced, and no error messages. What's the potential cause for this?

The workflow is a single run command tool, no input or output.

Thanks.

Run Command

Accepted answers

All comments

DanielvanLeuzen

You will need an input and an output.

I recommend you to read the following article:
Alteryx Run Command: Executing Excel Macros (VBA) - Alteryx Community

From here you can also download the example workflow

oneillp111

@Meiye, what is the batch command? and Also check with the server Admin, in order to run the excel macro, the server needs to have excel installed. In my case, my server does not have excel installed,

fmvizcaino

Hi @Meiye ,

Possibly something related to the paths.

Could you please share the script so we can take a further look?

Best regards,

Fernando Vizcaino

Meiye

Hi @fmvizcaino ,

Here is the screen shot... I don't need either the "Write source" or the "Read Result" but when I leave both of them blank there's an error message... so they are basically place holders. but it does work when I run it in the designer desktop.

fmvizcaino

Just read your previous message and you are right. I had this error before where a vbs script was not running but also not showing any errors and it was related to not having Excel installed on the server.

Brian_Denso

Run Command.PNG

I'm having the same issue. I have a Run Command workflow. When I run it on my local computer, works fine. When I run it on the server Designer version it works fine and creates the expected excel file. When I run in the gallery, it executes successfully but the excel file is not created. The excel macro is manipulating some data and saving off a new file. I've attached the run command info as well as the vb script code.

'Input Excel File's Full Path
ExcelFilePath = "C:\Test_Files\Template\Template.xlsm"

'Input Module/Macro name within the Excel File
MacroPath = "Module1.Save"

'Create an instance of Excel
Set ExcelApp = CreateObject("Excel.Application")

'Do you want this Excel instance to be visible?
ExcelApp.Visible = True 'or "False"

'Prevent any App Launch Alerts (ie Update External Links)
ExcelApp.DisplayAlerts = False

'Open Excel File
Set wb = ExcelApp.Workbooks.Open(ExcelFilePath)

On Error Resume Next
'Execute Macro Code
ExcelApp.Run MacroPath

'Save Excel File (if applicable)
wb.Save

'Reset Display Alerts Before Closing
ExcelApp.DisplayAlerts = True

'Close Excel File
wb.Close

'End instance of Excel
ExcelApp.Quit

Lars__

Although your post was made quite some time ago, were you able to determine what the issue was? I am experiencing the same problem and cannot resolve it.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703