dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

OK thanks.

On Tue, Mar 28, 2017 at 9:30 AM, Martin Van Aken <martin@xxxxxxxxxxxxxxxx>
wrote:

> That was from memory, hence the lack of details, sorry for that. I'll get
> my 2.24 instance back and send you the exact messages.
>
> Regards,
>
> Martin
>
> On Tue, Mar 28, 2017 at 3:12 PM, Lars Helge Øverland <lars@xxxxxxxxx>
> wrote:
>
>> Okay. Which ones - could you paste the exact errors?
>>
>> On Tue, Mar 28, 2017 at 9:12 AM, Martin Van Aken <martin@xxxxxxxxxxxxxxxx
>> > wrote:
>>
>>> Hi,
>>> Thanks a lot for the quick answer. On server start (2.24 server on a
>>> 2.22 DB) I get errors such as: "cannot run ALTER TABLE table XXX contains
>>> null values".
>>>
>>> From my understanding of the release notes, looks like 2.23 was
>>> creating/populating some columns and 2.24 putting them as not null, correct
>>> ?
>>>
>>> Martin
>>>
>>> On Tue, Mar 28, 2017 at 3:06 PM, Lars Helge Øverland <lars@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hi Martin,
>>>>
>>>> going directly from 2.22 -> 2.24 should in theory be fine, as we retain
>>>> all the update statements in the source code. Look for TableAlteror.java.
>>>>
>>>> Could you paste the actual SQL errors you get during update? I am sure
>>>> we can work around this without upgrading to each instance.
>>>>
>>>> regards,
>>>>
>>>> Lars
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Tue, Mar 28, 2017 at 8:40 AM, Martin Van Aken <
>>>> martin@xxxxxxxxxxxxxxxx> wrote:
>>>>
>>>>> Hello,
>>>>> We're upgrading a 2.22 instance to 2.24.
>>>>> Looking at the release notes, 2.23 has a SQL to run for
>>>>> ProgramIndicators (which we don't have) but 2.24 warns about setting some
>>>>> columns as "not null" and that those should be filled by the 2.23. To avoid
>>>>> installing each version in turn, is there any way to find the SQL that are
>>>>> run by the 2.23 to fill those column, so I can just run them on my 2.22
>>>>> based DB & have the 2.24 run directly ?
>>>>>
>>>>> I tried to have a look in the source code with could not find the
>>>>> initial SQLs.
>>>>>
>>>>> Thanks !
>>>>>
>>>>> Martin
>>>>>
>>>>> --
>>>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>>>
>>>>> Mobile : +32 486 899 652
>>>>>
>>>>> Follow me on Twitter : @martinvanaken
>>>>> <http://twitter.com/martinvanaken>
>>>>> Call me on Skype : vanakenm
>>>>> Hang out with me : martin@xxxxxxxxxxxxxxxx
>>>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>>>> Company website : www.joyouscoding.com
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Lars Helge Øverland
>>>> Lead developer, DHIS 2
>>>> University of Oslo
>>>> Skype: larshelgeoverland
>>>> lars@xxxxxxxxx
>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>
>>>>
>>>
>>>
>>> --
>>> *Martin Van Aken - **Freelance Enthusiast Developer*
>>>
>>> Mobile : +32 486 899 652
>>>
>>> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
>>> Call me on Skype : vanakenm
>>> Hang out with me : martin@xxxxxxxxxxxxxxxx
>>> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
>>> Company website : www.joyouscoding.com
>>>
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> lars@xxxxxxxxx
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>
>
> --
> *Martin Van Aken - **Freelance Enthusiast Developer*
>
> Mobile : +32 486 899 652
>
> Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken>
> Call me on Skype : vanakenm
> Hang out with me : martin@xxxxxxxxxxxxxxxx
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
> Company website : www.joyouscoding.com
>



-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>