Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,369,237
Community Members
 
Community Events
168
Community Groups

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

Edited

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?

1 answer

0 votes
Jimmy Seddon Community Leader Apr 30, 2019

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

If i put  exit 1;

will it work ?

Jimmy Seddon Community Leader Apr 30, 2019

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.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events