Query did not return a unique result: 3

Hi Guys
I am facing a new problem when i enter the data in data entry app the problem is
query did not return a unique result: 3
could any one help me please?
thanks a lot

Hi @Amalamer,

We have encountered a similar issue in our DHIS2.28 server in the past. If you look through your browser & server logs you will most probably see an error related to duplicate category combo(it was for us).

Can you please check through the log and share it.

If it is the duplicate category combo problem then you will have to look through the table to find the duplicate and then replace the old one with the new one in a few tables before removing it from the dataelementcategoryoptioncombo table.

You can use the following script to do the same(remember to replace the name/id of the “default” category-combo to the one that you have to replace): https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/fix-duplicate-default-category-option-combos.sql

Hope this helps resolve your problem. Please reach out if you need further assistance.

Dear @Amalamer,

Did @Gaurav_Kumar’s help solve your issue?