← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 597600] Re: Getting Error while generating OrgUnitStructure

 

I no longer have it handy but I seem to recall it looked very similar
to the original report by Bharath.


2011/4/1 Lars Helge Øverland <larshelge@xxxxxxxxx>:
> Hi could you provide the "caused by" part of the stacktrace?
>
> On Sat, Mar 12, 2011 at 8:28 PM, jason.p.pickering <
> 597600@xxxxxxxxxxxxxxxxxx> wrote:
>
>> Experiencing this when attempting to insert a rather large number of
>> orgunits using the Amazon RDS backend (MySQL). Any update on this?
>>
>> --
>> You received this bug notification because you are a bug assignee.
>> https://bugs.launchpad.net/bugs/597600
>>
>> Title:
>>  Getting Error while generating OrgUnitStructure
>>
>> Status in DHIS 2 - District Health Information Software:
>>  New
>>
>> Bug description:
>>  While generating OrganisationUnitSturcture (Maintenance -> DataAdmin
>>  -> Resource Table) getting following exception: (TRIED with empty
>>  database as well, using MYSQL)
>>
>>   ERROR 14:28:39,218 Error while executing action
>> (ExceptionInterceptor.java [31283773@qtp-3223780
>>  -0])
>>  ava.lang.RuntimeException: Failed to flush BatchHandler
>>         at
>> org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2
>>  2)
>>         at
>> org.hisp.dhis.resourcetable.DefaultResourceTableService.generateOrganisationUnitStructu
>>  es(DefaultResourceTableService.java:196)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>         at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:3
>>  9)
>>         at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Reflective
>>  ethodInvocation.java:183)
>>         at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn
>>  ocation.java:150)
>>         at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionIn
>>  erceptor.java:110)
>>         at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn
>>  ocation.java:172)
>>         at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202
>>
>>         at $Proxy38.generateOrganisationUnitStructures(Unknown Source)
>>         at
>> org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(Genera
>>  eResourceTableAction.java:114)
>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>         at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.ja
>>  a:441)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocatio
>>  .java:280)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243
>>
>>         at
>> org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUse
>>  Interceptor.java:82)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalM
>>  duleInterceptor.java:85)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMen
>>  Interceptor.java:91)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalP
>>  ramsInterceptor.java:117)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:89)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.j
>>  va:103)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(DataDictionaryModeInt
>>  rceptor.java:109)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyIntercept
>>  r.java:90)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>>
>>  org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:124)
>>
>>         at
>>
>>  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterc
>>  ptor.java:98)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:141)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.j
>>  va:126)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterce
>>  tor.java:195)
>>         at
>> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInter
>>  eptor.java:87)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParamet
>>  rsInterceptor.java:179)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:89)
>>         at
>> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>>
>>         at
>> org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
>>         at
>> org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
>>         at
>> org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
>>         at
>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
>>
>>         at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>>  nProxy.java:343)
>>         at
>> org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:129
>>
>>         at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>>  nProxy.java:355)
>>         at
>> org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java
>>  112)
>>         at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>>  nProxy.java:355)
>>         at
>> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilt
>>  r.java:105)
>>         at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>>  nProxy.java:355)
>>         at
>> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.
>>  oFilter(AbstractAuthenticationProcessingFilter.java:188)
>>         at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>>  nProxy.java:355)
>>         at
>> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(Secu
>>  ityContextPersistenceFilter.java:79)
>>         at
>> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>>  nProxy.java:355)
>>         at
>> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
>>         at
>> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterPro
>>  y.java:237)
>>         at
>> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.jav
>>  :167)
>>         at
>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
>>
>>         at
>> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(Ope
>>  SessionInViewFilter.java:198)
>>         at
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:
>>  6)
>>         at
>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
>>
>>         at
>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
>>         at
>> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
>>         at
>> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
>>         at
>> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
>>         at
>> org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
>>         at
>> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java
>>  230)
>>         at
>> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
>>         at
>> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
>>         at org.mortbay.jetty.Server.handle(Server.java:326)
>>         at
>> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
>>         at
>> org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
>>         at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
>>         at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
>>         at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
>>         at
>> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
>>         at
>> org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
>>  aused by: java.sql.SQLException: Lock wait timeout exceeded; try
>> restarting transaction
>>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
>>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
>>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
>>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
>>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
>>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
>>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
>>         at
>> com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
>>         at
>> com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
>>         at
>> org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2
>>  6)
>>         ... 89 more
>>
>
> --
> You received this bug notification because you are a member of DHIS 2
> India Developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/597600
>
> Title:
>  Getting Error while generating OrgUnitStructure
>
> Status in DHIS 2 - District Health Information Software:
>  New
>
> Bug description:
>  While generating OrganisationUnitSturcture (Maintenance -> DataAdmin
>  -> Resource Table) getting following exception: (TRIED with empty
>  database as well, using MYSQL)
>
>   ERROR 14:28:39,218 Error while executing action (ExceptionInterceptor.java [31283773@qtp-3223780
>  -0])
>  ava.lang.RuntimeException: Failed to flush BatchHandler
>         at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2
>  2)
>         at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateOrganisationUnitStructu
>  es(DefaultResourceTableService.java:196)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:3
>  9)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Reflective
>  ethodInvocation.java:183)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn
>  ocation.java:150)
>         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionIn
>  erceptor.java:110)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn
>  ocation.java:172)
>         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202
>
>         at $Proxy38.generateOrganisationUnitStructures(Unknown Source)
>         at org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(Genera
>  eResourceTableAction.java:114)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.ja
>  a:441)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocatio
>  .java:280)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243
>
>         at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUse
>  Interceptor.java:82)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalM
>  duleInterceptor.java:85)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMen
>  Interceptor.java:91)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalP
>  ramsInterceptor.java:117)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:89)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.j
>  va:103)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(DataDictionaryModeInt
>  rceptor.java:109)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyIntercept
>  r.java:90)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at
>  org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:124)
>
>         at
>  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterc
>  ptor.java:98)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:141)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.j
>  va:126)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterce
>  tor.java:195)
>         at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInter
>  eptor.java:87)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParamet
>  rsInterceptor.java:179)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:89)
>         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237
>
>         at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
>         at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
>         at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
>         at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
>
>         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>  nProxy.java:343)
>         at org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:129
>
>         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>  nProxy.java:355)
>         at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java
>  112)
>         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>  nProxy.java:355)
>         at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilt
>  r.java:105)
>         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>  nProxy.java:355)
>         at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.
>  oFilter(AbstractAuthenticationProcessingFilter.java:188)
>         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>  nProxy.java:355)
>         at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(Secu
>  ityContextPersistenceFilter.java:79)
>         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
>  nProxy.java:355)
>         at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
>         at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterPro
>  y.java:237)
>         at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.jav
>  :167)
>         at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
>
>         at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(Ope
>  SessionInViewFilter.java:198)
>         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:
>  6)
>         at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
>
>         at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
>         at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
>         at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
>         at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
>         at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
>         at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java
>  230)
>         at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
>         at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
>         at org.mortbay.jetty.Server.handle(Server.java:326)
>         at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
>         at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
>         at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
>         at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
>         at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
>         at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
>         at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
>  aused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
>         at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
>         at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
>         at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2
>  6)
>         ... 89 more
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+260974901293

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/597600

Title:
  Getting Error while generating OrgUnitStructure

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  While generating OrganisationUnitSturcture (Maintenance -> DataAdmin
  -> Resource Table) getting following exception: (TRIED with empty
  database as well, using MYSQL)

   ERROR 14:28:39,218 Error while executing action (ExceptionInterceptor.java [31283773@qtp-3223780
  -0])
  ava.lang.RuntimeException: Failed to flush BatchHandler
         at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2
  2)
         at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateOrganisationUnitStructu
  es(DefaultResourceTableService.java:196)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at java.lang.reflect.Method.invoke(Method.java:597)
         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:3
  9)
         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Reflective
  ethodInvocation.java:183)
         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn
  ocation.java:150)
         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionIn
  erceptor.java:110)
         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodIn
  ocation.java:172)
         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202

         at $Proxy38.generateOrganisationUnitStructures(Unknown Source)
         at org.hisp.dhis.dataadmin.action.resourcetable.GenerateResourceTableAction.execute(Genera
  eResourceTableAction.java:114)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at java.lang.reflect.Method.invoke(Method.java:597)
         at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.ja
  a:441)
         at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocatio
  .java:280)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243

         at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUse
  Interceptor.java:82)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalM
  duleInterceptor.java:85)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMen
  Interceptor.java:91)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalP
  ramsInterceptor.java:117)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:89)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.j
  va:103)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(DataDictionaryModeInt
  rceptor.java:109)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyIntercept
  r.java:90)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at
  org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:124)

         at
  com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurityInterc
  ptor.java:98)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:141)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.j
  va:126)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterce
  tor.java:195)
         at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInter
  eptor.java:87)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParamet
  rsInterceptor.java:179)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:89)
         at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237

         at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
         at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
         at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
         at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)

         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
  nProxy.java:343)
         at org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:129

         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
  nProxy.java:355)
         at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java
  112)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
  nProxy.java:355)
         at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilt
  r.java:105)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
  nProxy.java:355)
         at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.
  oFilter(AbstractAuthenticationProcessingFilter.java:188)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
  nProxy.java:355)
         at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(Secu
  ityContextPersistenceFilter.java:79)
         at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterCha
  nProxy.java:355)
         at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
         at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterPro
  y.java:237)
         at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.jav
  :167)
         at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)

         at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(Ope
  SessionInViewFilter.java:198)
         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:
  6)
         at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)

         at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
         at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
         at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
         at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
         at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
         at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java
  230)
         at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
         at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
         at org.mortbay.jetty.Server.handle(Server.java:326)
         at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
         at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:943)
         at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
         at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
         at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
         at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
         at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
  aused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
         at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
         at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
         at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:2
  6)
         ... 89 more



References