Unable to fail the bamboo build while connecting to database for invalid password using inline

[Atul]

Hi there,

This is with respect to one of issue we have faced in our bamboo plan.

we have created the task with inline script to connect to database and run sql script where interpreter is cmd.exe or /bin/sh.

sqlplus ${username}/${password}@${database} @Example.sql ;

exit;

we have set variable for the username , password and database. So when we are trying to connect to database bamboo build should fail with error message for invalid password but it is not getting failed right now. Also build is running continuously by throwing the error in logs and not failing the build.

But if username and password are correct then build is getting successful by executing the sql script. 

Question here is that is there any way can we fail the bamboo build for invalid username and password?

[Jimmy Seddon]

Hi @Atul,

Welcome to the community!

I think the problem you are running into is that the your script is exiting cleanly (exit code 0).  So even though it fails to connect to the database the script is exiting properly.  You should modify your script to throw a non-zero exit code if it fails to connect to the database, that should signal Bamboo to treat the task as a failure and fail the build.

I hope that helps!

-James

[Atul]

If i put  exit 1;

will it work ?

[Jimmy Seddon]

Most of the scripts I have been using are Powershell and I haven't had as much success with an exit 1 as I have with throwing errors.  I'm not sure if you might have more success with exit 1 given you aren't using the Powershell interpreter.