java.sql.SQLException: Invalid column name 'build_completed_date'.

Atlassian JIRA | Renan Battaglin | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Upgrade task 1831 will fail for every instance using a Case-Sensitive. {code} 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) {code} *Immediate Workaround* 1. Run the [upgrade steps|http://confluence.atlassian.com/display/BAMBOO/Bamboo+Generic+Upgrade+Guide] 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.

    Atlassian JIRA | 6 years ago | Renan Battaglin
    java.sql.SQLException: Invalid column name 'build_completed_date'.
  2. 0

    Upgrade task 1831 will fail for every instance using a Case-Sensitive. {code} 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) {code} *Immediate Workaround* 1. Run the [upgrade steps|http://confluence.atlassian.com/display/BAMBOO/Bamboo+Generic+Upgrade+Guide] 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.

    Atlassian JIRA | 6 years ago | Renan Battaglin
    java.sql.SQLException: Invalid column name 'build_completed_date'.
  3. 0

    Incorrect syntax near 'go'

    jtds | 1 decade ago | akula84
    java.sql.SQLException: Incorrect syntax near 'go'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid column name 'build_completed_date'.

      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
    2. jTDS
      JtdsStatement.executeSQL
      1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
      2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
      3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
      4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
      5. net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
      6. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
      6 frames