It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Bamboo Custom Installation - Set Up Database fails Edited

Bamboo set up with Custom Installation is keep failing while setting up data base.

I have created a DB in SQL server and provided the correct JDBC Connection url too.

Tables got created successfully in the DB but Bamboo set up wizard comes back to the same screen again and when I click on Continue button I can just see that 

"Please wait while Bamboo sets up your database" and spinner goes on and doesn't come back at all.

I have uninstalled  bamboo, deleted the bamboo-home folder completely and re installed Bamboo several times, but no luck, getting stuck with the same problem of setting up DB.

Any help would be much much appreciated please.

1 answer

0 votes

Hi Maitri,

 

I'd take a look at the atlassian-bamboo.log file which you'll find in the <BambooHome>/logs directory, this should give you a clue as to what's going on.

Cheers,

Christian

Premier Support Engineer

Atlassian

Hi Christian,

Thanks for your reply.

I have fixed the issue yesterday itself, I will share the solution here just in case if anyone else is experiencing the similar issue.

The issue was with External Database set up, there were two things that I have missed while setting up the DB

Configure the database to use case-sensitive collation — to make the SQL Server database respect case differences in the data it stores (which is required for Bamboo), ensure that you configure it using a case-sensitive collation option such as 'Latin1_General_CS_AS'. To access this feature in SQL Server Management Studio, right-click on the database name, select Properties from the resulting menu, then select the Options page. 

Configure the database to use the correct isolation level— Ensure that the new database was set to use Read Committed with Row Versioning as its isolation level. You can apply the new isolation by executing the following query:

ALTER DATABASE <database name>
   SET READ_COMMITTED_SNAPSHOT ON
   WITH ROLLBACK IMMEDIATE;

 

So I have deleted the DB and created it again and performed the above mentioned two steps, that is it, rest worked as expected.

 

Thanks

Maitri

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Bamboo

Unable to add or edit Bitbucket Cloud repository in Bamboo

On 31 May, a GDPR-related change went live in the Bitbucket Cloud API that resulted in users not being able to create or edit Bitbucket Cloud Linked repositories in Bamboo. This API update removed t...

665 views 2 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you