History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-1658
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Steve Luo
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
QuickBuild

Unexpected exception raised when showing JUnit aggregated overview gadget

Created: 07/Jun/13 04:18 AM   Updated: 13/Jun/13 01:34 PM
Component/s: None
Affects Version/s: None
Fix Version/s: 5.0.24

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown


 Description  « Hide
When JUnit report is filtered, showing JUnit aggregated Overview gadget will raise below exception:

java.sql.SQLException: Syntax error in SQL statement "SELECT COUNT(*) AS TOTALS,SUM(DURATION) AS DURATION,SUM(TESTS) AS TESTS,SUM(ERRORS) AS ERRORS,SUM(FAILURES) AS FAILURES,SUM(SKIPS) AS SKIPS,SUM(SUCCESSES) AS SUCCESSES,AVG(SUCCESS_RATE) AS SUCCESS_RATE,SUM(ADDED) AS ADDED,SUM(NEWFAILED) AS NEWFAILED,SUM(NOTFIXED) AS NOTFIXED,SUM(FIXED) AS FIXED FROM AGG_OVERVIEW WHERE "; expected "NOT, EXISTS"; SQL statement:
SELECT COUNT(*) AS TOTALS,SUM(duration) AS duration,SUM(tests) AS tests,SUM(errors) AS errors,SUM(failures) AS failures,SUM(skips) AS skips,SUM(successes) AS successes,AVG(success_rate) AS success_rate,SUM(added) AS added,SUM(newFailed) AS newFailed,SUM(notFixed) AS notFixed,SUM(fixed) AS fixed FROM agg_overview WHERE [42001-159] Query: SELECT COUNT(*) AS TOTALS,SUM(duration) AS duration,SUM(tests) AS tests,SUM(errors) AS errors,SUM(failures) AS failures,SUM(skips) AS skips,SUM(successes) AS successes,AVG(success_rate) AS success_rate,SUM(added) AS added,SUM(newFailed) AS newFailed,SUM(notFixed) AS notFixed,SUM(fixed) AS fixed FROM agg_overview WHERE Parameters: []
     at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
     at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:399)
     at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.query(DbStore.java:87)
     at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.query(DbStore.java:59)
     at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.queryForMap(DbStore.java:148)
     at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel.loadReportStats(AbstractReportPanel.java:239)
     at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel$1.load(AbstractReportPanel.java:70)
     at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel$1.load(AbstractReportPanel.java:65)
     at org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:119)
     at com.pmease.quickbuild.plugin.report.engine.renderer.AbstractReportPanel.getReportStats(AbstractReportPanel.java:257)
     at com.pmease.quickbuild.plugin.report.engine.renderer.dashboard.AbstractDashboardStatsPanel.createItemContext(AbstractDashboardStatsPanel.java:66)
     at com.pmease.quickbuild.plugin.report.engine.renderer.dashboard.AbstractDashboardStatsPanel$1.load(AbstractDashboardStatsPanel.java:40)
     at com.pmease.quickbuild.plugin.report.engine.renderer.dashboard.AbstractDashboardStatsPanel$1.load(AbstractDashboardStatsPanel.java:34)
     at org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:119)
     at org.apache.wicket.Component.getDefaultModelObject(Component.java:1650)
     at com.pmease.quickbuild.plugin.report.engine.renderer.piechart.PieChartLegendPanel.getItemContext(PieChartLegendPanel.java:82)
     at com.pmease.quickbuild.plugin.report.engine.renderer.piechart.PieChartLegendPanel.getTotals(PieChartLegendPanel.java:69)
     at com.pmease.quickbuild.plugin.report.engine.renderer.piechart.PieChartLegendPanel.onInitialize(PieChartLegendPanel.java:32)
     at org.apache.wicket.Component.fireInitialize(Component.java:924)
     at org.apache.wicket.MarkupContainer$4.component(MarkupContainer.java:1007)
     at org.apache.wicket.MarkupContainer$4.component(MarkupContainer.java:1005)
     at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:143)
     at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:122)
     at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:191)
     at org.apache.wicket.MarkupContainer.visitChildren(MarkupContainer.java:923)
     at

 All   Comments   Work Log   Change History      Sort Order:
There are no comments yet on this issue.