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