dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Morten,
Now I did. :)

https://jira.dhis2.org/browse/DHIS2-1903

Regards,
Jason

On Tue, Jul 4, 2017 at 8:58 PM, Morten Olav Hansen <morten@xxxxxxxxx> wrote:

> 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 <jmalcantara1@xxxxxxxxx>
> 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.pickering@xxxxxxxxx>
>> 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 <jmalcantara1@xxxxxxxxx>
>> 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.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.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.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
>>>>
>>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049 <+46764147049>
>>
>>
>>
>> _______________________________________________
>> 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
>>
>>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049