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

Atlassian JIRA | Renan Battaglin | 7 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 | 7 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 | 7 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

  5. 0

    jTDS - SQL Server and Sybase JDBC driver / Discussion / Open Discussion:closed Connection

    sourceforge.net | 1 year ago
    java.sql.SQLException: I/O Error: Connection reset at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java(Compiled Code))
  6. 0

    closed Connection

    jtds | 1 decade ago | fboeschemeier
    java.sql.SQLException: I/O Error: Connection reset at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java(Compiled Code))

    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