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 <e...@cis.com.ng> 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@lists.launchpad.net > 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 "
_______________________________________________ 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
