We are testing 2.33 in our environment and everything is fine except that the reporting rates are not shown, neither in Pivot tables nor under Reports.(screenshot attached) The screen says successfully loaded the table, but no values are shown. There are no errors shown at the backend also. Analytics is complete and data is present.
We have had a couple reports of this issue, but we have not been able to reproduce in any of the databases we have access to. Could you please share the properties of the data set that is not showing reporting rates:
Do they have and category combinations applied?
Do they have custom data entry forms?
Have the data elements, category options, and data set shared with all users that need to see the reporting rate?
Are you able to share the logs or sql logs with us?
Yes category combinations applied to dataset because we capture datasets by donors and projects
Yes all forms are Custom data entry forms
I checked share settings and they seem to be ok, I am superuser, and in our present Productions ite which is 2.28 the reporting rates are working fine.
Thanks for these. Thank you also for testing first before you upgrade. This is often not the case.
You are correct that there are no errors in the server logs. Can you share with us also the sql logs, so that we can see if actual SQL query that should load the reporting rates 1) exist 2) is correct?
A few more questions:
Are you 100% sure that the category options have public viewing permissions? In 2.33 there is a new sharing model and each individual cat. option must be shared for viewing
That data sets are marked complete
That analytics tables have been run
And you have cleared your cache
Can you share with us also the sql logs, so that we can see if actual SQL query that should load the reporting rates 1) exist 2) is correct?
No we have not yet had a chance to, but Tanzania and Uganda have also reported the same issue and we are working with them to identify the cause. We are working off [DHIS2-8593] - Jira
We have identified that the issue (at least in Uganda and Tanzania) is that attribute category options that are assigned to the data set do not have any organizational units assigned to them. This must be done to enable DHIS2 to calculate the expected number of reports.
To address this issue:
Assign all catigory options that are assigned to a data set to the organizational units you expect to receive a report for.