dhis2-users team mailing list archive

[Abyot Gizaw <abyota@xxxxxxxxx>]

On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen <elmarie@xxxxxxxx> wrote:

> Hi Devs,
>
>
>
> I have an urgent database issue which I have to resolve as this project is
> implementing by Monday and my database is not running on 2.20 stable which
> I need for the tracker capture app to load. Can someone please assist.
>
>
>
> We have a database called ISHP which Erling has been helping us to set up
> the Tracker capture app for implementation.
>
> Since the app could only connect to 2.20 we upgraded our training database
> some time ago to 2.20 snapshot build revision 19527 and also kept the
> program changes we made updated in 2.19 live version since we couldn’t risk
> updating a live database when we did not know what the implications would
> be.
>
>
>
> We now wanting to update the 2.19 Live database to 2.20 which we did on
> our development instance but get the following errors which does not allow
> us to
>
>
>
> 1.      access the program in the UI or via the tracker capture app (see
> open program error log) The problem seems to be that the programtype in
> our database is Integer while in other 2.20 instances it is char varying.
> The update script from 2.19>2.20 does not contain anything changing this so
> how do I deal with this please…
>
>
This was supposed to be handled internally in the code.

try to alter manually and see what happens

ALTER TABLE program ALTER COLUMN "type" TYPE varchar(255);


>
>
> 2.      analytics is failing due to fieldname error   (see detailed
> analytics error log attached but here is a short version) The problem is
> that the temp table has a fieldname called de instead of dx – again
> something I don’t know how it happens or how to fix
>
>
>
> *Caused by: org.springframework.jdbc.BadSqlGrammarException:
> StatementCallback; bad SQL grammar [update analytics_temp_2015 set
> "uidlevel1" = null,"uidlevel2" = null,"uidlevel3" = null,"uidlevel4" =
> null,"uidlevel5" = null where level > 5 and de in ('jx6lCxe8gYy',
> 'cjA6JH0kC9B')]; nested exception is org.postgresql.util.PSQLException:
> ERROR: column "de" does not exist*
>
> We checked our other 2.20 databases and the column name is dx but we don’t
> know how to fix this – please help!
>
>
>
> The program we are accessing on 2.19, 2.20 stable and 2.20 snapshot Version:
> Build revision: 19527 Build date: 2015-07-01 08:47 is all set up exactly
> the same way and I don’t see why one would be able to open the program,
> open tracker capture in the UI and log in on tracker capture app only on
> the 2.20 snapshot version and not on 2.20 stable. Can you please assist us
> with what is wrong?
>
>
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:      041-367 1027
>
> Cell:     082 374 2209
>
> E-mail: elmarie@xxxxxxxx
>
> Skype:  elmarie.claasen52
>
>
>
>
>
> This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer
> .   Please read the disclaimer before opening any attachment or taking any
> other action in terms of this electronic transmission.
> If you cannot access the disclaimer, kindly send an email to disclaimer@xxxxxxxx
> and a copy will be provided to you. By replying to this e-mail or opening
> any attachment you agree to be bound by the provisions of the disclaimer.
>
>
>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclaimer@xxxxxxxx
> <disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer.*
> _______________________________________________
> 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
>
-- 
----
Thank you,
Abyot