dhis2-users team mailing list archive

[Ese Egerega <ese@xxxxxxxxxx>]

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 <bobjolliffe@xxxxxxxxx> 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 <ese@xxxxxxxxxx> 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 <atumwesigye@xxxxxxxxx>
> > 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 <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 "
> >
> >
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-devs
> > More help   : https://help.launchpad.net/ListHelp
> >
>