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.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 > 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 > >
_______________________________________________ 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