Error When Running 2.19 SQL Update Script

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 Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos

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)

···

On Thu, May 14, 2015 at 3:18 AM, Dan Cocos dan@dancocos.com 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 Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Morten

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@gmail.com 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)


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Morten

On Thu, May 14, 2015 at 3:18 AM, Dan Cocos dan@dancocos.com 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 Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Pamod

Hi Dan,

I’ve added an additional statement to the script now which adds the column, please try again.

Lars

···

On Wed, May 13, 2015 at 11:18 PM, Dan Cocos dan@dancocos.com 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 Systemswww.baosystems.com

T: +1 202-352-2671 | skype: dancocos


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp