Adding a new OrgUnit seems broken in DHIS2 2.3

Dear All,

I tried adding a new orgunit to my existing orgunits in dhis2 and was unable because after entering the details of the new orgunit on the Create new organisation unit page, I clicked the Add button and this is the message I got:

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.
If you wish to report the incident, please save this page by choosing “File -> Save (page as)” in your browser and include the saved page in the report. The problem details are listed below.

[+]
    Exception (org.hibernate.exception.GenericJDBCException):

could not insert: [org.hisp.dhis.organisationunit.OrganisationUnit]

[+]
    Caused by (java.sql.SQLException):

Field ‘organisationunitid’ doesn’t have a default value
Please kindly help resolve this. I am providing below the contents of the 'Exception" and the ‘Caused by’ if it may be of any help in tracking and resolving the problem. My user status is Superuser.

Contents of the 'Exception":

···
  • org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
  • org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
  • org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  • org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
  • org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
  • org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
  • org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
  • org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSa veEventListener.java:203)
  • org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
  • org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
  • org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
  • org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
    < li>org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:181)
  • org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnit(DefaultOrganisationUnitService.java:96)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  • $Proxy13.addOrganisationUnit(Unknown source)
  • org.hisp.dhis.oum.action.organisationunit.AddOrganisationUnitAction.execute(AddOrganisationUnitAction.java:264)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    < li>org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:122)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:112)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:100)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvo cation.java:237)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:95)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:129)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:146)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau ltActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
  • com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:105)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • o rg.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
  • org.springf ramework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
  • org.sp ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
  • org.springframework.security .web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.mortbay .jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  • org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  • org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  • org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  • org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
  • org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  • org.mortbay.jetty.Server.handle(Server.java:326)
  • org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  • org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
  • org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
  • org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
  • org.mortbay.jetty.HttpConnect ion.handle(HttpConnection.java:404)
  • org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
  • org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

Contents of ‘Caused by’:

  • com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  • com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  • com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
  • com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
  • com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
  • com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
  • com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
  • com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
  • com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
  • org.hibernate.id.IdentityGenerator$Ge tGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
  • org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
  • org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
  • org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
  • org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
  • org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
  • org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithG eneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
  • org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
  • org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
  • org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
  • org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:181)
  • org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnit(DefaultOrganisationUnitService.java:96 )
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  • $Proxy13.addOrganisationUnit(Unknown source)
  • org.hisp.dhis.oum.action.organisationunit.AddOrganisationUnitAction.execute(AddOrganisationUnitAction.java:264)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    < li>org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:122)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:112)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:100)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvo cation.java:237)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:95)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:129)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:146)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau ltActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
  • com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:105)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • o rg.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
  • org.springf ramework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
  • org.sp ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
  • org.springframework.security .web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.mortbay .jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  • org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  • org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  • org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  • org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
  • org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  • org.mortbay.jetty.Server.handle(Server.java:326)
  • org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  • org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
  • org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
  • org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
  • org.mortbay.jetty.HttpConnect ion.handle(HttpConnection.java:404)
  • org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
  • org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

Thank you.

John.

John Ojo MD, FMCPH

Consultant Public Health Physician
Senior Monitoring & Evaluation Advisor

Action for West Africa Region (AWARE II)
Accra, Ghana.
Mobile: +223 544334105
Email: jojo@aware2.org

This happens due to the removal of the source database table - and on mysql there seems to be a problem with the startup routine performing the upgrades. Some of the developers have created a sql script which should fix this, I wlil get back to you soon.

Lars

···

On Sun, Jun 26, 2011 at 9:08 AM, John Ojo jnojo@yahoo.com wrote:

Dear All,

I tried adding a new orgunit to my existing orgunits in dhis2 and was unable because after entering the details of the new orgunit on the Create new organisation unit page, I clicked the Add button and this is the message I got:

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. If you wish to report the incident, please save this page by choosing “File -> Save (page as)” in your browser and include the saved page in the report. The problem details are listed below.

[+]
    Exception (org.hibernate.exception.GenericJDBCException): could not insert: [org.hisp.dhis.organisationunit.OrganisationUnit]
[+]
    Caused by (java.sql.SQLException): Field 'organisationunitid' doesn't have a default value

Please kindly help resolve this. I am providing below the contents of the 'Exception" and the ‘Caused by’ if it may be of any help in tracking and resolving the problem. My user status is Superuser.

Contents of the 'Exception":


  • org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
  • org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
  • org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  • org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
  • org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
  • org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
  • org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
  • org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSa veEventListener.java:203)
  • org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
  • org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
  • org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
  • org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
    < li>org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:181)
  • org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnit(DefaultOrganisationUnitService.java:96)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  • $Proxy13.addOrganisationUnit(Unknown source)
  • org.hisp.dhis.oum.action.organisationunit.AddOrganisationUnitAction.execute(AddOrganisationUnitAction.java:264)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    < li>org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:122)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:112)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:100)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvo cation.java:237)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:95)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:129)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:146)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau ltActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
  • com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:105)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • o rg.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
  • org.springf ramework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
  • org.sp ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
  • org.springframework.security .web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.mortbay .jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  • org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  • org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  • org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  • org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
  • org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  • org.mortbay.jetty.Server.handle(Server.java:326)
  • org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  • org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
  • org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
  • org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
  • org.mortbay.jetty.HttpConnect ion.handle(HttpConnection.java:404)
  • org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
  • org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

Contents of ‘Caused by’:

  • com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  • com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  • com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
  • com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
  • com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
  • com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
  • com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
  • com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
  • com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
  • org.hibernate.id.IdentityGenerator$Ge tGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
  • org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
  • org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
  • org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
  • org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
  • org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
  • org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithG eneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
  • org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
  • org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
  • org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
  • org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:181)
  • org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnit(DefaultOrganisationUnitService.java:96 )
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  • $Proxy13.addOrganisationUnit(Unknown source)
  • org.hisp.dhis.oum.action.organisationunit.AddOrganisationUnitAction.execute(AddOrganisationUnitAction.java:264)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    < li>org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:122)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:112)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:100)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvo cation.java:237)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:95)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:129)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:146)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau ltActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
  • com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:105)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • o rg.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
  • org.springf ramework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
  • org.sp ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
  • org.springframework.security .web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.mortbay .jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  • org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  • org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  • org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  • org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
  • org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  • org.mortbay.jetty.Server.handle(Server.java:326)
  • org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  • org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
  • org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
  • org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
  • org.mortbay.jetty.HttpConnect ion.handle(HttpConnection.java:404)
  • org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
  • org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

Thank you.

John.

John Ojo MD, FMCPH

Consultant Public Health Physician

Senior Monitoring & Evaluation Advisor

Action for West Africa Region (AWARE II)

Accra, Ghana.
Mobile: +223 544334105

Email: jojo@aware2.org


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

Sorry who has the magic script?

We are afected by this.

Caveman

···

2011/6/26 Lars Helge Øverland larshelge@gmail.com

This happens due to the removal of the source database table - and on mysql there seems to be a problem with the startup routine performing the upgrades. Some of the developers have created a sql script which should fix this, I wlil get back to you soon.

Lars

On Sun, Jun 26, 2011 at 9:08 AM, John Ojo jnojo@yahoo.com wrote:

Dear All,

I tried adding a new orgunit to my existing orgunits in dhis2 and was unable because after entering the details of the new orgunit on the Create new organisation unit page, I clicked the Add button and this is the message I got:

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. If you wish to report the incident, please save this page by choosing “File -> Save (page as)” in your browser and include the saved page in the report. The problem details are listed below.

[+]
    Exception (org.hibernate.exception.GenericJDBCException): could not insert: [org.hisp.dhis.organisationunit.OrganisationUnit]
[+]
    Caused by (java.sql.SQLException): Field 'organisationunitid' doesn't have a default value

Please kindly help resolve this. I am providing below the contents of the 'Exception" and the ‘Caused by’ if it may be of any help in tracking and resolving the problem. My user status is Superuser.

Contents of the 'Exception":


  • org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
  • org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
  • org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  • org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
  • org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
  • org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
  • org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
  • org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSa veEventListener.java:203)
  • org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
  • org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
  • org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
  • org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
    < li>org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:181)
  • org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnit(DefaultOrganisationUnitService.java:96)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  • $Proxy13.addOrganisationUnit(Unknown source)
  • org.hisp.dhis.oum.action.organisationunit.AddOrganisationUnitAction.execute(AddOrganisationUnitAction.java:264)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    < li>org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:122)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:112)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:100)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvo cation.java:237)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:95)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:129)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:146)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau ltActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
  • com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:105)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • o rg.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
  • org.springf ramework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
  • org.sp ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
  • org.springframework.security .web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.mortbay .jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  • org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  • org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  • org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  • org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
  • org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  • org.mortbay.jetty.Server.handle(Server.java:326)
  • org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  • org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
  • org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
  • org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
  • org.mortbay.jetty.HttpConnect ion.handle(HttpConnection.java:404)
  • org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
  • org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

Contents of ‘Caused by’:

  • com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  • com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  • com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
  • com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
  • com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
  • com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
  • com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
  • com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
  • com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
  • org.hibernate.id.IdentityGenerator$Ge tGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
  • org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
  • org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
  • org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
  • org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
  • org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
  • org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithG eneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
  • org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
  • org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
  • org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
  • org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:181)
  • org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnit(DefaultOrganisationUnitService.java:96 )
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  • $Proxy13.addOrganisationUnit(Unknown source)
  • org.hisp.dhis.oum.action.organisationunit.AddOrganisationUnitAction.execute(AddOrganisationUnitAction.java:264)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown source)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    < li>org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:122)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:112)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:100)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvo cation.java:237)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:95)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:129)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:146)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau ltActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
  • com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:105)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • o rg.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
  • org.springf ramework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
  • org.sp ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
  • org.springframework.security .web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.mortbay .jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  • org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  • org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  • org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  • org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
  • org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  • org.mortbay.jetty.Server.handle(Server.java:326)
  • org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  • org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
  • org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
  • org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
  • org.mortbay.jetty.HttpConnect ion.handle(HttpConnection.java:404)
  • org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
  • org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

Thank you.

John.

John Ojo MD, FMCPH

Consultant Public Health Physician

Senior Monitoring & Evaluation Advisor

Action for West Africa Region (AWARE II)

Accra, Ghana.
Mobile: +223 544334105

Email: jojo@aware2.org


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


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

I think the answer in Bug 798140 thread which I just forward to launchpad again

···


Thủy

Thanks Lars. Will be expecting to hear from you.

John.

···

From: Lars Helge Øverland larshelge@gmail.com
To: John Ojo jnojo@yahoo.com
Cc: DHIS developers dhis2-devs@lists.launchpad.net; dhis1-users dhis2-users@lists.launchpad.net
Sent: Sunday, June 26, 2011 8:12 AM
Subject: Re: [Dhis2-users] Adding a new OrgUnit seems broken in DHIS2 2.3

This happens due to the removal of the source database table - and on mysql there seems to be a problem with the startup routine performing the upgrades. Some of the developers have created a sql script which should fix this, I wlil get back to you soon.

Lars

On Sun, Jun 26, 2011 at 9:08 AM, John Ojo jnojo@yahoo.com wrote:

Dear All,

I tried adding a new orgunit to my existing orgunits in dhis2 and was unable because after entering the details of the new orgunit on the Create new organisation unit page, I clicked the Add button and this is the message I got:

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.
If you wish to report the incident, please save this page by choosing “File -> Save (page as)” in your browser and include the saved page in the report. The problem details are listed below.

[+]
    Exception (org.hibernate.exception.GenericJDBCException):

could not insert: [org.hisp.dhis.organisationunit.OrganisationUnit]

[+]
    Caused by (java.sql.SQLException):

Field ‘organisationunitid’ doesn’t have a default value
Please kindly help resolve this. I am providing below the contents of the 'Exception" and the ‘Caused by’ if it may be of any help in tracking and resolving the problem. My user status is Superuser.

Contents of the 'Exception":


  • org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
  • org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
  • org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  • org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
  • org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
  • org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
  • org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
  • org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSa
    veEventListener.java:203)
  • org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
  • org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
  • org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
  • org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
    <

org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:181)

  • org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnit(DefaultOrganisationUnitService.java:96)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown
    source)
  • org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  • $Proxy13.addOrganisationUnit(Unknown
    source)
  • org.hisp.dhis.oum.action.organisationunit.AddOrganisationUnitAction.execute(AddOrganisationUnitAction.java:264)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown
    source)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    <

org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:122)

  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:112)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:100)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvo
    cation.java:237)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:95)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:129)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:146)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau
    ltActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
  • com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:105)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • o
    rg.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
  • org.springf
    ramework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
  • org.sp
    ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
  • org.springframework.security
    .web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.mortbay
    .jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  • org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  • org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  • org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  • org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
  • org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  • org.mortbay.jetty.Server.handle(Server.java:326)
  • org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  • org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
  • org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
  • org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
  • org.mortbay.jetty.HttpConnect
    ion.handle(HttpConnection.java:404)
  • org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
  • org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

Contents of ‘Caused by’:

  • com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  • com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  • com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
  • com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
  • com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
  • com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
  • com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
  • com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
  • com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
  • com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
  • org.hibernate.id.IdentityGenerator$Ge
    tGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
  • org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2345)
  • org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2852)
  • org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
  • org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
  • org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
  • org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
  • org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithG
    eneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
  • org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
  • org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
  • org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
  • org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
  • org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
  • org.hisp.dhis.hibernate.HibernateGenericStore.save(HibernateGenericStore.java:181)
  • org.hisp.dhis.organisationunit.DefaultOrganisationUnitService.addOrganisationUnit(DefaultOrganisationUnitService.java:96
    )
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown
    source)
  • org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  • $Proxy13.addOrganisationUnit(Unknown
    source)
  • org.hisp.dhis.oum.action.organisationunit.AddOrganisationUnitAction.execute(AddOrganisationUnitAction.java:264)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
  • sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
  • java.lang.reflect.Method.invoke(Unknown
    source)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
    <

org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:122)

  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:112)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettingInterceptor.java:78)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:100)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvo
    cation.java:237)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:95)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:129)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.LoginInterceptor.intercept(LoginInterceptor.java:84)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterceptor.java:103)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:146)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(Defau
    ltActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
  • com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:105)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
  • o
    rg.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:368)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
  • org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
  • org.springf
    ramework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
  • org.sp
    ringframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:112)
  • org.springframework.security
    .web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
  • org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:380)
  • org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:169)
  • org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
  • org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
  • org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.mortbay
    .jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
  • org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
  • org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
  • org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
  • org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
  • org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:440)
  • org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  • org.mortbay.jetty.Server.handle(Server.java:326)
  • org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
  • org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
  • org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
  • org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
  • org.mortbay.jetty.HttpConnect
    ion.handle(HttpConnection.java:404)
  • org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
  • org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

Thank you.

John.

John Ojo MD, FMCPH

Consultant Public Health Physician

Senior Monitoring & Evaluation Advisor

Action for West Africa Region (AWARE II)

Accra, Ghana.
Mobile: +223 544334105

Email: jojo@aware2.org


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

Running latest DHIS2 (downloaded Aug 13), Tomcat 6.0. DHIS2 is deploying OK, can see all startup steps in log.
However, when I click on the link in Tomcat manager to start a DHIS2 session, I get the message “Oops, an error has occurred, don’t worry, it’s recorded in the log”
Only thing in stdout.log after startup steps is out of permgen space on thread, no stack trace or anything; appears to be a Tomcat message.
I am running with Tomcat settings for memory at 1024M/1024M and permgen at 1024M/2048M. Watching Windows Task Manager during process, there does not appear to be an increase in memory usage during this process. Also, I am able to run OpenMRS in this configuration (I stop it before trying DHIS2), so I am pretty sure that the Tomcat settings are actually in place.
At this point, it’s impossible to stop DHIS2 in Tomcat manager (just keeps cranking)
It’s also impossible to stop Tomcat via Windows Services.
Only solution is to delete all DHIS2 files and folders under Tomcat.
Suggestions?
Thanks, Roger

Hi Roger, are you running 32 or 64 bit windows? Shouldn't be necessary
to allocate that much mem to perm gen space, try setting something
like 512/512. Can you post your logs?

Lars

···

2011/8/21 Friedman, Roger (CDC/CGH/DGHA) (CTR) <rdf4@cdc.gov>:

Running latest DHIS2 (downloaded Aug 13), Tomcat 6.0. DHIS2 is deploying
OK, can see all startup steps in log.

However, when I click on the link in Tomcat manager to start a DHIS2
session, I get the message “Oops, an error has occurred, don’t worry, it’s
recorded in the log”

Only thing in stdout.log after startup steps is out of permgen space on
thread, no stack trace or anything; appears to be a Tomcat message.

I am running with Tomcat settings for memory at 1024M/1024M and permgen at
1024M/2048M. Watching Windows Task Manager during process, there does not
appear to be an increase in memory usage during this process. Also, I am
able to run OpenMRS in this configuration (I stop it before trying DHIS2),
so I am pretty sure that the Tomcat settings are actually in place.

At this point, it’s impossible to stop DHIS2 in Tomcat manager (just keeps
cranking)

It’s also impossible to stop Tomcat via Windows Services.

Only solution is to delete all DHIS2 files and folders under Tomcat.

Suggestions?

Thanks, Roger