I have some data captured for some OUs. After I exported data using the Data Administration app, I check with the Data Visualizer app and no data is showing.
Meanwhile, I can confirm that in some facilities, the data was showing but not showing for some. I can also confirm that the data is stored in the datavalue table in the database. Any possible reason why the data is not showing?
Confirms that the sharing settings for the data set are configured properly. However, it might be that some of these facilities are not properly assigned to the user? Could you check the OUs assigned to the user?
Using your browser’s Guest mode, would you open the page where the values are not appearing and after opening the Network tab as well as the Console in the DevTools (F12) refresh the page? Are you seeing any errors could you take screenshots of these error messages?
Well I wish I could. But I used a custom app to capture the data. All I can say is that we are getting the data in the Data Visualizer app for some facilities but for others it is not showing. I check the database and can confirm that the data is in the datavalue table but it’s not showing in the Data Visualizer app. And I am using the same facility OU to capture data for other dataset which we can access with the Data Visualizer app.
I don’t know why data stored in datatvalue table is not being exported for analytics.
It would be good to try and confirm that the data is also in the analytics tables. You had mentioned its in the raw data tables (datavalue). What about the analytics tables? Did you check there as well?
I would suggest you check your DHIS2 server logs when you are attempting to get data for these particular organisation units. I have seen situations where the geometry of an organisation unit is corrupt, and may cause an analytics query to fail. This may not be apparent through the browser, but it is visible in the server logs.
If it is still not visible in the server logs, then you may need to enable Postgresql logging and see if you see anything there.
The analytics tables are partitioned by year, so each of those tables “analytics_2022” etc contains data for the referenced year. The “dx” column contains the data element UID, and the “ou” column the organisation unit UID. Have a look in one of those tables and see if the data is present.