java.sql.SQLException: Incorrect syntax near 'go'.

jtds | akula84 | 10 years ago
  1. 0

    Incorrect syntax near 'go'

    jtds | 10 years ago | akula84
    java.sql.SQLException: Incorrect syntax near 'go'.
  2. 0

    Openfire service crashing daily | Ignite Realtime

    igniterealtime.org | 3 months ago
    java.sql.SQLException: Violation of PRIMARY KEY constraint 'ofPresence_pk'. Cannot insert duplicate key in object 'dbo.ofPresence'.
  3. 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'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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'.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Incorrect syntax near 'go'.

      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
    2. jTDS
      JtdsStatement.executeSQL
      1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
      2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
      3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)
      4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:620)
      5. net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:483)
      6. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:445)
      6 frames