An unexpected error occurred (rollup queries fail to execute in ePO 5.10)
Last Modified: 2023-03-27 15:18:56 Etc/GMT
Affected Products
Languages:
This article is available in the following languages:
Trellix CEO, Bryan Palma, explains the critical need for security that’s always learning.
As per Gartner, "XDR is an emerging technology that can offer improved threat prevention, detection and response."
Trellix announced the establishment of the Trellix Advanced Research Center to advance global threat intelligence.
Trellix Advanced Research Center analyzes threat data on ransomware, nation-states, sectors, vectors, LotL, MITRE ATT&CK techniques, and emails.
As of May 14, 2024, Knowledge Base (KB) articles will only be published and updated in our new Trellix Thrive Knowledge space.
Log in to the Thrive Portal using your OKTA credentials and start searching the new space. Legacy KB IDs are indexed and you will be able to find them easily just by typing the legacy KB ID.
An unexpected error occurred (rollup queries fail to execute in ePO 5.10)
Technical Articles ID:
KB91498
Last Modified: 2023-03-27 15:18:56 Etc/GMT Environment
ePolicy Orchestrator (ePO) 5.10.0, 5.10 Update 1
Problem
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: The 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'. System Change
You installed or upgraded to ePO 5.10.0.
Cause
ePO 5.10.0 adds a database view for rolled-up product properties. This view is missing the Solution
ePolicy Orchestrator 5.10.0 Update 2 resolves this issue, and is available from the Product Downloads site. NOTE: You need a valid Grant Number for access. To view other known and resolved issues, see KB90382 - ePolicy Orchestrator 5.10.x Known Issues. NOTE: You might also need to run the corresponding rollup server task after you apply the Cumulative Update 2 or later. This action creates the missing Affected ProductsLanguages:This article is available in the following languages: |
|