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

External Database MS Sql Server (2005) not getting setup correctly Edited

I am setting up a new instance of Bamboo using an MS Sql Server for the database. It takes a while and seems like there are errors creating the DB. Bamboo is creating tables, but during setup it goes back to the Setup External database screen. I have tried dropping the DB, stopped the Bamboo service, removed the bamboo home directory.

Looking at the log I see this error during the DB creation:
2017-12-14 11:39:08,767 INFO [http-apr-8085-exec-11] [AccessLogFilter] 127.0.0.1 POST http://localhost:8085/setup/performSetupDatabaseConnection.action 540286kb
2017-12-14 11:39:09,540 INFO [performSetupDatabaseConnectionBackgroundThread] [QuartzScheduler] Scheduler scheduler_$_NON_CLUSTERED started.
2017-12-14 11:39:09,552 INFO [performSetupDatabaseConnectionBackgroundThread] [DefaultHibernateConfigurator] Spring context refreshed after 40.72 s
2017-12-14 11:39:09,552 INFO [performSetupDatabaseConnectionBackgroundThread] [DefaultHibernateConfigurator] Creating Bamboo schema...
2017-12-14 11:39:10,299 WARN [performSetupDatabaseConnectionBackgroundThread] [SqlExceptionHelper] SQL Warning Code: 1945, SQLState: S0001
2017-12-14 11:39:10,299 WARN [performSetupDatabaseConnectionBackgroundThread] [SqlExceptionHelper] Warning! The maximum key length is 900 bytes. The index 'ASSIGNMENT_UNIQUE' has maximum length of 1036 bytes. For some combination of large values, the insert/update operation will fail.
2017-12-14 11:39:10,362 WARN [performSetupDatabaseConnectionBackgroundThread] [SqlExceptionHelper] SQL Warning Code: 1945, SQLState: S0001
2017-12-14 11:39:10,362 WARN [performSetupDatabaseConnectionBackgroundThread] [SqlExceptionHelper] Warning! The maximum key length is 900 bytes. The index 'notifications_unique' has maximum length of 2048 bytes. For some combination of large values, the insert/update operation will fail.
2017-12-14 11:39:10,553 INFO [performSetupDatabaseConnectionBackgroundThread] [DefaultHibernateConfigurator] Bamboo schema created.
2017-12-14 11:39:10,577 INFO [performSetupDatabaseConnectionBackgroundThread] [DefaultBootstrapManager] Running validation tasks
2017-12-14 11:39:10,842 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------------------------------
2017-12-14 11:39:10,842 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 1 : Validate that JDBC driver is available in classpath (bootstrap)
2017-12-14 11:39:10,842 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -------------------------------------------------------------------
2017-12-14 11:39:10,854 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 1 completed successfully.
2017-12-14 11:39:10,855 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------
2017-12-14 11:39:10,855 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 2 : Validate if build number in home directory matches database (bootstrap)
2017-12-14 11:39:10,855 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ---------------------------------------------------------------------------
2017-12-14 11:39:10,855 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 2 completed successfully.
2017-12-14 11:39:10,855 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------------------------------
2017-12-14 11:39:10,855 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 2901 : Test if build number is applicable for upgrade (bootstrap)
2017-12-14 11:39:10,855 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] -----------------------------------------------------------------
2017-12-14 11:39:10,856 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] Task 2901 completed successfully.
2017-12-14 11:39:10,856 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ------------------------------------------------------------
2017-12-14 11:39:10,856 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] 2902 : Test if plan keys are correctly formatted (bootstrap)
2017-12-14 11:39:10,856 INFO [performSetupDatabaseConnectionBackgroundThread] [BootstrapUpgradeManagerImpl] ------------------------------------------------------------

2 answers

1 accepted

0 votes
Answer accepted

Hi Daniel,

In the title of your post it looks like you're using MS SQL Server 2005 and attempting to use the latest version of Bamboo (6.2).  If that is correct the first thing we'll need to do is upgrade to a Supported version of MS SQL:

Microsoft SQL Server:

(tick) SQL Server 2012

(tick) SQL Server 2014

(tick) SQL Server 2016

Once you upgrade to a supported version of SQL Server please retry and if you still run into the same issue let me know and we'll go from there.  If you are indeed using a Supported version of SQL Server let me know that as well.

Cheers,

Branden

I just tried a higher version of SQL and it seems to work. 

Awesome!  I'm glad we were able to figure that out and I hope the rest of your install is easy going!

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...

307 views 2 6
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