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@cis.com.ng 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@4b562655rs=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@gmail.com
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@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 "