I created a basic program indicator in dhis2 2.29 that counts number of female and male. I used the V{tei_count} expression and Sex == ‘Female’ filter.
Surprisingly when i go to pivot tables / charts, nothing shows up in the tables as though i do not have female and male, but i actually do.
Yes i checked the period, tried selecting the whole year just to be sure but still no results in the pivot tables.
About the code, i used the actual name used in the option set opposed to the code. Isn’t that right?
Hey @Markus, i am using the count aggregation type. My option set is text based.I had not triggered analytics, just did in the reports app but still nothing shows up in the pivot table!
Ok, with analytics triggered we have one problem out of the way. Can you get the server log and see what is logged when you try to query your indicator in pivot tables?
This is the log right from the start of the server to the empty pivot tables
nnu1@nnu:/home/dhis$ sudo tail -f tomcat-dhis/logs/catalina.out
Jan 18, 2019 2:02:58 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 656 ms
Jan 18, 2019 2:02:58 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Jan 18, 2019 2:02:58 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.68 (Ubuntu)
Jan 18, 2019 2:02:58 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive /home/dhis/tomcat-dhis/webapps/ROOT.war
Jan 18, 2019 2:03:07 PM org.apache.catalina.startup.TldConfig execute
INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
INFO 2019-01-18 14:03:11,458 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
INFO 2019-01-18 14:03:11,461 Environment variable DHIS2_HOME points to /home/dhis/config (DefaultLocationManager.java [localhost-startStop-1])
INFO 2019-01-18 14:03:11,477 File /home/dhis/config/dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
INFO 2019-01-18 14:03:11,478 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
INFO 2019-01-18 14:03:11,479 File /home/dhis/config/dhis-google-auth.json does not exist (DefaultLocationManager.java [localhost-startStop-1])
INFO 2019-01-18 14:03:11,479 Could not find dhis-google-auth.json (DefaultDhisConfigurationProvider.java [localhost-startStop-1])
INFO 2019-01-18 14:03:12,982 Hibernate configuration loaded, using dialect: org.hisp.dhis.hibernate.dialect.DhisPostgresDialect, region factory: org.hibernate.cache.ehcache.EhCacheRegionFactory (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])
INFO 2019-01-18 14:03:26,328 Old apps folder does not exist, stopping discovery (LocalAppStorageService.java [localhost-startStop-1])
INFO 2019-01-18 14:03:27,493 File store configured with provider: ‘filesystem’, container: ‘files’ and location: ‘’. (JCloudsAppStorageService.java [localhost-startStop-1])
INFO 2019-01-18 14:03:27,494 Starting JClouds discovery (JCloudsAppStorageService.java [localhost-startStop-1])
INFO 2019-01-18 14:03:27,499 No apps found during JClouds discovery. (JCloudsAppStorageService.java [localhost-startStop-1])
INFO 2019-01-18 14:03:29,607 File store configured with provider: ‘filesystem’, container: ‘files’ and location: ‘’. (JCloudsFileResourceContentStore.java [localhost-startStop-1])
INFO 2019-01-18 14:03:29,747 Found the following message senders: [org.hisp.dhis.message.EmailMessageSender@5644cf36, org.hisp.dhis.sms.config.SmsMessageSender@4fd7ecbe] (DefaultMessageService.java [localhost-startStop-1])
INFO 2019-01-18 14:03:29,987 Read only configuration initialized, read replicas found: 0 (DefaultDataSourceManager.java [localhost-startStop-1])
INFO 2019-01-18 14:03:32,023 Following listners are registered: [org.hisp.dhis.sms.listener.DataValueSMSListener@627c3100, org.hisp.dhis.sms.listener.J2MEDataValueSMSListener@32d41aa9, org.hisp.dhis.sms.listener.UnregisteredSMSListener@620c8a0c, org.hisp.dhis.sms.listener.DhisMessageAlertListener@735180a7, org.hisp.dhis.sms.listener.TrackedEntityRegistrationSMSListener@4378fab1, org.hisp.dhis.sms.listener.ProgramStageDataEntrySMSListener@510a5017, org.hisp.dhis.sms.listener.SingleEventListener@89f6cf7] (SmsConsumerThread.java [localhost-startStop-1])
INFO 2019-01-18 14:03:32,187 SMS consumer started (DefaultSmsConsumerService.java [localhost-startStop-1])
INFO 2019-01-18 14:03:33,387 Scheduled monitoring service (DefaultMonitoringService.java [localhost-startStop-1])
INFO 2019-01-18 14:03:33,919 Added logger: org.hisp.dhis.resourcetable using file: /home/dhis/config/logs/dhis-analytics-table.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
INFO 2019-01-18 14:03:33,919 Added logger: org.hisp.dhis.analytics.table using file: /home/dhis/config/logs/dhis-analytics-table.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
INFO 2019-01-18 14:03:33,920 Added logger: org.hisp.dhis.dxf2 using file: /home/dhis/config/logs/dhis-data-exchange.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
INFO 2019-01-18 14:03:33,920 Added logger: org.hisp.dhis.dxf2.synch using file: /home/dhis/config/logs/dhis-data-sync.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
INFO 2019-01-18 14:03:33,920 Added logger: org.hisp.dhis.dxf2.metadata using file: /home/dhis/config/logs/dhis-metadata-sync.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
INFO 2019-01-18 14:03:33,920 Added logger: org.hisp.dhis.pushanalysis using file: /home/dhis/config/logs/dhis-push-analysis.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
INFO 2019-01-18 14:03:33,921 Added root logger using file: /home/dhis/config/logs/dhis.log (Log4JLogConfigInitializer.java [localhost-startStop-1])
INFO 2019-01-18 14:03:34,444 Session timeout set to 3600 seconds (DefaultAuthenticationSuccessHandler.java [localhost-startStop-1])
INFO 2019-01-18 14:03:50,337 SMS configuration not found (DefaultGatewayAdministrationService.java [localhost-startStop-1])
Jan 18, 2019 2:03:50 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deployment of web application archive /home/dhis/tomcat-dhis/webapps/ROOT.war has finished in 52,170 ms
Jan 18, 2019 2:03:50 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-bio-8080”]
Jan 18, 2019 2:03:50 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 52245 ms
There is no error in the logs - and that would indicate that the indicator runs fine, but there is actually no data that is matching the indicators criteria. Can you do a event query in event reports, and find a few concrete examples of events that matches the period and organisation unit you are querying in pivot tables?