Details
-
Bug
-
Resolution: Fixed
-
High
-
None
-
None
-
Problem observerd in a MS SQL instance using Latin1_General_BIN Colation
Description
Upgrade task 1831 will fail for every instance using a Case-Sensitive.
INFO | jvm 1 | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,052 INFO [WrapperSimpleAppMain] [UpgradeManagerImpl] ----------------------------------------------------------------------------------- INFO | jvm 1 | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,052 INFO [WrapperSimpleAppMain] [UpgradeManagerImpl] Running upgrade task 1831 : Setting null build_completed_date fields to build_date. INFO | jvm 1 | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,052 INFO [WrapperSimpleAppMain] [UpgradeManagerImpl] ----------------------------------------------------------------------------------- INFO | jvm 1 | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,068 INFO [WrapperSimpleAppMain] [UpgradeTask1831FixNullBuildCompleted] Unable to determine whether to run: Setting null build_completed_date fields to build_date. INFO | jvm 1 | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,068 INFO [WrapperSimpleAppMain] [AbstractStatementUpgradeTask] Executing SQL: update BUILDRESULTSUMMARY set build_completed_date = build_date where build_completed_date is null INFO | jvm 1 | 2010/10/13 02:40:08 | 2010-10-13 02:40:08,068 ERROR [WrapperSimpleAppMain] [AbstractStatementUpgradeTask] Unable to run update BUILDRESULTSUMMARY set build_completed_date = build_date where build_completed_date is null : Invalid column name 'build_completed_date'. INFO | jvm 1 | 2010/10/13 02:40:08 | java.sql.SQLException: Invalid column name 'build_completed_date'. INFO | jvm 1 | 2010/10/13 02:40:08 | at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) INFO | jvm 1 | 2010/10/13 02:40:08 | at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) INFO | jvm 1 | 2010/10/13 02:40:08 | at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) INFO | jvm 1 | 2010/10/13 02:40:08 | at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) INFO | jvm 1 | 2010/10/13 02:40:08 | at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) INFO | jvm 1 | 2010/10/13 02:40:08 | at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
Immediate Workaround
1. Run the upgrade steps and allow Bamboo to execute until the problem with Task 1831 happen.
2. Shutdown Bamboo.
3. Open file <Bamboo-Home>/bamboo.cfg.xml and change the buildNumber to 1831. Then, restart the new Bamboo instance.