We are facing an issue with ‘validation rule analysis’ app in one of the production servers, which we are unable to reproduce in our local instances.
The data entered aligns to the validation rule. But while validating, we are getting error saying that the values do not align with the validation rule, showing some different values.
Here, the validation rule is ‘left expr should be <= right expr’, and the values that were given are 46 and 46. But is shown as below:
But when we see the details, it gives correct values that we entered in data entry app.
In DB also it shows correct values that we entered in the data entry app.
This is happening only for this particular week. The data in other weeks are not causing this issue.
We use DHIS version 2.37.8.1. We have cleared the browser cache, cleared analytics tables and performed maintenance and ran analytics. Also tried in incognito mode. But nothing worked.
So in the Validation Rule Analysis app it’s showing the value to be 14 whereas in the Data Entry app, it’s showing the value to be 42?
I’ll ask and look around if there’s a known issue related to this but thought it might be worth asking if you ran Maintenance to Permanently delete soft deleted values?
Additionally, would it be possible to update to 2.37.10 (the latest stable release for 2.37)? It is possible that this has been fixed if it’s actually a bug.
In Validation Rule Analysis app,
For one data element, it’s showing the value 42 but in Data Entry app 46.
For another data element, it’s showing the value 14 but in Data Entry app 46.
Have you found the solution?
I have the same, even if I have changed the value and rerun all analytics table, somehow validation rule picking up old and unexisting values… Have no idea where and how it is getting those values.