Dear DHIS2 community… We would like to share our Palestine dhis2 country team issue faced with covid-19 system. Below, please find a list of events and should you have any questions that we could share with them please let us know.
1- On Tuesday: 8th Sept 2020 the team created a new tracked entity attributes (as highlighted below in bold) over four programs: Case reporting, Isolation, Quarantine, and Lab. with related program rules according to the requested requirements
2- On Friday: 18th of Sept, 2020, and after a while of work on the system, a team member separated two data attributes named reporting date, and sampling date from taking the same date from each other and I have deleted related program rules accordingly.
3- Later on Friday: 18th a new report for educational sector requested to get the count of Yes, and count of No for tracked entity attribute named “Educational sector” and have value type (Yes/No).
The team created a program indicator with expression:
V{event_count}
Filter:
V{program_stage_id} == ‘FoAL3P52s3q’ && A{zxZGI6RmBOV} == ‘Yes’
Then we tried to extract event report by select any attribute that used for education sector, but no data shown in the report but only shows that there are many pages but the data is hidden.
But when we select other attribute the report works normally.
So we removed the attributes added lately from tracked entity, delete them from system and create new one, but the same problem happened when extract report.
We create new tracked entity and new attributes in addition to use some of old attributes and add this tracked entity to new program. When we extract report from this program (attributes and data element), everything works normally.
Note: number of attributes added to new tracked entity is less than attributes exist in old tracked entity.
There’s a problem in “COVID19_Day Totals without Jerusalem” event program, the indicators for total samples & total positive samples are working fine but the other indicators are empty and no value in pivot table although they are filled in the event.
Also tested those indicators in Event report but unfortunately there are no values, the report shows that there are 12 pages but the data is hidden.
{“headers”:[{“name”:“psi”,“column”:“Event”,“valueType”:“TEXT”,“type”:“java.lang.String”,“hidden”:false,“meta”:true},{“name”:“ps”,“column”:“Program stage”,“valueType”:“TEXT”,“type”:“java.lang.String”,“hidden”:false,“meta”:true},{“name”:“eventdate”,“column”:“Event date”,“valueType”:“DATE”,“type”:“java.util.Date”,“hidden”:false,“meta”:true},{“name”:“geometry”,“column”:“Geometry”,“valueType”:“TEXT”,“type”:“java.lang.String”,“hidden”:false,“meta”:true},{“name”:“longitude”,“column”:“Longitude”,“valueType”:“NUMBER”,“type”:“java.lang.Double”,“hidden”:false,“meta”:true},{“name”:“latitude”,“column”:“Latitude”,“valueType”:“NUMBER”,“type”:“java.lang.Double”,“hidden”:false,“meta”:true},{“name”:“ouname”,“column”:“Organisation unit name”,“valueType”:“TEXT”,“type”:“java.lang.String”,“hidden”:false,“meta”:true},{“name”:“oucode”,“column”:“Organisation unit code”,“valueType”:“TEXT”,“type”:“java.lang.String”,“hidden”:false,“meta”:true},{“name”:“ou”,“column”:“Organisation unit”,“valueType”:“TEXT”,“type”:“java.lang.String”,“hidden”:false,“meta”:true},{“name”:“vuq0H4jTKii”,“column”:“COVID19_DTwJ_Total number of daily samples”,“valueType”:“NUMBER”,“type”:“java.lang.Double”,“hidden”:false,“meta”:true},{“name”:“L8ESNhvMtBG”,“column”:“COVID19_DTwJ_Total number of positive cases”,“valueType”:“NUMBER”,“type”:“java.lang.Double”,“hidden”:false,“meta”:true},{“name”:“ptGZ7jtwkow”,“column”:“COVID19_DTwJ_Total number of daily samples / A G Rapid test”,“valueType”:“NUMBER”,“type”:“java.lang.Double”,“hidden”:false,“meta”:true},{“name”:“pn7ZnSzJz25”,“column”:“COVID19_DTwJ_Total number of daily samples / PCR”,“valueType”:“NUMBER”,“type”:“java.lang.Double”,“hidden”:false,“meta”:true},{“name”:“kCDRgkRv24U”,“column”:“COVID19_DTwJ_Total number of positive cases/ A. G. rapid test”,“valueType”:“NUMBER”,“type”:“java.lang.Double”,“hidden”:false,“meta”:true},{“name”:“yzHuW73my7i”,“column”:“COVID19_DTwJ_Total number of positive cases/ PCR”,“valueType”:“NUMBER”,“type”:“java.lang.Double”,“hidden”:false,“meta”:true}],“metaData”:{“pager”:{“page”:1,“total”:116,“pageSize”:100,“pageCount”:2},“items”:{“GJUeRtsjd2I”:{“name”:“COVID19_Day Totals without Jerusalem”},“y3Cdg4OoTOc”:{“name”:“COVID19_Day Totals without Jerusalem”},“pn7ZnSzJz25”:{“name”:“COVID19_DTwJ_Total number of daily samples / PCR”},“GD7TowwI46c”:{“name”:“Palestine”},“L8ESNhvMtBG”:{“name”:“COVID19_DTwJ_Total number of positive cases”},“vuq0H4jTKii”:{“name”:“COVID19_DTwJ_Total number of daily samples”},“ou”:{“name”:“Organisation unit”},“yzHuW73my7i”:{“name”:“COVID19_DTwJ_Total number of positive cases/ PCR”},“ptGZ7jtwkow”:{“name”:“COVID19_DTwJ_Total number of daily samples / A G Rapid test”},“kCDRgkRv24U”:{“name”:“COVID19_DTwJ_Total number of positive cases/ A. G. rapid test”}},“dimensions”:{“pn7ZnSzJz25”:[],“L8ESNhvMtBG”:[],“pe”:[],“vuq0H4jTKii”:[],“ou”:[“GD7TowwI46c”],“yzHuW73my7i”:[],“ptGZ7jtwkow”:[],“kCDRgkRv24U”:[]}},“rows”:[],“width”:0,“height”:0,“headerWidth”:15}
Has anyone run into a similar issue? or have input that I could share with the team? We appreciate your help due to the urgency.
Thank you again from Palestine Country Team. @ataallah @mbaniode @ayman.tuffaha @Alaa Abu_Aisha @hanin.saadah