# Adding a new OrgUnit seems broken in DHIS2 2.3

**URL:** <https://community.dhis2.org/t/adding-a-new-orgunit-seems-broken-in-dhis2-2-3/1046>\
**Category:** Support - Assistance technique\
**Created:** [26 June 2011 07:08 UTC](https://community.dhis2.org/t/adding-a-new-orgunit-seems-broken-in-dhis2-2-3/1046 "2011-06-26T07:08:16Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![John\_Ojo](https://dhis2.b-cdn.net/letter_avatar_proxy/v4/letter/j/85e7bf/32.png) [@John\_Ojo](https://community.dhis2.org/u/John_Ojo)\
**Post date:** [26 June 2011 07:08 UTC](https://community.dhis2.org/t/adding-a-new-orgunit-seems-broken-in-dhis2-2-3/1046/1 "2011-06-26T07:08:16Z")

</div>

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](mailto:jojo@aware2.org)

---

<div class="post-metadata">

**Author:** ![Lars](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/lars/32/34166_2.png) [@Lars](https://community.dhis2.org/u/Lars)\
**Post date:** [26 June 2011 07:12 UTC](https://community.dhis2.org/t/adding-a-new-orgunit-seems-broken-in-dhis2-2-3/1046/2 "2011-06-26T07:12:41Z")

</div>

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](mailto: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](mailto:jojo@aware2.org)
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

---

<div class="post-metadata">

**Author:** ![Orvalho\_Augusto](https://dhis2.b-cdn.net/letter_avatar_proxy/v4/letter/o/8491ac/32.png) [@Orvalho\_Augusto](https://community.dhis2.org/u/Orvalho_Augusto)\
**Post date:** [26 June 2011 18:33 UTC](https://community.dhis2.org/t/adding-a-new-orgunit-seems-broken-in-dhis2-2-3/1046/3 "2011-06-26T18:33:25Z")

</div>

Sorry who has the magic script?

We are afected by this.

Caveman

> **···**
>
> 2011/6/26 Lars Helge Øverland [larshelge@gmail.com](mailto: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](mailto: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](mailto:jojo@aware2.org)
> 
> > >
> 
> > > * * *
> > > 
> > > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users)
> > > 
> > > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > > 
> > > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users)
> > > 
> > > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)
> 
> > 
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)
> > 
> > Post to : [dhis2-devs@lists.launchpad.net](mailto:dhis2-devs@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

---

<div class="post-metadata">

**Author:** ![Thuy\_Nguyen](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/thuy_nguyen/32/42138_2.png) [@Thuy\_Nguyen](https://community.dhis2.org/u/Thuy_Nguyen)\
**Post date:** [26 June 2011 18:38 UTC](https://community.dhis2.org/t/adding-a-new-orgunit-seems-broken-in-dhis2-2-3/1046/4 "2011-06-26T18:38:29Z")

</div>

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

> **···**
>
> –  
> _Thủy_

---

<div class="post-metadata">

**Author:** ![John\_Ojo](https://dhis2.b-cdn.net/letter_avatar_proxy/v4/letter/j/85e7bf/32.png) [@John\_Ojo](https://community.dhis2.org/u/John_Ojo)\
**Post date:** [26 June 2011 21:51 UTC](https://community.dhis2.org/t/adding-a-new-orgunit-seems-broken-in-dhis2-2-3/1046/5 "2011-06-26T21:51:13Z")

</div>

Thanks Lars. Will be expecting to hear from you.

John.

> **···**
>
> * * *
> 
> **From:** Lars Helge Øverland [larshelge@gmail.com](mailto:larshelge@gmail.com)  
> **To:** John Ojo [jnojo@yahoo.com](mailto:jnojo@yahoo.com)  
> **Cc:** DHIS developers [dhis2-devs@lists.launchpad.net](mailto:dhis2-devs@lists.launchpad.net); dhis1-users [dhis2-users@lists.launchpad.net](mailto: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](mailto: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](http://org.hibernate.id.insert.AbstractReturningDelegate.pe).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](http://org.mortbay.io.nio.SelectChannelEndPoint.ru).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](http://org.hibernate.id.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](mailto:jojo@aware2.org)
> 
> > * * *
> > 
> > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users)
> > 
> > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net)
> > 
> > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users)
> > 
> > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)

---

<div class="post-metadata">

**Author:** ![Friedman\_Roger\_CDC\_C](https://dhis2.b-cdn.net/letter_avatar_proxy/v4/letter/f/c0e974/32.png) [@Friedman\_Roger\_CDC\_C](https://community.dhis2.org/u/Friedman_Roger_CDC_C)\
**Post date:** [21 August 2011 14:00 UTC](https://community.dhis2.org/t/adding-a-new-orgunit-seems-broken-in-dhis2-2-3/1046/6 "2011-08-21T14:00:56Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Lars](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/lars/32/34166_2.png) [@Lars](https://community.dhis2.org/u/Lars)\
**Post date:** [21 August 2011 16:49 UTC](https://community.dhis2.org/t/adding-a-new-orgunit-seems-broken-in-dhis2-2-3/1046/7 "2011-08-21T16:49:18Z")

</div>

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