dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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
>