Error when saving favourites in Pivot Table, Visualizer


I am seeing this error when saving a favourite (on catalina.out). The favourite is never saved. What can be the issue? It only happens when choosing ‘Details’ for data elements.

ERROR 2017-08-16 13:36:34,998 ERROR: duplicate key value violates unique constraint “dataelement_operand_unique_key”

Detail: Key (dataelementid, categoryoptioncomboid)=(1369, 98) already exists. ( [ajp-nio-8009-exec-4])


Hi Everyone,

We have started seeing this exact issue in 2.30 Nepal Implementation. Does anyone have suggestions.

  • Padam

Hi @padamdahal

2.30 is an older version of DHIS2 is no longer supported. It is expected that you could face many bugs which are fixed in later versions of DHIS2. The best advice I could give you is to make a copy of your instance as a test instance and upgrade it to the latest versions and see if everything is working properly then upgrade your production instance.

You can read more about upgrading your instance here: Upgrading - DHIS2 Documentation


Older post from 2017, and uses older version of DHIS2. If you are facing a similar issue using one of the latest apps please create a new topic post.

Thank you!