| << Back to previous view |
|
[QB-1658] Unexpected exception raised when showing JUnit aggregated overview gadget
|
|
| Status: | Resolved |
| Project: | QuickBuild |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 5.0.24 |
| Type: | Bug | Priority: | Major |
| Reporter: | Steve Luo | Assigned To: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Remaining Estimate: | Unknown | Time Spent: | Unknown |
| Original Estimate: | Unknown | ||
| Description |
|
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 |