dhis2-users team mailing list archive

[Dávid Katuščák <david@xxxxxxxxx>]

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.

On Tue, Oct 2, 2018 at 9:07 PM, Timothy Harding <tharding@xxxxxxxxxxxxxx>
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:
> [image: strange error.gif]
>
>
> 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@xxxxxxxxxxxxxx | http://www.baosystems.com | Skype:
> hardingt@xxxxxxxxx | 2900 K Street, Suite 507, Washington D.C. 20007
>
> _______________________________________________
> 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
>
>


-- 
Best regards / Mvh,
David Katuscak