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 > <mailto: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 > <mailto: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.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) > at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97) > at > org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207) > at > org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45) > at > org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3259) > at > org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3496) > at > org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:98) > at > org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:582) > at > org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456) > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com <mailto:jason.p.picker...@gmail.com> > tel:+46764147049 <tel:+46%2076%20414%2070%2049> > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > <https://launchpad.net/~dhis2-devs> > Post to : dhis2-devs@lists.launchpad.net > <mailto:dhis2-devs@lists.launchpad.net> > Unsubscribe : https://launchpad.net/~dhis2-devs > <https://launchpad.net/~dhis2-devs> > More help : https://help.launchpad.net/ListHelp > <https://help.launchpad.net/ListHelp> > > > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com <mailto:jason.p.picker...@gmail.com> > tel:+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
