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 <[email protected]> > 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
