dhis2-devs team mailing list archive

[JM Alcantara <jmalcantara1@xxxxxxxxx>]

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.pickering@xxxxxxxxx> 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.pickering@xxxxxxxxx
> tel:+46764147049 <+46%2076%20414%2070%2049>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>