dhis2-devs team mailing list archive

[Ese Egerega <ese@xxxxxxxxxx>]

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 "
>