This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I set up a batch file with a run command, and ran it. The Error message came up
Designer x64 The Designer x64 reported: Error running Event #1: The external program "\\XX\XX\XX\XX\XX.bat" returned an error code: 1: The specified image file did not contain a resource section. ¶ (1812)
Did anyone come up with a solution or workaround to this?
I've got the same error message when running a bat file to move a file on workflow completion (as an event), then delete the bat file. Everything works fine, but an error is still returned. I've experimented and for me it appears that the act of deleting the bat file is what is creating this error message.
Could you perhaps share the workflow and bat script? Why do you wan't to delete the bat file afterwards. You could save it to the TEMP directory by putting "%TEMP%" in the path. Then the file will be deleted automatically.
Hi Daniel, Thanks very much, I've attached the workflow.
Hopefully I'm not treading on the toes of this thread and may help uncover the cause of this error message more generally than just my case, even if it's in a bit of a roundabout way!
I'm sure there are better ways to do it but I think this is an interesting experiment nonetheless.
I have a folder with two sub-folders. One is called "To Load To Redshift", the other is called "Loaded To Redshift".
What I'm doing is running a previous workflow which processes a series of excel files in the "to load" folder and pushes them to a database (in this case redshift). Then the workflow I have attached is run, which uses the directory tool to specify the location of the "To Load Folder", and uses a batch macro finds all excel files in this folder, then creates a Bat file in the "To Load" folder. This is run after the workflow completes, and it moves all the excel files from the "To Load" folder to the "Loaded" folder, then deletes itself.
The error message is returned to Alteryx (even though everything completed successfully) after the bat file has run.
I've done it like this as in theory it's flexible and re-usable, but as I said there are probably better ways, using %TEMP% as you suggested.
If you're interested then feel free to take a look but if not it's actually not the end of the world because it's all working - just with a superfluous error message at the end.
Create a folder with two sub-folders called "To Load To Redshift" and "Loaded To Redshift"
Put some (any) excel files in the "To Load" folder
Open the workflow, ignore the file path error messages (to the bat file which doesn't yet exist)
Change the directory tool to the directory of your "To Load To Redshift" folder.
Run the workflow
Check the two folders and the excel files will have moved
If in doubt please disable the event when running the first time to see the Bat file created.