System broken after upgrade to dhis2.18

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

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 "

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 "

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

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

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@gmail.com 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@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 "


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp