Category combinations are not being generated properly

Hi Team,

We are using dhis 2.21 and we have a category combination created for 3 dis-aggregations.

Population 1, Population2 (Population)

<5 y.o, >5 y.o (Age)

Male, Female, Undisclosed (gender)

Once category combinations are generated, we can see few extra combinations coming up like

just population1 or population2. Please find the screenshot attached.

Is there something that we are missing or doing wrong. Please help us resolve this.

Thanks and Regards,

Sultan Ahamar,

Thought Works
Hyderabad

image

Hi Sultan,

could you make sure that you do not have a category combination with only the population category in your system?

regards,

Lars

···

On Wed, Mar 2, 2016 at 1:21 PM, Sultanahamar Mohammad sultanm@thoughtworks.com wrote:

Hi Team,

We are using dhis 2.21 and we have a category combination created for 3 dis-aggregations.

Population 1, Population2 (Population)

<5 y.o, >5 y.o (Age)

Male, Female, Undisclosed (gender)

Once category combinations are generated, we can see few extra combinations coming up like

just population1 or population2. Please find the screenshot attached.

Is there something that we are missing or doing wrong. Please help us resolve this.

Thanks and Regards,

Sultan Ahamar,

Thought Works
Hyderabad


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Sultan,

I have seen this in our system and suppose it comes from old dataValues, that
were loaded /entered before I added a new category into an existing
categoryCombination. The old values were still coded on the old
categoryOptionCombinations where the new category was missing.

I assume that DHIS2 does not delete obsolete categoryOptionCombinations, as long
as there are still dataValues linked to them.

Does that make sense, Lars?

Regards, Uwe

···

Lars Helge Øverland <lars@dhis2.org> hat am 2. März 2016 um 15:24 geschrieben:

Hi Sultan,

could you make sure that you do not have a category combination with only
the population category in your system?

regards,

Lars

On Wed, Mar 2, 2016 at 1:21 PM, Sultanahamar Mohammad < > sultanm@thoughtworks.com> wrote:

> Hi Team,
>
> We are using dhis 2.21 and we have a category combination created for 3
> dis-aggregations.
> Population 1, Population2 (Population)
> <5 y.o, >5 y.o (Age)
> Male, Female, Undisclosed (gender)
>
> Once category combinations are generated, we can see few extra
> combinations coming up like
> just population1 or population2. Please find the screenshot attached.
>
> Is there something that we are missing or doing wrong. Please help us
> resolve this.
>
> Thanks and Regards,
> Sultan Ahamar,
> Thought Works
> Hyderabad
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>

--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org/&gt;
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Hi Sultan,

I have seen this in our system and suppose it comes from old dataValues,
that
were loaded /entered before I added a new category into an existing
categoryCombination. The old values were still coded on the old
categoryOptionCombinations where the new category was missing.

I assume that DHIS2 does not delete obsolete categoryOptionCombinations,
as long
as there are still dataValues linked to them.

Does that make sense, Lars?

Yes correct, that is a possibility.

Lars

···

On Wed, Mar 2, 2016 at 2:10 PM, Uwe Wahser <uwe@wahser.de> wrote:

Regards, Uwe

> Lars Helge Øverland <lars@dhis2.org> hat am 2. März 2016 um 15:24
geschrieben:
>
>
> Hi Sultan,
>
> could you make sure that you do not have a category combination with only
> the population category in your system?
>
> regards,
>
> Lars
>
>
> On Wed, Mar 2, 2016 at 1:21 PM, Sultanahamar Mohammad < > > sultanm@thoughtworks.com> wrote:
>
> > Hi Team,
> >
> > We are using dhis 2.21 and we have a category combination created for
3
> > dis-aggregations.
> > Population 1, Population2 (Population)
> > <5 y.o, >5 y.o (Age)
> > Male, Female, Undisclosed (gender)
> >
> > Once category combinations are generated, we can see few extra
> > combinations coming up like
> > just population1 or population2. Please find the screenshot attached.
> >
> > Is there something that we are missing or doing wrong. Please help us
> > resolve this.
> >
> > Thanks and Regards,
> > Sultan Ahamar,
> > Thought Works
> > Hyderabad
> >
> >
> >
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to : dhis2-devs@lists.launchpad.net
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help : https://help.launchpad.net/ListHelp
> >
> >
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org/&gt;
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help : https://help.launchpad.net/ListHelp

--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org <https://www.dhis2.org/&gt;

Hi Lars,

we do not have any data related to the old category combinations. So we performed the maintenance selecting the “Update category option combinations” but still we see those orphan category option combinations. We have only one category combination(Age, location, dim) right now. Is there anything that we are missing here.

Thanks,

Sultan Ahamar.

···

On Wed, Mar 2, 2016 at 6:43 PM, Lars Helge Øverland lars@dhis2.org wrote:

On Wed, Mar 2, 2016 at 2:10 PM, Uwe Wahser uwe@wahser.de wrote:

Hi Sultan,

I have seen this in our system and suppose it comes from old dataValues, that

were loaded /entered before I added a new category into an existing

categoryCombination. The old values were still coded on the old

categoryOptionCombinations where the new category was missing.

I assume that DHIS2 does not delete obsolete categoryOptionCombinations, as long

as there are still dataValues linked to them.

Does that make sense, Lars?

Yes correct, that is a possibility.

Lars

Regards, Uwe

Lars Helge Øverland lars@dhis2.org hat am 2. März 2016 um 15:24 geschrieben:

Hi Sultan,

could you make sure that you do not have a category combination with only

the population category in your system?

regards,

Lars

On Wed, Mar 2, 2016 at 1:21 PM, Sultanahamar Mohammad <

sultanm@thoughtworks.com> wrote:

Hi Team,

We are using dhis 2.21 and we have a category combination created for 3

dis-aggregations.

Population 1, Population2 (Population)

<5 y.o, >5 y.o (Age)

Male, Female, Undisclosed (gender)

Once category combinations are generated, we can see few extra

combinations coming up like

just population1 or population2. Please find the screenshot attached.

Is there something that we are missing or doing wrong. Please help us

resolve this.

Thanks and Regards,

Sultan Ahamar,

Thought Works

Hyderabad


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org <https://www.dhis2.org/>


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Sultan,

I am pretty sure the function you reference does not remove old category combo options which are no longer valid. I think you will need to remove these directly in the database.

DId you try this? Obviously, after making a backup copy!

Regards,

Jason

···

On Wed, Mar 2, 2016 at 6:43 PM, Lars Helge Øverland lars@dhis2.org wrote:

On Wed, Mar 2, 2016 at 2:10 PM, Uwe Wahser uwe@wahser.de wrote:

Hi Sultan,

I have seen this in our system and suppose it comes from old dataValues, that

were loaded /entered before I added a new category into an existing

categoryCombination. The old values were still coded on the old

categoryOptionCombinations where the new category was missing.

I assume that DHIS2 does not delete obsolete categoryOptionCombinations, as long

as there are still dataValues linked to them.

Does that make sense, Lars?

Yes correct, that is a possibility.

Lars

Regards, Uwe

Lars Helge Øverland lars@dhis2.org hat am 2. März 2016 um 15:24 geschrieben:

Hi Sultan,

could you make sure that you do not have a category combination with only

the population category in your system?

regards,

Lars

On Wed, Mar 2, 2016 at 1:21 PM, Sultanahamar Mohammad <

sultanm@thoughtworks.com> wrote:

Hi Team,

We are using dhis 2.21 and we have a category combination created for 3

dis-aggregations.

Population 1, Population2 (Population)

<5 y.o, >5 y.o (Age)

Male, Female, Undisclosed (gender)

Once category combinations are generated, we can see few extra

combinations coming up like

just population1 or population2. Please find the screenshot attached.

Is there something that we are missing or doing wrong. Please help us

resolve this.

Thanks and Regards,

Sultan Ahamar,

Thought Works

Hyderabad


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org <https://www.dhis2.org/>


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org