ERROR: column trackedent1_.uid does not exist\n Position: 209

Support - Assistance technique
1

I’ve got a tracker program on a test server and I’m not able to view any of the TEIs that I’ve made. I keep getting:

ERROR: column trackedent1_.uid does not exist\n Position: 209

and it is trying to reach the following link:

https://starburst.baosystems.com/api/30/trackedEntityInstances/lmcLfONF8rY.json?program=IpHINAT79UW&fields=*

Here is what I see in the log:

  • ERROR 2018-10-02 18:41:29,184 ERROR: column trackedent1_.uid does not exist

    Position: 209 (SqlExceptionHelper.java [http-bio-8081-exec-469])

image

···

Here is a gif of my actions:

I’m running 2.30.0b19434

Any ideas on this one?

This is regardless of program.

Timothy Harding
Sr. Systems Analyst, BAO Systems

+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 507, Washington D.C. 20007

2

Hi Timothy,

The problem is that an updated upgrade script was not run on the DB. Some time ago, we changed trackedentitycomment to be an identifiable object (we introduced uid, etc. columns) and so we had to update the upgrade script.

Please, check the upgrade script here: https://github.com/dhis2/dhis2-releases/blob/master/releases/2.30/upgrade-230.sql

On the bottom, you can find the second transaction. Please, run it on your DB (while DHIS2 is shut down) and then restart. This should fix it.

image

···

On Tue, Oct 2, 2018 at 9:07 PM, Timothy Harding tharding@baosystems.com wrote:

I’ve got a tracker program on a test server and I’m not able to view any of the TEIs that I’ve made. I keep getting:

ERROR: column trackedent1_.uid does not exist\n Position: 209

and it is trying to reach the following link:

https://starburst.baosystems.com/api/30/trackedEntityInstances/lmcLfONF8rY.json?program=IpHINAT79UW&fields=*

Here is what I see in the log:

  • ERROR 2018-10-02 18:41:29,184 ERROR: column trackedent1_.uid does not exist

Position: 209 (SqlExceptionHelper.java [http-bio-8081-exec-469])

Here is a gif of my actions:

I’m running 2.30.0b19434

Any ideas on this one?

This is regardless of program.

Timothy Harding
Sr. Systems Analyst, BAO Systems

+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 507, Washington D.C. 20007

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

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

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

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

–

Best regards / Mvh,

David Katuscak

3

Thank you so much for the lightning fast response David, that second transaction fixed it thank you.

image

···

Timothy Harding
Sr. Systems Analyst, BAO Systems

+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 507, Washington D.C. 20007

On Tue, Oct 2, 2018 at 9:07 PM, Timothy Harding tharding@baosystems.com wrote:

I’ve got a tracker program on a test server and I’m not able to view any of the TEIs that I’ve made. I keep getting:

ERROR: column trackedent1_.uid does not exist\n Position: 209

and it is trying to reach the following link:

https://starburst.baosystems.com/api/30/trackedEntityInstances/lmcLfONF8rY.json?program=IpHINAT79UW&fields=*

Here is what I see in the log:

  • ERROR 2018-10-02 18:41:29,184 ERROR: column trackedent1_.uid does not exist

Position: 209 (SqlExceptionHelper.java [http-bio-8081-exec-469])

Here is a gif of my actions:

I’m running 2.30.0b19434

Any ideas on this one?

This is regardless of program.

Timothy Harding
Sr. Systems Analyst, BAO Systems

+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 507, Washington D.C. 20007

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

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

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

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

–
Best regards / Mvh,

David Katuscak