dhis2-devs team mailing list archive

[Pamod Amarakoon <pamodm@xxxxxxxxx>]

Hi Morten,

I get following error after running the script following 2.19 upgrade. What
may be causing this



Regards,
Pamod

On Thu, May 14, 2015 at 6:57 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
wrote:

> Hi
>
> You need to first run DHIS2 2.19 one time, so it can create the column
> (this was new in 2.19), and then you can run the script to update legacy
> data (we now have a orgUnit pointer on enrollment/programInstance)
>
> --
> Morten
>
> On Thu, May 14, 2015 at 3:18 AM, Dan Cocos <dan@xxxxxxxxxxxx> wrote:
>
>> Hi All,
>>
>> When updating servers to run 2.19 running the update SQL (
>> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-219.sql
>> )
>>
>> I get the following error.
>>
>> psql:update219.sql:8: ERROR:  column pi.organisationunitid does not exist
>> LINE 5: where pi.organisationunitid is null;
>>
>>
>> Is this expected?
>>
>> Thanks,
>> Dan
>>
>>
>>
>>
>>
>> *Dan Cocos*
>> BAO Systems
>> www.baosystems.com
>> T: +1 202-352-2671 | skype: dancocos
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Pamod