Error When Running 2.19 SQL Update Script

Support - Assistance technique
1

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

2

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

3

Hi Morten,

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

image

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

4

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