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
Accepted answer

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
Asked Dec 06, 2018 in Jira Ops

I'm John Allspaw, Ask Me Anything about incident analysis and postmortems

I'm John Allspaw, co-founder of   Adaptive Capacity Labs, where we help teams use their incidents to learn and improve. We bring research-driven methods and approaches to drive effective inciden...

5,535 views 21 17
View question

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you