Update of category option combos fails

Support - Assistance technique
1

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

2

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|

busoye@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 jmalcantara1@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