The issue occurs when attempting to download a relatively large dataset containing multiple dimensions such as data elements, periods, organisation units,
I have attached the HTML error file generated by DHIS2 for reference.
E7151 error code is mentioned in the documentation, here:
The number of column and row combinations which can be requested in table layout is limited by the keyAnalyticsDownloadCombinationLimit system setting, which defaults to 20000. The limit is applied separately to the column combinations and to the row combinations, not to their product. A request which exceeds it fails with error code E7151.
However, as @Karoline mentions here, this limit doesn’t apply to the /api/analytics endpoint, so you have two options:
Since this is a large amount of data, you could extract the data via the /api/analytics (you can quickly get the api request by using the DevTools F12 then check the Network tab, clear the log and then in the data visualizer app click update. You will see the API request appear in the log under the Network tab.
You can use the API to configure the keyAnalyticsDownloadCombinationLimit; however, this is a global setting and could affect your entire instance if more data download happens more than your instance could handle. Settings and configuration - DHIS2 Documentation
Please let me know if you need more info or details for any of the options. Thanks!
Hi @mansoor.kpu , were you able to resolve the issue? I hope my response was helpful. Thank you!
