Problem running analytics on 2.41.4.1 and 2.41.4.2

Support - Assistance technique
1

Hi team,
I upgraded from 2.41.4.1 to 2.41.4.2 and still having the following issues with analytics

  1. When I open the analytics app, the “Skip generation of tracked entity data” and “Skip generation of outlier data” options are selected by default as in the screenshot below

    image
    image975×500 107 KB

  2. When I start analytics, it runs to the point where it needs to create analytics_event tables, then it fails with the below error in catalina.out

INFO 2025-07-21T21:36:06,567 Query failed, likely because the requested analytics table does not exist: (AnalyticsUtils.java [http-nio-8080-exec-5]) IDptZVLkAW9leS96sjr5HUgspbshsO19FoZwui+HI8YDc=
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select count(ax.“psi”) as value,ax.“uidlevel3”,ax.“monthly”,ax.“sZ3DCe8WrbD” as “mi1hbF4tinC.sZ3DCe8WrbD”,ax.“uMfREBn1pLQ” from analytics_event_nxjcecijiyg as ax where (ax.“monthly” in (‘202410’, ‘202411’, ‘202412’, ‘202501’, ‘202502’, ‘202503’, ‘202504’, ‘202505’, ‘202506’, ‘202507’) ) and ax.“uidlevel3” in (‘K3cb7CedppH’,‘z7EN37oPlH2’,‘CDWRhj3Cbv1’,‘zJLpGWyTRc7’,‘BzN9C03haLC’) and ax.“ps” = ‘mi1hbF4tinC’ and ax.“sZ3DCe8WrbD” in (2,1) and ax.“JddhZTlrLEv” in (‘Maison Faradja Kitumaini’) and ax.“yearly” in (‘2025’, ‘2024’) group by ax.“uidlevel3”, ax.“monthly”, ax.“sZ3DCe8WrbD”, ax.“uMfREBn1pLQ” limit 1000001]; nested exception is org.postgresql.util.PSQLException: ERROR: relation “analytics_event_nxjcecijiyg” does not exist
Position: 129

This started when I upgraded to 2.41.4.1, and now it persists even with the 2.41.4.2. Please, I need help

2

Hi @smomoh

Sorry to hear you’re facing this issue. I see that you have the last two options checked, however, could you also try unchecking them?

Additionally, before running the export, would you first run the Maintenance options in the Data Administration app? Maintenance > Reload apps, Clear Application, and Clear analytics tables.

If the issue persists, could you check that you can access the program with the id instance_url/api/29/programs/nxjcecijiyg.json or instance_urlapi/identifiableObjects/nxjcecijiyg ..