Hi Channara, This bug didn't occur on my side and DHIS demo server. Could you please create an example on demo server (https://apps.dhis2.org/demo) where we can see the bug on ?
Best regards, ------------------------------------------------ Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Mon, Jun 23, 2014 at 8:48 PM, rin.chann...@gmail.com < rin.chann...@gmail.com> wrote: > Here is version I test > Version: > 2.15 > Build revision: > 15163 > > > Tran Chau <tran.hispviet...@gmail.com> wrote: > > Hi Channara, > > Could you please give us more information about version and revision of > DHIS which you used for testing ? > > Best regards, > ------------------------------------------------ > Châu Thu Trân > HISP Viet Nam > Email: tran.hispviet...@gmail.com > > > On Mon, Jun 23, 2014 at 9:40 AM, <rin.chann...@gmail.com> wrote: > >> Sorry for late reply. >> >> Here is the console of tomcat v7. >> =============================XXX============================ >> Jun 22, 2014 7:13:48 PM org.apache.catalina.core.ApplicationContext log >> INFO: No Spring WebApplicationInitializer types detected on classpath >> Jun 22, 2014 7:13:49 PM org.apache.catalina.core.ApplicationContext log >> INFO: Initializing Spring root WebApplicationContext >> Jun 22, 2014 7:16:44 PM org.apache.catalina.core.ApplicationContext log >> INFO: Initializing Spring FrameworkServlet 'ohie' >> Jun 22, 2014 7:16:59 PM org.apache.catalina.core.ApplicationContext log >> INFO: Initializing Spring FrameworkServlet 'mobile' >> Jun 22, 2014 7:17:02 PM org.apache.catalina.core.ApplicationContext log >> INFO: Initializing Spring FrameworkServlet 'webapi' >> Jun 22, 2014 7:31:11 PM org.apache.catalina.core.StandardWrapperValve >> invoke >> SEVERE: Servlet.service() for servlet [webapi] in context with path >> [/dhis] threw exception [Request processing failed; nested exception is >> org.hibernate.exception.SQLGrammarException: could not extract ResultSet] >> with root cause >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column >> 'dashboard0_.externalAccess' in 'field list' >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown >> Source) >> at java.lang.reflect.Constructor.newInstance(Unknown Source) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >> at com.mysql.jdbc.Util.getInstance(Util.java:386) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) >> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) >> at >> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) >> at >> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323) >> at >> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) >> at >> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56) >> at org.hibernate.loader.Loader.getResultSet(Loader.java:2031) >> at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832) >> at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811) >> at org.hibernate.loader.Loader.doQuery(Loader.java:899) >> at >> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341) >> at org.hibernate.loader.Loader.doList(Loader.java:2516) >> at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361) >> at org.hibernate.loader.Loader.list(Loader.java:2324) >> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:490) >> at >> org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355) >> at >> org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195) >> at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1268) >> at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) >> at >> org.hisp.dhis.common.hibernate.HibernateIdentifiableObjectStore.getAllOrderedName(HibernateIdentifiableObjectStore.java:342) >> at >> org.hisp.dhis.common.DefaultIdentifiableObjectManager.getAllSorted(DefaultIdentifiableObjectManager.java:269) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) >> at >> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) >> at >> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> at >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >> at com.sun.proxy.$Proxy69.getAllSorted(Unknown Source) >> at >> org.hisp.dhis.api.controller.AbstractCrudController.getEntityList(AbstractCrudController.java:429) >> at >> org.hisp.dhis.api.controller.AbstractCrudController.getObjectListJson(AbstractCrudController.java:166) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at >> org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219) >> at >> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) >> at >> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) >> at >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) >> at >> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686) >> at >> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) >> at >> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) >> at >> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) >> at >> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936) >> at >> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) >> at >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) >> at >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) >> at >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:64) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:113) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) >> at >> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) >> at >> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) >> at >> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) >> at >> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) >> at >> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:149) >> at >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) >> at >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) >> at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) >> at >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) >> at >> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040) >> at >> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) >> at >> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) >> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) >> at >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >> at java.lang.Thread.run(Unknown Source) >> =============================XXX============================ >> >> Thank you >> channara >> >> *From:* Knut Staring <knu...@gmail.com> >> *Sent:* Sunday, June 22, 2014 10:10 Morning >> *To:* channara rin <rin.chann...@gmail.com> >> *Cc:* DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>, DHIS 2 >> Users list <dhis2-users@lists.launchpad.net> >> >> That message in itself is not informative. Did you look in the Tomcat >> log? Can you share it with us? >> On 22 Jun 2014 03:57, "channara rin" <rin.chann...@gmail.com> wrote: >> >>> HI all, >>> I created program with multiple within registration in >>> "Program/Attribute" and then i add some attributes into program. after i >>> click add/update. i got the error every time. >>> >>> thank you >>> channara >>> >>> >>> >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-d...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-d...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp