doughnutguy

This is critically important to my organization. We need the monitoring subsystem to be keeping track of the reports and the report execution times, so that we know how long our reports are taking to execute as we have SLAs to meet and we need to track this information so we know if we are meeting our SLAs or not. Why is the REPORT_URI field null for every row in the jireportmonitoringfact table in which event_type = 'runReport'? Why is the RESOURCE_URI field null for row in the jiauditevent table in which event_type = 'runReport'? Does anyone know how we can fix this? Help!!!!

Hello everyone. I recently enabled report monitoring on my JasperServer system, hoping to be able to see how long my reports were running so I could get baseline data. However, after enabling monitoring, I ran into a big problem where the REPORT_URI field is null for every report that was run. Because of this I can see data on my report runs, like time it was run, execution time, and who ran it, but I have no clue which report they ran!! Without the REPORT_URI data, the Report Monitoring feature is essentially useless. Does anyone know why this field might be null for every report run? How can I fix this? Thanks for your help.

Hello everyone. I have enabled monitoring on my JasperServer system and so I am looking in the JIREPORTMONITORINGFACT table at the monitoring data. However this table seems to be missing some very critical information - namely, the actual report that was run! It contains the user that run the report, as well as the time it was run and the execution time of the report, but it does not contain any indication at all of the actual report that was run. It does contain REPORT_URI, but that is null for 90% of the rows in the table. How can I figure out what report was run? This data is basically useless without that information. I did look in some other tables to see if I could use the ID as a key in another table to find the data, but frustratingly the JIACCESSEVENT table skips all the IDs which are in the JIMONITORINGFACT table. What table uses the JIREPORTMONITORINGFACT.ID field as a foriegn key? I really hope there is one, otherwise this data (and by extension, the entire feature) is entirely useless.