Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

QuickBuild

Recover from scm_activity problems #2828

#1
jossy ·
Hello!

Is there a possibility to recover from this Exception:

2014-05-27 10:14:04,749 [pool-1-thread-13271] ERROR com.pmease.quickbuild.DefaultBuildEngine - Error processing build request.
    com.pmease.quickbuild.plugin.report.engine.exception.DatabaseException: Failed executing update sql [DELETE FROM modifications WHERE buildId=921244] on database [...]\configurations\50820\reports\scm_activity\DEFAULT\scm_activity.h2.db
        at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.update(DbStore.java:203)
        at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.update(DbStore.java:179)
        at com.pmease.quickbuild.plugin.report.changes.generator.ChangesStatsGenerator.generate(ChangesStatsGenerator.java:78)
        at com.pmease.quickbuild.plugin.report.engine.contribution.publisher.StatisticsReportPublisher.doPublish(StatisticsReportPublisher.java:133)
        at com.pmease.quickbuild.plugin.report.engine.contribution.publisher.StatisticsReportPublisher.collectStatistics(StatisticsReportPublisher.java:111)
        at com.pmease.quickbuild.DefaultBuildEngine.process(DefaultBuildEngine.java:395)
        at com.pmease.quickbuild.DefaultBuildEngine.access$000(DefaultBuildEngine.java:130)
        at com.pmease.quickbuild.DefaultBuildEngine$2.run(DefaultBuildEngine.java:1081)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:744)
    Caused by: java.sql.SQLException: Table "MODIFICATIONS" not found; SQL statement:
    DELETE FROM modifications WHERE buildId=921244 [42102-175] Query: DELETE FROM modifications WHERE buildId=921244 Parameters: []
        at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
        at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:599)
        at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.update(DbStore.java:201)
        ... 12 more
  • replies 3
  • views 1195
  • stars 0
#2
steveluo ADMIN ·
So strange. What is your QuickBuild server version? Is this the first build for configuration 50820?

A possible resolution for this is deleting below directory:
${quickbulid-data-dir}\configurations\50820\reports\scm_activity

Note, after deleting this directory, all SCM changes for this configuration are lost. You can rebuild the SCM changes, please reference below page for details:

http://wiki.pmease.com/display/QB51/Reb ... ation+data
#3
jossy ·
It is Quickbuild version 5.1.22. There are around 15 builds in this configuration.
#4
steveluo ADMIN ·
If possible, please zip the directory below and send it to me [steve at pmease dot com]:
${qb-data-dir}/configurations/50820/reports/scm_activity
Log in to reply