dhis2-devs team mailing list archive

[Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx>]

Hello DEVs 
Testing 2.25 (c4d5ae9,2016-12-08 04:01) I found that the update of category option combinations fails , this also happens in the latest version of 2.22.

 Here’s a sample of the log:

* INFO  2016-12-09 21:39:38,424 'jmalcantara' update org.hisp.dhis.dataelement.DataElementCategoryCombo, name: KH RH CM - Methods and Event Types, uid: PyXTHIJHdXH (AuditLogUtil.java [http-apr-8081-exec-6])
* WARN  2016-12-09 21:41:31,792 SQL Error: 0, SQLState: 23503 (SqlExceptionHelper.java [http-apr-8081-exec-6])
* ERROR 2016-12-09 21:41:31,793 ERROR: update or delete on table "categoryoptioncombo" violates foreign key constraint "fk_dataelementoperand_dataelementcategoryoptioncombo" on table "dataelementoperand"
  Detail: Key (categoryoptioncomboid)=(149689) is still referenced from table "dataelementoperand". (SqlExceptionHelper.java [http-apr-8081-exec-6])
* ERROR 2016-12-09 21:41:33,470 HHH000346: Error during managed flush [could not execute statement] (SessionImpl.java [http-apr-8081-exec-6])


I see the process eliminates obsolete category option combos but it fails due to table dependencies and when this happens new option combos are not created.
Any chance this can be solved? even if it means leaving obsolete category option combos.

Best regards.
JM