dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi there,

the problem here is that column a99ecb2c5c3 does not exist in the analytics
table. This corresponds to the "Type2" category, which is correctly set to
type disaggregation and use as data dimension. In fact, none of the
categories become columns/dimensions in analytics.

When I run your database with trunk it woks fine, see screenshot.

The error must exist somewhere in the tw branch. The interesting method is
this:

JdbcAnalyticsTableManager.getDimensionColumns  (around line 227).

Can you please debug the call to

Collection<DataElementCategory> disaggregationCategories =
            categoryService.getDisaggregationDataDimensionCategories();

and check which categories, if any, it returns? If you can make this call
return all categories of type disaggregation and with data dimension to
true then the problem should be gone.

regards,

Lars

Attachment: datasetreport.png
Description: PNG image