Excel report module Exception

Support - Assistance technique
1

Hi Tri, This exception appeared when I assign Organization groups for listing.

And I couldn’t see any GIS, or other modules in Services except 3 modules Data Entry, Data Mart and Excel Report

Please tell me what I did wrong.

···

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.springframework.dao.DataIntegrityViolationException): Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

[+]
    Caused by (org.hibernate.exception.ConstraintViolationException): Could not execute JDBC batch update
[+]

Caused by (java.sql.BatchUpdateException): Batch entry 0 insert into reportexcel_organisationgroup (reportexcelid, grouporder, oganisationunitgroupid) values (7988, 0, 730) was aborted. Call getNextException to see the cause.

–

Thuy
HISP Vietnam
+84902079126

2

Hi Thủy,

To build all module, pls go into dhis-web-portal/pom.xml and uncomment dependency you want to use, it will show in menu.

  • with the exception you have, I think you can restart tomcat service => every will fine. I think this is problem with database connections.
···

================================
Tran Thanh Tri
HISP Viet Nam
Cell phone: +84903670967
Website: http://tringuyenvn.com

================================

2009/9/19 Thuy Nguyen thuy.hispvietnam@gmail.com

Hi Tri, This exception appeared when I assign Organization groups for listing.

And I couldn’t see any GIS, or other modules in Services except 3 modules Data Entry, Data Mart and Excel Report

Please tell me what I did wrong.

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.springframework.dao.DataIntegrityViolationException): Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

  • org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636)
  • org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:789)
  • org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663)
  • org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
  • org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
  • org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  • $Proxy36.updateReportExcel(Unknown source)
  • org.hisp.dhis.reportexcel.organisationunitgrouplisting.action.UpdateOrganisationUnitGroupAction.execute(UpdateOrganisationUnitGroupAction.java:104)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
  • sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  • java.lang.reflect.Method.invoke(Method.java:597)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
  • org.hisp.dhis.webportal.interceptor.WebWorkPortalUserInterceptor.intercept(WebWorkPortalUserInterceptor.java:82)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.webportal.interceptor.WebWorkPortalModuleInterceptor.intercept(WebWorkPortalModuleInterceptor.java:85)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.webportal.interceptor.WebWorkPortalMenuInterceptor.intercept(WebWorkPortalMenuInterceptor.java:91)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.webportal.interceptor.WebWorkPortalParamsInterceptor.intercept(WebWorkPortalParamsInterceptor.java:117)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:89)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:92)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(DataDictionaryModeInterceptor.java:109)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:124)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.security.intercept.WebWorkSecurityInterceptor.intercept(WebWorkSecurityInterceptor.java:98)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:122)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • 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:236)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:148)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:89)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
  • org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:131)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:107)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
  • org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  • org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  • org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
  • org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  • org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  • org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
  • org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
  • org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  • org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  • java.lang.Thread.run(Thread.java:619)
[+]
    Caused by (org.hibernate.exception.ConstraintViolationException): Could not execute JDBC batch update
  • org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
  • org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  • org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
  • org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
  • org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:171)
  • org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
  • org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
  • org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
  • org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
  • org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
  • org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
  • org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
  • org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
  • org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
  • org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
  • org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  • org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  • $Proxy36.updateReportExcel(Unknown source)
  • org.hisp.dhis.reportexcel.organisationunitgrouplisting.action.UpdateOrganisationUnitGroupAction.execute(UpdateOrganisationUnitGroupAction.java:104)
  • sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java:-2)
  • sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  • sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  • java.lang.reflect.Method.invoke(Method.java:597)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440)
  • com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
  • org.hisp.dhis.webportal.interceptor.WebWorkPortalUserInterceptor.intercept(WebWorkPortalUserInterceptor.java:82)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.webportal.interceptor.WebWorkPortalModuleInterceptor.intercept(WebWorkPortalModuleInterceptor.java:85)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.webportal.interceptor.WebWorkPortalMenuInterceptor.intercept(WebWorkPortalMenuInterceptor.java:91)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.webportal.interceptor.WebWorkPortalParamsInterceptor.intercept(WebWorkPortalParamsInterceptor.java:117)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:89)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterceptor.java:92)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(DataDictionaryModeInterceptor.java:109)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyInterceptor.java:90)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.java:124)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.security.intercept.WebWorkSecurityInterceptor.intercept(WebWorkSecurityInterceptor.java:98)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:122)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • 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:236)
  • com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:148)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.java:89)
  • com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
  • org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
  • org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
  • org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
  • org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:131)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:107)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
  • org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
  • org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
  • org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  • org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  • org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  • org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  • org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  • org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  • org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
  • org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  • org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  • org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
  • org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
  • org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  • org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  • java.lang.Thread.run(Thread.java:619)
[+]

Caused by (java.sql.BatchUpdateException): Batch entry 0 insert into reportexcel_organisationgroup (reportexcelid, grouporder, oganisationunitgroupid) values (7988, 0, 730) was aborted. Call getNextException to see the cause.

–

Thuy
HISP Vietnam
+84902079126

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

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

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

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