dhis2-users team mailing list archive

[Timothy Harding <tharding@xxxxxxxxxxxxxx>]

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


*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


On Tue, Oct 2, 2018 at 3:37 PM Dávid Katuščák <david@xxxxxxxxx> wrote:

> 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
>