dhis2-users team mailing list archive

[Martin Van Aken <martin@xxxxxxxxxxxxxxxx>]

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