dhis2-users team mailing list archive

[Martin Van Aken <martin@xxxxxxxxxxxxxxxx>]

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