dhis2-devs team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Dear Ese,

Please drop the column 'active' on table organisationunit. It was dropped
in 2.18. See upgrade notes: https://www.dhis2.org/218-upgrade

Alex

On Sun, Apr 12, 2015 at 7:17 PM, Ese Egerega <ese@xxxxxxxxxx> wrote:

> Dear All,
>
> Am having trouble with my dhis2 instance after upgrading from dhis2.17 to
> 2.18. After loading the 2.18 war file, I no longer have access to the
> system. The home page loads quite alright but when I try to login I get the
> following error message:
> An exception occurred
>
> Sorry! The system failed to execute the operation. Usually, no data is
> lost and you can continue working by going back to the previous page.
> My tomcat error log shows something like column organisati1_.active does
> not exist.
>
> See details below:
>
> * WARN  2015-04-12 15:39:57,998 SQL Error: 0, SQLState: 42703
> (SqlExceptionHelper.java [ajp-bio-8009-exec-18])
> * ERROR 2015-04-12 15:39:57,998 ERROR: column organisati1_.active does not
> exist
>   Position: 608 (SqlExceptionHelper.java [ajp-bio-8009-exec-18])
> * ERROR 2015-04-12 15:39:57,998 Error while executing action
> (ExceptionInterceptor.java [ajp-bio-8009-exec-18])
> org.hibernate.exception.SQLGrammarException: could not extract ResultSet
>
> I will appreciate any advice
> .
>
> Thanks,
> Ese
>
> _______________________________________________
> 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
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems -
DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "