Rollup queries fail to execute after you upgrade to ePO 5.10. Although first reported with Endpoint Security (ENS), it also applies to other rollup queries.
After you run a rollup query in the console, you see the following error:
An unexpected error occurred
The
Orion.log file
(ePO_install_directory\Server\Logs) records errors similar to the following:
ERROR [http-nio-8443-exec-6] servlet.ControllerServlet - Exception thrown by ActionBean:
java.lang.RuntimeException: error getting the row data from the datasourceat com.mcafee.orion.core.query.QueryChartDataSource.getChartData(QueryChartDataSource.java:215)
at com.mcafee.orion.console.ui.query.highcharts.charts.HighchartsSingleGroupSummaryTable.setColors(HighchartsSingleGroupSummaryTable.java:180)
at com.mcafee.orion.console.ui.query.highcharts.charts.HighchartsChart.populateRenderInfo(HighchartsChart.java:150)
at com.mcafee.orion.console.ui.query.highcharts.HighchartsAction.initializeChart(HighchartsAction.java:246)
at com.mcafee.orion.console.ui.query.highcharts.HighchartsAction.runSavedQuery(HighchartsAction.java:134)
Caused by: com.mcafee.orion.core.template.db.exception.ExecuteTransactionException: Invalid column name 'ExternalId'.
at com.mcafee.orion.core.template.db.JdbcTransaction.execute(JdbcTransaction.java:55)
at com.mcafee.orion.core.query.JDBCQueryExecutorService$DatabaseResolvingTx.execute(JDBCQueryExecutorService.java:140
Caused by: java.sql.SQLException: Invalid column name 'ExternalId'.