Event Reports not showing data for this year

joneslikoro · 13 February 2025 09:42

Good day Community,
We have stumbled in an issue, we have data back from January 2001 up until December 2024, usually we would run the analytics and they are updated and included, but for some strange reasons, we are not able to see the data that has been captured this year (2025), as it only stores until 2024.
here are the results attached.

And some logs `* INFO 2025-02-13 08:35:40,056 Swapping table, master table exists: true, skip master table: false (AbstractJdbcTableManager.java [taskScheduler-13])

WARN 2025-02-13 08:35:40,104 Validation failed for SQL view ‘Vv5W3xUY3hW’: SQL query contains references to protected tables (DefaultSqlViewService.java [taskScheduler-13])
WARN 2025-02-13 08:35:40,105 Ignoring SQL view which failed validation: Vv5W3xUY3hW, List Users, message: SQL query contains references to protected tables (DefaultResourceTableService.java [taskScheduler-13])
INFO 2025-02-13 08:35:40,116 Table update done: analytics_orgunittarget: 00:00:00.172 (Clock.java [taskScheduler-13])
INFO 2025-02-13 08:35:40,117 [Level: INFO, category: ANALYTICS_TABLE, time: Thu Feb 13 08:35:40 UTC 2025, message: Table update done] (InMemoryNotifier.java [taskScheduler-13])
INFO 2025-02-13 08:35:40,117 [Level: INFO, category: ANALYTICS_TABLE, time: Thu Feb 13 08:35:40 UTC 2025, message: Updating tables: EVENT] (InMemoryNotifier.java [taskScheduler-13])
INFO 2025-02-13 08:35:40,118 Analytics table update parameters: AnalyticsTableUpdateParams{last years=null, skip resource tables=false, skip table types=, start time=Thu Feb 13 08:35:29 UTC 2025} (DefaultAnalyticsTableService.java [taskScheduler-13])
INFO 2025-02-13 08:35:40,118 Starting update: analytics_event, processes: 15, org unit levels: 5: 00:00:00.000 (Clock.java [taskScheduler-13])
INFO 2025-02-13 08:35:40,122 Get tables using earliest: null, spatial support: true (JdbcEventAnalyticsTableManager.java [taskScheduler-13])
INFO 2025-02-13 08:35:43,383 Table update start: analytics_event, earliest: null, parameters: AnalyticsTableUpdateParams{last years=null, skip resource tables=false, skip table types=, start time=Thu Feb 13 08:35:29 UTC 2025}: 00:00:03.265 (Clock.java [taskScheduler-13])
INFO 2025-02-13 08:35:43,384 [Level: INFO, category: ANALYTICS_TABLE, time: Thu Feb 13 08:35:43 UTC 2025, message: Performing pre-create table work, org unit levels: 5] (InMemoryNotifier.java [taskScheduler-13])
INFO 2025-02-13 08:35:43,384 Performed pre-create table work: 00:00:03.265 (Clock.java [taskScheduler-13])
INFO 2025-02-13 08:35:43,384 [Level: INFO, category: ANALYTICS_TABLE, time: Thu Feb 13 08:35:43 UTC 2025, message: Dropping temp tables] (InMemoryNotifier.java [taskScheduler-13])
INFO 2025-02-13 08:35:43,385 Dropped temp tables: 00:00:03.267 (Clock.java [taskScheduler-13])`

Gassim · 14 February 2025 19:03

Hi @joneslikoro

Thank you for your detailed post. May I ask you if you’ve entered data after 2025W1? If you have entered data for periods after 2025W1 then you should start seeing the data again (this has been fixed for future versions). The issue you’re seeing seems similar to this issue: Capture Data not reflecting on analytics app - #46 by Gassim

Please let us know if you’re seeing this issue even after you’ve entered data for the periods after 2025W1.

Thank you!

joneslikoro · 19 February 2025 10:55

sorry for the late reply, yes we have, every week up to today right now

Hi @Gassim , so basically i need to upgrade to version 2.40.7 for example?

Gassim · 20 February 2025 14:07

Thanks for the info. The expectation is that once you have entered data for dates after 2025W1 [fixed for future releases], the data will start to show again, but it’s possible we’re seeing another issue here.

Looking at the log you shared it appears we’re facing another issue related to the SQL Views in your instance. So this one is not related to the Event Reports app.

Would you please check by using the Line Listing app to see if you actually get the data that’s no showing in the Event Reports app? If the data is not showing in both apps then it’s no specific to the app and we’ll need to dig further. Any other errors or warnings in the Catalina.out log?

Thanks!