Hi Jason Did you create a issue for this?
-- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Mon, Jul 3, 2017 at 9:25 PM, JM Alcantara <jmalcanta...@gmail.com> wrote: > It seems this also affects the setup of grey fields in sections. > > Regards, > JM > > > El 03/07/2017, a las 16:16, Jason Pickering <jason.p.picker...@gmail.com> > escribió: > > Hi JM, > > Thanks for confirming that others have seen this. This is a really > crippling problem for this instance and I can confirm that there is a > favorite attached to this data dimension. > > > I do have a work around to PATCH the expiry days with the API, which > works, but that is a less than ideal solution. > > Regards, > Jason > > > On Sun, Jul 2, 2017 at 8:29 AM, JM Alcantara <jmalcanta...@gmail.com> > wrote: > >> Hi Jason >> I've seen this before when there is a favorite using details with a data >> element included in the data set. >> JM >> >> On 2 Jul 2017 13:33, "Jason Pickering" <jason.p.picker...@gmail.com> >> wrote: >> >>> >>> Hi Devs, >>> >>> >>> When updating expiry days in a data set, I am seeing this error. Any >>> idea how to correct it? I am not able to reproduce on the demo site, so >>> seems something specific to this database. >>> >>> Regards, >>> Jason >>> >>> >>> >>> Version:2.26 >>> Build revision:80d7658 >>> Build date:2017-06-15 06:43 >>> >>> * INFO 2017-07-02 12:18:25,811 (admin) Import:Start >>> (DefaultMetadataImportService.java [http-bio-0.0.0.0-8080-exec-23]) >>> * INFO 2017-07-02 12:18:26,716 (admin) Import:Preheat[REFERENCE] took >>> 0.90 seconds (DefaultPreheatService.java [http-bio-0.0.0.0-8080-exec-23 >>> ]) >>> * INFO 2017-07-02 12:18:26,721 (admin) Import:Validation took 0.00 >>> seconds (DefaultObjectBundleValidationService.java >>> [http-bio-0.0.0.0-8080-exec-23]) >>> * INFO 2017-07-02 12:18:26,722 (admin) Updating 1 object(s) of type >>> DataSet (DefaultObjectBundleService.java [http-bio-0.0.0.0-8080-exec-23 >>> ]) >>> * WARN 2017-07-02 12:18:26,870 SQL Error: 0, SQLState: 23503 >>> (SqlExceptionHelper.java [http-bio-0.0.0.0-8080-exec-23]) >>> * ERROR 2017-07-02 12:18:26,871 ERROR: update or delete on table >>> "dataelementoperand" violates foreign key constraint >>> "fk_datadimensionitem_dataelementoperandid" on table "datadimensionitem" >>> Detail: Key (dataelementoperandid)=(788048) is still referenced from >>> table "datadimensionitem". (SqlExceptionHelper.java >>> [http-bio-0.0.0.0-8080-exec-23]) >>> org.hibernate.exception.ConstraintViolationException: could not execute >>> statement >>> at org.hibernate.exception.internal.SQLStateConversionDelegate. >>> convert(SQLStateConversionDelegate.java:112) >>> at org.hibernate.exception.internal.StandardSQLExceptionConvert >>> er.convert(StandardSQLExceptionConverter.java:42) >>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql >>> ExceptionHelper.java:111) >>> at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(Sql >>> ExceptionHelper.java:97) >>> at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.execu >>> teUpdate(ResultSetReturnImpl.java:207) >>> at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.ad >>> dToBatch(NonBatchingBatch.java:45) >>> at org.hibernate.persister.entity.AbstractEntityPersister.delet >>> e(AbstractEntityPersister.java:3259) >>> at org.hibernate.persister.entity.AbstractEntityPersister.delet >>> e(AbstractEntityPersister.java:3496) >>> at org.hibernate.action.internal.EntityDeleteAction.execute(Ent >>> ityDeleteAction.java:98) >>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu >>> eue.java:582) >>> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQu >>> eue.java:456) >>> >>> >>> -- >>> Jason P. Pickering >>> email: jason.p.picker...@gmail.com >>> tel:+46764147049 <+46%2076%20414%2070%2049> >>> >>> _______________________________________________ >>> 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 >>> >>> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 <+46764147049> > > > > _______________________________________________ > 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