dhis2-devs team mailing list archive

[Morten Olav Hansen <mortenoh@xxxxxxxxx>]

Yes, I see there are some issues with the upgrade script. I will fix it.

You should be able to properly upgrade using something like this:
update datavalueaudit set created=timestamp where created is null
alter table datavalueaudit drop column timestamp

--
Morten

On Sat, Jan 30, 2016 at 10:25 AM, Craig Hollingsworth <
craig.hollingsworth@xxxxxx> wrote:

> Hi Morten,
>
> Hope you're well.
>
> Thanks for the response.  greatly appreciated.
>
> we rebooted the server but I think the script is not dropping the old
> column, instead it's creating a separate one for 'created' and hence the
> error.
>
> thanks again for your help!
>
> Cheers
>
> Craig
> ------------------------------
> *From:* Morten Olav Hansen [mortenoh@xxxxxxxxx]
> *Sent:* 29 January 2016 22:02
> *To:* Craig Hollingsworth
> *Cc:* dhis2-devs
> *Subject:* Re: [Dhis2-devs] Problem / bug? with updating existing data
> element value in aggregate data entry under version 2.22
>
> Hi again
>
> On second thought, I see you are talking about aggregate data.. this table
> has existed for a while, what we did in 2.22 was to rename it from
> timestamp to created.
>
> Are you saying it is named timestamp even on a fresh new database?
>
> For existing databases you should be able to just do:
> alter table datavalueaudit rename column timestamp to created
>
> (that said, this is already done during startup.. but maybe you have both
> created and timestamp column.. which could create issues)
>
> --
> Morten
>
> On Sat, Jan 30, 2016 at 9:42 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
> wrote:
>
>> Hi Craig
>>
>> Probably you were trying 2.22 out during development phase? That column
>> existed for a few days before it was renamed.
>>
>> Simply removing the timestamp column should work
>>
>>
>> On Saturday, 30 January 2016, Craig Hollingsworth <
>> craig.hollingsworth@xxxxxx> wrote:
>>
>>> Hi,
>>>
>>>
>>>
>>> Hope all are well.
>>>
>>>
>>>
>>> Today I started to enter some historic data into our new shiny dhis2
>>> system and think I may have broken it already!
>>>
>>>
>>>
>>> When I enter aggregate data elements into the system it uploads ok and
>>> the cell turns green.    If I then try to update the same cell the system
>>> throws an internal server error.
>>>
>>>
>>>
>>> The Dhis2 log gives the following error:
>>>
>>>
>>>
>>> WARN  2016-01-29 17:08:54,788 SQL Error: 0, SQLState: 23502
>>> (SqlExceptionHelper.java [http-apr-8081-exec-8])
>>>
>>> * ERROR 2016-01-29 17:08:54,789 ERROR: null value in column "timestamp"
>>> violates not-null constraint
>>>
>>>   Detail: Failing row contains (7639, 5830, 5218, 7428, 15, 7072, 1,
>>> null, admin, DELETE, 2016-01-29 17:08:54.78). (SqlExceptionHelper.java
>>> [http-apr-8081-exec-8])
>>>
>>>
>>>
>>>
>>>
>>> We’ve not been able to recreate the bug on the dhis2play version.
>>> We’ve checked the postgres db and all  the relevant fields appear to be
>>> there so we do not think it is related to the previous upgrade process to
>>> v2.22.   From what we gather the error is thrown when trying to update the
>>> audit table due to lack of a timestamp.
>>>
>>>
>>>
>>> We tried against a range of data elements and appears not to be related
>>> to any specific one / or specific category combo.
>>>
>>> Have tried setting up a new ‘clean’ dataset with just one dataelement.
>>>
>>> Have tried auto and custom data entry forms
>>>
>>> Am logging in as sys admin.
>>>
>>> Dhis2 v 2.22 ,
>>>
>>> build 21782 from 26th January.
>>>
>>> Hosted with BAO.
>>>
>>>
>>>
>>>
>>>
>>> Would appreciate if anyone could advise/support and check whether this
>>> is a bug or not.  Can give access to the system if required.
>>>
>>>
>>>
>>> Many thanks
>>>
>>>
>>>
>>> Craig
>>>
>>>
>>>
>>>
>>>
>>> ----------------------------------------------
>>>
>>> Craig Hollingsworth
>>>
>>> Global M&E Data Pilots Project Manager
>>>
>>> Tel: +57 320 208 4921  / +44 (0) 7570 138 151
>>>
>>> Skype:  Craig.Hollingsworth
>>>
>>>
>>>
>>> [image: NRC Logo spanish]
>>>
>>>
>>>
>>> ----------------------------------------------
>>>
>>>
>>>
>>
>>
>> --
>> --
>> Morten
>>
>>
>