batch file error handling after calling C# program

Question

I have a batch file that calls C# program. This C# program makes call to SQL Server database. Sometimes it is unable to connect to the database and the exception handler prints stack trace and exits c# program. I want to try to run this program maximum of 5 times. If it succeeds (before 5 tries) then go to next step (CheckStatus) else Error out and quit.

When I run this, It is printing %ERRORLEVEL% as zero even when C# program has an error.

@ECHO OFF

SET Header=-----------------------------------------------------
SET Logfile=C:\LOG\log.txt
set %ERRORLEVEL% = 0

echo %header%
ECHO Running the batch file >> %Logfile%

if '%1' == '' goto usage
if '%2' == '' goto usage
if '%1' == '/?' goto usage
if '%1' == '-?' goto usage
if '%1' == '?' goto usage
if '%1' == '/help' goto usage


SET SQLServer=dbsql\production
SET SQLUser=user1
SET SQLPass=pwd1
SET SQLCommandMaster=osql -S%SQLServer% -n -U%SQLUser% -P%SQLPass% -b -i


GOTO %1%
:Start
Set count=0

:RunCSharpProgram
set /a count+=1
ECHO starting RunCSharpProgram count >> %Logfile%
timeout /t 10
SET RunningStep="RunCSharpProgram"
start "" "C:\CSharpProject\GetData\GetData\bin\Debug\GetData.exe"
ECHO %ERRORLEVEL% >> %Logfile%
IF %ERRORLEVEL% ==1 and count LEQ 5 (GOTO RunCSharpProgram)
IF %ERRORLEVEL% ==1 and count EQ 5 (GOTO error)
IF %ERRORLEVEL% ==0 (GOTO CheckStatus)

:CheckStatus
ECHO Check Status of tables >> %Logfile%
REM %SQLCOMMANDMASTER% /Q "EXEC TestDB.dbo.CheckStatus"
goto end

:usage
echo Usage: %0  'start step' 'end step'
goto end

:error
REM ---------------------------------------------------------------------
ECHO ERROR RUNNING BatchFileTest.BAT >> %Logfile%


:end
echo %header% >> %Logfile%
echo END >> %Logfile%

Not sure what is wrong with this batch file. Thanks MR

Possible duplicate of How do I get the application exit code from a Windows command line? — Gusman
– Gusman, Commented Aug 9, 2017 at 13:07
Possible duplicate of How do I specify the exit code of a console application in .NET? — mjwills
– mjwills, Commented Aug 9, 2017 at 13:08
Both do not answer my question, I am trying to call .NET program from batch file — user2726975
– user2726975, Commented Aug 9, 2017 at 13:22
Don't use start, this won't wait for your program to complete. — Lasse V. Karlsen
– Lasse V. Karlsen, Commented Aug 9, 2017 at 13:34

Subbu · Accepted Answer · 2017-08-09 13:31:22Z

3

When you use start, it would start a new shell to run your program.

Official documentation

Starts a separate Command Prompt window to run a specified program or command.

Since it is a separate command prompt you will NOT get back the error codes. So, simple solution do not use the start

instead of

start "" "C:\CSharpProject\GetData\GetData\bin\Debug\GetData.exe"

you can just use

"C:\CSharpProject\GetData\GetData\bin\Debug\GetData.exe"

answered Aug 9, 2017 at 13:31

Subbu

2,2151 gold badge20 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

batch file error handling after calling C# program

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related