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)

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 ;