Program indicator issue

Hey @dhis2-tracker

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.

Is it a problem with my program indicator?

HI Herbert,

have you checked the period for when the data is entered especially enrolment dates if you used enrolment indicators.

Also ensure the code used for the options of sex are the same used used in the fielder ‘Female’ vs codes like M or 01…

Regards

3 Likes

Thanks @prosper

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?

1 Like

Hi Herbert,

I actually had a very similar issue recently, and using the option set code rather than the name fixed it. Hope that helps!

Monika

2 Likes

@monika is correct, the code should be used. Let us know if the issue persists or if this solved it :slight_smile:

1 Like

Thanks @Markus and @monika for proposing possible solutions but unfortunately it is still the same result, empty pivot table.

Any more suggestions?

1 Like

Hey, just a few other things to check:

The indicator needs to use the “Count” aggregation type if you are using any of the V{xyz_count} variables in the expression.

Analytics needs to be triggered.

If the option set code is number based, there should not be quotes in the expression:

Sex == 1

1 Like

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!

1 Like

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?

1 Like

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])
  • WARN 2019-01-18 14:03:34,677 RP discovery / realm validation disabled; (RealmVerifier.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:37,214 Version: 2.29, revision: 11d79d5, build date: Fri Jan 04 02:21:58 EAT 2019, database name: dhis2, database type: DhisPostgres, Java version: 1.8.0_191 (DefaultSystemService.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:37,240 SMS configuration not found (DefaultGatewayAdministrationService.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:37,266 Executing startup routine [1 of 18, runlevel 1]: InitTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:38,095 Executing startup routine [2 of 18, runlevel 2]: PeriodTypePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:38,102 Executing startup routine [3 of 18, runlevel 3]: DataElementDefaultDimensionPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:38,117 ‘system-process’ update org.hisp.dhis.dataelement.DataElementCategory, name: default, uid: GLevLNI9wkl (AuditLogUtil.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:38,278 Executing startup routine [4 of 18, runlevel 4]: IdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:38,741 Executing startup routine [5 of 18, runlevel 4]: ReportingIdentityPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:38,858 Executing startup routine [6 of 18, runlevel 5]: SchedulerUpgrade (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:38,860 Executing startup routine [7 of 18, runlevel 5]: TableCreator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:38,863 Executing startup routine [8 of 18, runlevel 6]: TableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:43,257 Tables updated (TableAlteror.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:43,258 Executing startup routine [9 of 18, runlevel 7]: TrackedEntityTableAlteror (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:43,872 Executing startup routine [10 of 18, runlevel 7]: ModelUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,897 Executing startup routine [11 of 18, runlevel 9]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,899 Executing startup routine [12 of 18, runlevel 9]: AnalyticalObjectEmbeddedDimensionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,902 Executing startup routine [13 of 18, runlevel 10]: FavoriteDataItemUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • WARN 2019-01-18 14:03:44,906 No html content for form: {“class”:“class org.hisp.dhis.dataentryform.DataEntryForm”, “id”:“590”, “uid”:“UTtagD2c2vu”, “code”:“null”, “name”:“DISCHARGE”, “created”:“2019-01-04 13:38:05.588”, “lastUpdated”:“2019-01-04 13:38:05.588” } (DataEntryFormUpgrader.java [localhost-startStop-1])
  • WARN 2019-01-18 14:03:44,906 No html content for form: {“class”:“class org.hisp.dhis.dataentryform.DataEntryForm”, “id”:“758”, “uid”:“YcLgZEEfSsZ”, “code”:“null”, “name”:“ADMISSION”, “created”:“2019-01-10 09:07:44.832”, “lastUpdated”:“2019-01-10 09:07:44.832” } (DataEntryFormUpgrader.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,906 Upgraded custom case entry form identifiers (DataEntryFormUpgrader.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,907 Executing startup routine [14 of 18, runlevel 11]: ExpressionUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,921 Executing startup routine [15 of 18, runlevel 12]: ConfigurationPopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • WARN 2019-01-18 14:03:44,921 Encryption not configured: encryption.password in dhis.conf too short, minimum 24 characters required (ConfigurationPopulator.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,923 Executing startup routine [16 of 18, runlevel 13]: I18nLocalePopulator (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,932 Executing startup routine [17 of 18, runlevel 14]: SchedulerStart (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,959 Setting up default jobs. (SchedulerStart.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,963 ‘system-process’ update org.hisp.dhis.scheduling.JobConfiguration, name: Data statistics, uid: FkrjiSmH5JW (AuditLogUtil.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,984 Scheduled job: FkrjiSmH5JW, Data statistics, DATA_STATISTICS, 0 0 2 ? * * (DefaultSchedulingManager.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,985 ‘system-process’ update org.hisp.dhis.scheduling.JobConfiguration, name: Validation result notification, uid: gX1jjlS2uZl (AuditLogUtil.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,991 Scheduled job: gX1jjlS2uZl, Validation result notification, VALIDATION_RESULTS_NOTIFICATION, 0 0 7 ? * * (DefaultSchedulingManager.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:44,991 ‘system-process’ update org.hisp.dhis.scheduling.JobConfiguration, name: Remove expired reserved values, uid: jce8e5kMqDe (AuditLogUtil.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,000 Scheduled job: jce8e5kMqDe, Remove expired reserved values, REMOVE_EXPIRED_RESERVED_VALUES, 0 0 * ? * * (DefaultSchedulingManager.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,001 ‘system-process’ update org.hisp.dhis.scheduling.JobConfiguration, name: Credentials expiry alert, uid: zVgFAo53BwZ (AuditLogUtil.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,018 Scheduled job: zVgFAo53BwZ, Credentials expiry alert, CREDENTIALS_EXPIRY_ALERT, 0 0 2 ? * * (DefaultSchedulingManager.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,020 ‘system-process’ update org.hisp.dhis.scheduling.JobConfiguration, name: Dataset notification, uid: YP1OXwRWb3Y (AuditLogUtil.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,027 Scheduled job: YP1OXwRWb3Y, Dataset notification, DATA_SET_NOTIFICATION, 0 0 2 ? * * (DefaultSchedulingManager.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,028 ‘system-process’ update org.hisp.dhis.scheduling.JobConfiguration, name: File resource clean up, uid: XmJvgqcUXFz (AuditLogUtil.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,034 Scheduled job: XmJvgqcUXFz, File resource clean up, FILE_RESOURCE_CLEANUP, 0 0 2 ? * * (DefaultSchedulingManager.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,061 no recipient (SmsMessageSender.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,062 ‘system-process’ create org.hisp.dhis.message.MessageConversation, name: Scheduler startup, uid: YZtSMauKdXi (AuditLogUtil.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,098 Executing startup routine [18 of 18, runlevel 14]: SettingUpgrader (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:45,104 All startup routines done (DefaultStartupRoutineExecutor.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:46,212 Version: 2.29, revision: 11d79d5, build date: Fri Jan 04 02:21:58 EAT 2019, database name: dhis2, database type: DhisPostgres, Java version: 1.8.0_191 (DefaultSystemService.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:46,213 SMS configuration not found (DefaultGatewayAdministrationService.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:46,266 Version: 2.29, revision: 11d79d5, build date: Fri Jan 04 02:21:58 EAT 2019, database name: dhis2, database type: DhisPostgres, Java version: 1.8.0_191 (DefaultSystemService.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:46,267 SMS configuration not found (DefaultGatewayAdministrationService.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:49,674 Version: 2.29, revision: 11d79d5, build date: Fri Jan 04 02:21:58 EAT 2019, database name: dhis2, database type: DhisPostgres, Java version: 1.8.0_191 (DefaultSystemService.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:49,675 SMS configuration not found (DefaultGatewayAdministrationService.java [localhost-startStop-1])
  • INFO 2019-01-18 14:03:50,336 Version: 2.29, revision: 11d79d5, build date: Fri Jan 04 02:21:58 EAT 2019, database name: dhis2, database type: DhisPostgres, Java version: 1.8.0_191 (DefaultSystemService.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
  • WARN 2019-01-18 14:04:28,661 Authentication event AuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@fffdaa08: RemoteIpAddress: 127.0.0.1; SessionId: 3B829F94F014EC4E355BC19F36898CA2 (LoggerListener.java [http-bio-8080-exec-6])
  • INFO 2019-01-18 14:04:28,669 ‘system-process’ update org.hisp.dhis.user.UserCredentials, name: HERBERT KIWALYA, uid: KvMx6c1eoYo (AuditLogUtil.java [http-bio-8080-exec-6])
  • WARN 2019-01-18 14:04:28,675 Authentication event SessionFixationProtectionEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@fffdaa08: RemoteIpAddress: 127.0.0.1; SessionId: 3B829F94F014EC4E355BC19F36898CA2 (LoggerListener.java [http-bio-8080-exec-6])
  • WARN 2019-01-18 14:04:28,676 Authentication event InteractiveAuthenticationSuccessEvent: admin; details: org.springframework.security.web.authentication.WebAuthenticationDetails@fffdaa08: RemoteIpAddress: 127.0.0.1; SessionId: 3B829F94F014EC4E355BC19F36898CA2 (LoggerListener.java [http-bio-8080-exec-6])
1 Like

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?

3 Likes

Dear Herbert,

Any luck on this issue?

If its still persisting, can you do one other thing, try changing to different relative periods monthly, quarterly… and lastly also try fixed period.

I have been noticing some strange behavior with program indicators and periods, for some period they run while in others they dont,

Regards

1 Like

Hi @prosper,

I tried relative periods too but still persists even with a fixed period. Not sure what to look out for now.

Thanks.

1 Like

Hi @herbert_kiwalya,

Did you manage to work around this?

Best,
James

1 Like

Oh yes. I switched the analytics type to ‘event’ from enrollment

2 Likes