dhis2-users team mailing list archive

["Laura E. Lincks" <laura.lincks@xxxxxxxxxxxxxxxxx>]

I just ran a Data Integrity check in the Data Maintenance app and see that
this issue is violating the following:
Category option combos not in data element category combo in data entry form

*Laura E. Lincks*
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132

On Fri, Jan 8, 2016 at 12:39 AM, Laura E. Lincks <
laura.lincks@xxxxxxxxxxxxxxxxx> wrote:

> DHIS version 2.19
> Build 19144
>
> We have an urgent issue which needs correction as soon as possible (we
> have a reporting deadline of Monday, 11 January.):
>
> We are collecting data via a Data Set/Data Entry screen for data elements
> which are categorized by 2 genders and 8 age groups. Three of the age
> categorizations for both genders are collecting the data via the data entry
> screen properly but are showing up as blanks when included in a pivot
> table. (The other 5 age groups for both genders are reporting properly in
> the same pivot table.)
>
> In looking at the data on the backend and querying the category option
> combinations, resource tables and analytics tables I see that there are
> multiple instances of many of the gender/age group categories. (For
> example, there are 4 (Female, 0-1 years) category option combos.) The data
> set and data entry screen are collecting the data properly but a no-longer
> used version of the category option combo is being pulled into the
> analytics table/pivot table for 3 of the 8 age groupings.
>
> There is no error in the log when running Analytics.
>
> The Data Set Report appears to display the proper data per the data entry
> screen (i.e., it does not mimic the incomplete Pivot Table report.)
>
> Is there a way to realign the category options so that what is used in the
> data entry screen is what flows through to the analytics table? Or is there
> a later build that corrects this problem?
>
> Thank you.
>
> *Laura E. Lincks*
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
>