Uploaded image for project: 'Bamboo Data Center'
  1. Bamboo Data Center
  2. BAM-9959

Bamboo 3.3 upgrade fails on MS SQL Server 2005

    XMLWordPrintable

Details

    Description

      Bamboo 3.3 upgrade fails with following exception;

      2011-10-11 17:39:13,823 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] Running upgrade task 2704 : Init BuildResultSummaryRevisionKey
      2011-10-11 17:39:13,823 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] --------------------------------------------------------------
      2011-10-11 17:39:13,840 INFO [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [UpgradeTask2704InitializeRepositoryChangesets] Binding commits to repository changesets (it might take several minutes) ...
      2011-10-11 17:39:13,848 ERROR [2-UpgradeTaskBackgroundThread:pool-8-thread-1] [AbstractUpgradeManager] org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Incorrect syntax near 'UC'.
      org.springframework.jdbc.BadSqlGrammarException: Hibernate operation; bad SQL grammar []; nested exception is java.sql.SQLException: Incorrect syntax near 'UC'.
      Caused by: java.sql.SQLException: Incorrect syntax near 'UC'.
              at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
              at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
              at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
              at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
              at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
              at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
              at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
              at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1163)
              at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1116)
              at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
              at com.atlassian.bamboo.upgrade.tasks.UpgradeTask2704InitializeRepositoryChangesets$3.doInHibernate(UpgradeTask2704InitializeRepositoryChangesets.java:219)
              at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)

      The following SQL doesn't work on SQL Server 2005:

      update USER_COMMIT UC  
       set UC.REPOSITORY_CHANGESET_ID = ( 
         select REPOSITORY_CHANGESET_ID   
          from REPOSITORY_CHANGESET RC  
            where RC.BUILDRESULTSUMMARY_ID = UC.BUILDRESULTSUMMARY_ID)  
                   where UC.REPOSITORY_CHANGESET_ID is null ;
      

      Attachments

        Activity

          People

            jdumay James Dumay
            asridhar AjayA
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: