EDIT : Pretty much no vba/vbs macros are running on the sandbox, irrespective of workflow. No idea why this is happening, if i remove the macros the workflow runs fine.
Excel files have some formulas that need to calculate/refresh post populating said file with alteryx, so I use some VBA code to open, save and close file to "refresh", so the formulas calculate. (VBA code is triggered by a vbs file that I link through a Run tool.)
This whole thing works fine locally but in sandbox workflow gets stuck at that run tool infinitely.
I tried opening the vba file manually and it opens fine, tried running the vbs script and and it gives no errors.. The file that's being refreshed also opens fine so no corrupted files or anything like that causing issues.
Run tool Configuration:
Command:
wscript
Command Arguments[Optional]
path\to\file
Working Directory [Optional]
(empty)
read results and write sources are some random empty template files
Interestingly, I used to face this same issue locally and the fix was always opening task manager and manually ending background excel tasks. But how do I do this on a sandbox server? I feel like this is the issue because another different workflow that was working fine now has that exact same issue, although none of the alteryx workflow was modified since it was last working fine.
All files on sharepoint and I've confirmed that Alteryx has access to that sharepoint
