dhis2-devs team mailing list archive

Thread
Date
Re: ERROR after add attribute in program

To: "rin.channara@xxxxxxxxx" <rin.channara@xxxxxxxxx>
From: Tran Chau <tran.hispvietnam@xxxxxxxxx>
Date: Wed, 25 Jun 2014 17:05:59 +0800
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <lfg4w8cpcld8fljmy8ldheac.1403527680253@email.android.com>
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.hispvietnam@xxxxxxxxx


On Mon, Jun 23, 2014 at 8:48 PM, rin.channara@xxxxxxxxx <
rin.channara@xxxxxxxxx> wrote:

> Here is version I test
> Version:
> 2.15
> Build revision:
> 15163
>
>
> Tran Chau <tran.hispvietnam@xxxxxxxxx> 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.hispvietnam@xxxxxxxxx
>
>
> On Mon, Jun 23, 2014 at 9:40 AM, <rin.channara@xxxxxxxxx> 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 <knutst@xxxxxxxxx>
>> *Sent:* ‎Sunday‎, ‎June‎ ‎22‎, ‎2014 ‎10‎:‎10‎ ‎Morning
>> *To:* channara rin <rin.channara@xxxxxxxxx>
>> *Cc:* DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>, DHIS 2
>> Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
>>
>> 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.channara@xxxxxxxxx> 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-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>