Errors inside the Event Analysis Report related with "Top 25 events by node"
Description
This is related with a customer support ticket number 1007.
I've been talking with Ronny about a possible problem with the data displayed on the report, and he found that something is missing in certain SQL queries used in some parts of the report which is translated in some incorrect numbers for certain tables like "Top 25 events by node".
When this report is generated over a big database (with lots of nodes and events), the front page and the 2nd page of the report displays that there is a big number of events and events classified by UEI; but when you see the "Top 25 events by node", the order of magnitudes of the events count per node is very small compared with the numbers from the front page and 2nd page.
Environment
See https://mynms.opennms.com/Ticket/Display.html?id=4968 among others
Acceptance / Success Criteria
None
Lucidchart Diagrams
Activity
Jesse White July 31, 2019 at 6:44 PM
See follow up in .
Jeff Gehlbach March 9, 2017 at 2:46 PM
Reopening; see customer-supplied patch in .
Alejandro Galue February 13, 2012 at 2:11 PM
I can confirm that the top25_events_by_node_uei has the same problem as top25_events_by_node.
This is related with a customer support ticket number 1007.
I've been talking with Ronny about a possible problem with the data displayed on the report, and he found that something is missing in certain SQL queries used in some parts of the report which is translated in some incorrect numbers for certain tables like "Top 25 events by node".
When this report is generated over a big database (with lots of nodes and events), the front page and the 2nd page of the report displays that there is a big number of events and events classified by UEI; but when you see the "Top 25 events by node", the order of magnitudes of the events count per node is very small compared with the numbers from the front page and 2nd page.