dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

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/>