Thanks a lot Bob. My site is back up; my webapps directory was not completely clear as you mentioned.
Thanks, Ese On Sun, Apr 12, 2015 at 9:04 PM, Bob Jolliffe <[email protected]> wrote: > Hi Ese > > I wonder did you end up with bits of the old and the new after > upgrade. Make sure you (i) completely clear out webapps directory > before deploying 2.18 war file and (ii) make sure you clear cache > completely in browser and also proxy cache if you are using proxy. > > Bob > > On 12 April 2015 at 20:58, Ese Egerega <[email protected]> wrote: > > Thanks for your response Alex. > > > > I actually added the column "active" and it fixed the initial error of > > "column organisati1_.active" but I still cannot login. Below is the new > > error am getting. Am wondering if it has anything to do with the version > of > > tomcat am using (7.0.57). > > > > * INFO 2015-04-12 19:47:55,227 Login success for user: 'admin', ip: > > '41.71.158.221' (DefaultUserAuditService.java [ajp-bio-8009-exec-21]) > > * ERROR 2015-04-12 19:47:55,876 Error while executing action > > (ExceptionInterceptor.java [ajp-bio-8009-exec-21]) > > org.hibernate.PropertyAccessException: Null value was assigned to a > property > > of primitive type setter of > > org.hisp.dhis.organisationunit.OrganisationUnit.active > > at > > > org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:108) > > at > > > org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:710) > > at > > > org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:371) > > at > > > org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:4499) > > at > > > org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:185) > > at > > > org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:137) > > at > > > org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1103) > > at org.hibernate.loader.Loader.processResultSet(Loader.java:960) > > > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) > > at > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) > > at > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) > > at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190) > > at > > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) > > at > > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) > > at > > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > at > > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > at > > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > > at java.lang.Thread.run(Thread.java:745) > > Caused by: java.lang.IllegalArgumentException > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > > at > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at > > > org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:65) > > ... 109 more > > * WARN 2015-04-12 19:47:55,879 HHH000100: Fail-safe cleanup > (collections) : > > org.hibernate.engine.loading.internal.CollectionLoadContext@4b562655 > <rs=com.mchange.v2.c3p0.impl.NewProxyResultSet@4daf242c> > > (LoadContexts.java [ajp-bio-8009-exec-21]) > > * WARN 2015-04-12 19:47:55,879 HHH000160: On > CollectionLoadContext#cleanup, > > localLoadingCollectionKeys contained [1] entries > (CollectionLoadContext.java > > [ajp-bio-8009-exec-21]) > > > > > > On Sun, Apr 12, 2015 at 8:29 PM, Alex Tumwesigye <[email protected]> > > wrote: > >> > >> 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 <[email protected]> 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 : [email protected] > >>> 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-devs > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~dhis2-devs > > More help : https://help.launchpad.net/ListHelp > > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
