Hi Devs, I am also getting this error with version 2.24 build 1d4233c. Updating COCs in maintenance results in an unresolved loop. I have attached a screenshot of the error I see on the Chrome console. This is a crucial functionality and would be great to have a quick fix.
Thanks. - - Busoye Anifalaje (PhD) Director of Services (Principal), BAO Systems UK: +44 7901-740-757 | US: +1 682-307-0986| bus...@baosystems.com <mailto:bus...@baosystems.com> | http://www.baosystems.com <http://www.baosystems.com/> | Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007 > On 9 Dec 2016, at 22:10, Juan Manuel Alcantara Acosta > <jmalcanta...@gmail.com> wrote: > > 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 > > > _______________________________________________ > 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
_______________________________________________ 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
