My workflow doesn't finish when I run it via gallery
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a workflow which is using run command tool like this:
.bat file looks like this:
.vbs file looks like this:
And the macro in the .xlsm file
This workflow is using macro to combine all excel files to one file.
When I run it locally then everything is working cool. But when I ran it via gallery, the workflow create the result file everything is looking good, but the workflow is on the "running" status and it is not finishing.
Do you have any ideas why ?
Thanks !
- Labels:
- Gallery
- Run Command
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are your arguments hard-coded in the BAT file, and repeated again in the Run command field for Command Arguments (optional)?
When I was trying to run a Powershell script from the After Run event, the two tips below helped me. I know you're trying to run VBS, but maybe try:
Working Directory [Optional]: leave this value blank, to avoid an error
One of these instructions is correct, can't remember which one:
1) For all folder paths: If you are using a UNC path (beginning with \\), use “\\?\” instead of “\\”, like this:
- “\\?\UNCPath\MySubFolder\Save_Alteryx_Log_File.ps1”
- "\\?\UNCPath\MyLogFileFolder"
or
2)
- For the path to the Powershell script only: If you are using a UNC path (beginning with \\), use “\\?\” instead of “\\”, like this:
- “\\?\UNCPath\MySubFolder\Save_Alteryx_Log_File.ps1
- For other paths/parameters in the Run Command text, continue to use \\ only, like this:
- "\\UNCPath\MyLogFileFolder"
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
