WyUpdate errors with "Execute File"

Hi,

I am new to wyBuild and just bought a license, so this may be a dumb question. I tried implementing wyBuild, wyUpdate, and AutomaticUpdater. It appears to be functioning except when I have a version that requires "Execute File". Basically, I include all the required EXEs, DLLs, SQL, and a BAT file. The BAT file just executes the EXE with a parameter of a SQL file. The content of the BAT file would be ExecuteDBScript.exe "dml.sql". In the dml.sql, I may have a create table statement. ExecuteDBScript is a command line .Net app that returns a 0 or 1 based on success of the SQL execution. I include all the files in the "Temporary folder" location and tell it to execute the BAT file. But it always fails. Couple questions: 1) Is "Temporary folder" the correct place to put the files since it will no longer be needed? 2) How can I find out specifically, why it is erring out?

Thanks,Steve

Hey Steve,

But it always fails.

What do you mean it always fails? What do you expect to happen? What actually happens? (Please be specific: error codes, error messages, windows showing/not-showing, etc.). What options do you have checked for the executable? Does wyUpdate show an error message?

Couple questions: 1) Is "Temporary folder" the correct place to put the files since it will no longer be needed?

Yes.

2) How can I find out specifically, why it is erring out?

It depends on the error. What's causing the error? Your batch file? Did you tell wyUpdate to rollback on error? If not, do that. Also, add logging to your batch files and/or other executables.

Reply
Discard post