Hi @Gassim
I’m not sure if this is bug issue, maybe I do something wrong or not complete. I search for community and someone has same issue but after run analytics tables update then issue is gone. May I try more and if not success then please help to create a jira bug issue for me.
I download the WHO package-COVID Vaccine to try and learn how to setup, e.g. data set, data element, category, etc. And enter some data, process analytic tables, and still not show any data in data visualizer.
Please advise if additional steps for me to try.
When I run update analytics tables, progress show below:
|2022-02-23 09:33:52|Analytics table update process started |
|---|---|
|2022-02-23 09:33:52|Updating resource tables |
|2022-02-23 09:34:19|Updating tables: DATA_VALUE |
|2022-02-23 09:34:20|Performing pre-create table work |
|2022-02-23 09:34:20|Dropping temp tables |
|2022-02-23 09:34:20|Creating analytics tables |
|2022-02-23 09:34:20|Populating analytics tables |
|2022-02-23 09:34:20|Invoking analytics table hooks |
|2022-02-23 09:34:20|Applying aggregation levels |
|2022-02-23 09:34:20|Creating indexes |
|2022-02-23 09:34:20|Analyzing analytics tables |
|2022-02-23 09:34:20|Removing updated and deleted data |
|2022-02-23 09:34:20|Swapping analytics tables |
|2022-02-23 09:34:20|Table update done |
|2022-02-23 09:34:20|Updating tables: COMPLETENESS |
|2022-02-23 09:34:20|Performing pre-create table work |
|2022-02-23 09:34:20|Dropping temp tables |
|2022-02-23 09:34:20|Creating analytics tables |
|2022-02-23 09:34:20|Populating analytics tables |
|2022-02-23 09:34:20|Invoking analytics table hooks |
|2022-02-23 09:34:20|Applying aggregation levels |
|2022-02-23 09:34:20|Creating indexes |
|2022-02-23 09:34:20|Analyzing analytics tables |
|2022-02-23 09:34:20|Removing updated and deleted data |
|2022-02-23 09:34:20|Swapping analytics tables |
|2022-02-23 09:34:20|Table update done |
|2022-02-23 09:34:20|Updating tables: COMPLETENESS_TARGET |
|2022-02-23 09:34:20|Performing pre-create table work |
|2022-02-23 09:34:20|Dropping temp tables |
|2022-02-23 09:34:20|Creating analytics tables |
|2022-02-23 09:34:20|Populating analytics tables |
|2022-02-23 09:34:20|Invoking analytics table hooks |
|2022-02-23 09:34:20|Applying aggregation levels |
|2022-02-23 09:34:20|Creating indexes |
|2022-02-23 09:34:20|Analyzing analytics tables |
|2022-02-23 09:34:20|Removing updated and deleted data |
|2022-02-23 09:34:20|Swapping analytics tables |
|2022-02-23 09:34:21|Table update done |
|2022-02-23 09:34:21|Updating tables: ORG_UNIT_TARGET |
|2022-02-23 09:34:21|Performing pre-create table work |
|2022-02-23 09:34:21|Dropping temp tables |
|2022-02-23 09:34:21|Creating analytics tables |
|2022-02-23 09:34:21|Populating analytics tables |
|2022-02-23 09:34:21|Invoking analytics table hooks |
|2022-02-23 09:34:21|Applying aggregation levels |
|2022-02-23 09:34:21|Creating indexes |
|2022-02-23 09:34:21|Analyzing analytics tables |
|2022-02-23 09:34:21|Removing updated and deleted data |
|2022-02-23 09:34:21|Swapping analytics tables |
|2022-02-23 09:34:21|Table update done |
|2022-02-23 09:34:21|Updating tables: EVENT |
|2022-02-23 09:34:21|No events exist, not updating event analytics tables |
|2022-02-23 09:34:21|Updating tables: VALIDATION_RESULT |
|2022-02-23 09:34:21|No validation results exist, not updating validation result analytics tables |
|2022-02-23 09:34:21|Updating tables: ENROLLMENT |
|2022-02-23 09:34:21|No events exist, not updating event analytics tables |
|2022-02-23 09:34:21|Analytics tables updated: 00:00:28.891 |
There is no error in network tab this time.
In PostgreSQL, only ‘analytics_completenesstarget’ and ‘analytics_orgunittarget’ has some data, the others has no data.
Thank you!