Yes!!!!! It works. Thank you.
But when I try to get my old plots I get this message: No filter dimensions specified. Thank you Caveman On Wed, Jun 5, 2013 at 6:02 AM, Jason Pickering <jason.p.picker...@gmail.com > wrote: > Hi Caveman, > You must run the Analytics first, in order for these tables to be > generated. (ERROR: relation "analytics_2012" does not exist) from > "Reports->Analytics and Data Mart". > > Regards, > Jason > > > On Wed, Jun 5, 2013 at 5:55 AM, Orvalho Augusto <orvaq...@gmail.com>wrote: > >> Thank you for this mail both of you. I have the same issue. >> >> I have made a pgdum of the data from a cloud server using 2.10. I want to >> test 2.12. So I place that data on my laptop. I upgraded first to 2.11 and >> I saw this on the logs when trying to retrieve my old plots: >> >> Jun 5, 2013 5:26:13 AM org.apache.catalina.core.StandardWrapperValve >> invoke >> SEVERE: Servlet.service() for servlet webapi threw exception >> org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" >> Position: 142 >> at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) >> at >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) >> at >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) >> at >> com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:616) >> at >> org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) >> at >> org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) >> at sun.proxy.$Proxy174.executeQuery(Unknown Source) >> at >> org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) >> at >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) >> at >> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) >> at >> org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:499) >> at >> org.hisp.dhis.reporttable.jdbc.JDBCReportTableManager.getAggregatedValueMapOrgUnitHierarchy(JDBCReportTableManager.java:239) >> at >> org.hisp.dhis.reporttable.jdbc.JDBCReportTableManager.getAggregatedValueMap(JDBCReportTableManager.java:100) >> at >> org.hisp.dhis.chart.impl.DefaultChartService.getCategoryDataSet(DefaultChartService.java:670) >> at >> org.hisp.dhis.chart.impl.DefaultChartService.getJFreeChart(DefaultChartService.java:514) >> at >> org.hisp.dhis.chart.impl.DefaultChartService.getJFreeChart(DefaultChartService.java:215) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:616) >> 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.invoke(TransactionInterceptor.java:110) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> at >> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> at >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >> at sun.proxy.$Proxy60.getJFreeChart(Unknown Source) >> at >> org.hisp.dhis.api.controller.ChartController.getChart(ChartController.java:182) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:616) >> 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:920) >> at >> org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:816) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) >> at >> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:801) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 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.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:54) >> 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:112) >> 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:346) >> at >> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:152) >> at >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) >> at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> 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:235) >> at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) >> at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) >> at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) >> at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) >> at >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) >> at >> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >> at java.lang.Thread.run(Thread.java:679) >> >> >> Well. I said to me this will be corected on the next version. So I place >> mr 2.12 war on my webapps and now DHIS 2.12 starts, I can login but trying >> to get plots and reports mr Tomcat screams things like these: >> >> Time: 10557 micros: Planned query, got: 2 for optimal: 4 >> * INFO 2013-06-05 05:40:36,026 Query failed, likely because the >> requested analytics table does not exist (JdbcAnalyticsManager.java >> [SimpleAsyncTaskExecutor-1]) >> org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad >> SQL grammar [select de,Monthly, sum(value) as value from analytics_2013 >> where de in ('M65coQoKXGE') and Monthly in ('201301', '201302', '201303', >> '201304', '201305') and (uidlevel1 in ('XrSevkDRESe')) group by >> de,Monthly]; nested exception is org.postgresql.util.PSQLException: ERROR: >> relation "analytics_2013" does not exist >> Position: 45 >> at >> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237) >> at >> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) >> at >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) >> at >> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) >> at >> org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501) >> at >> org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:306) >> at >> org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:122) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:616) >> 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.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:89) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> at java.lang.Thread.run(Thread.java:679) >> Caused by: org.postgresql.util.PSQLException: ERROR: relation >> "analytics_2013" does not exist >> Position: 45 >> at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) >> at >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) >> at >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) >> at >> com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) >> at >> org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) >> at >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) >> ... 15 more >> * INFO 2013-06-05 05:40:36,043 Query failed, likely because the >> requested analytics table does not exist (JdbcAnalyticsManager.java >> [SimpleAsyncTaskExecutor-2]) >> org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad >> SQL grammar [select de,Monthly, sum(value) as value from analytics_2012 >> where de in ('M65coQoKXGE') and Monthly in ('201206', '201207', '201208', >> '201209', '201210', '201211', '201212') and (uidlevel1 in ('XrSevkDRESe')) >> group by de,Monthly]; nested exception is >> org.postgresql.util.PSQLException: ERROR: relation "analytics_2012" does >> not exist >> Position: 45 >> at >> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237) >> at >> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) >> at >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) >> at >> org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) >> at >> org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501) >> at >> org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:306) >> at >> org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:122) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:616) >> 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.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:89) >> >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> at java.lang.Thread.run(Thread.java:679) >> Caused by: org.postgresql.util.PSQLException: ERROR: relation >> "analytics_2012" does not exist >> Position: 45 >> at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) >> at >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) >> at >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) >> at >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) >> at >> com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35) >> at >> org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) >> at >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) >> ... 15 more >> Time: 75896 micros: Got aggregated values for query group >> Time: 76084 micros: Got aggregated values >> >> So can you help me? >> >> Caveman >> >> >> >> On Tue, Jun 4, 2013 at 9:25 PM, Knut Staring <knu...@gmail.com> wrote: >> >>> Hi Marko, do an upgrade to 2.11 first >>> Den 4. juni 2013 18:48 skrev "Marko David Garcia" < >>> markodavi...@gmail.com> følgende: >>> >>>> Hello friends. >>>> >>>> We are trying to install the 2.12 version, but the application doesn't >>>> start. >>>> >>>> We have installed the 12.10 version. >>>> >>>> This is the log file. >>>> >>>> Thank you very much. >>>> >>>> >>>> 04/06/2013 12:28:56 PM org.apache.catalina.core.StandardContext >>>> listenerStart >>>> GRAVE: Excepción enviando evento inicializado de contexto a instancia >>>> de escuchador de clase org.hisp.dhis.system.startup.StartupListener >>>> java.lang.RuntimeException: Failed to run startup routines: Nombre de >>>> columna no válido; nested exception is java.sql.SQLException: Nombre de$ >>>> at >>>> org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:70) >>>> at >>>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4779) >>>> at >>>> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5273) >>>> at >>>> org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) >>>> at >>>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895) >>>> at >>>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871) >>>> at >>>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615) >>>> at >>>> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:958) >>>> at >>>> org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1599) >>>> at >>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) >>>> at >>>> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >>>> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >>>> at >>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) >>>> at >>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) >>>> at java.lang.Thread.run(Thread.java:679) >>>> Caused by: org.springframework.jdbc.InvalidResultSetAccessException: >>>> Nombre de columna no válido; nested exception is java.sql.SQLException: $ >>>> at >>>> org.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet.findColumn(ResultSetWrappingSqlRowSet.java:145) >>>> at >>>> org.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet.getInt(ResultSetWrappingSqlRowSet.java:300) >>>> at >>>> org.hisp.dhis.common.IdentityPopulator.execute(IdentityPopulator.java:124) >>>> at >>>> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:101) >>>> at >>>> org.hisp.dhis.system.startup.DefaultStartupRoutineExecutor.execute(DefaultStartupRoutineExecutor.java:77) >>>> at >>>> org.hisp.dhis.system.startup.StartupListener.contextInitialized(StartupListener.java:66) >>>> ... 14 more >>>> Caused by: java.sql.SQLException: Nombre de columna no válido >>>> at >>>> com.sun.rowset.CachedRowSetImpl.getColIdxByName(CachedRowSetImpl.java:1645) >>>> at >>>> com.sun.rowset.CachedRowSetImpl.findColumn(CachedRowSetImpl.java:3041) >>>> at >>>> org.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet.findColumn(ResultSetWrappingSqlRowSet.java:142) >>>> ... 19 more >>>> 4/06/2013 12:28:56 PM org.apache.catalina.core.ApplicationContext log >>>> INFO: Closing Spring root WebApplicationContext >>>> 4/06/2013 12:28:57 PM org.apache.catalina.core.ApplicationContext log >>>> INFO: Initializing Spring root WebApplicationContext >>>> 4/06/2013 12:29:31 PM org.apache.catalina.core.ApplicationContext log >>>> INFO: Initializing Spring FrameworkServlet 'webapiServlet' >>>> 4/06/2013 12:29:33 PM org.apache.catalina.core.ApplicationContext log >>>> INFO: Initializing Spring FrameworkServlet 'mobileServlet' >>>> 4/06/2013 12:32:35 PM org.apache.catalina.core.ApplicationContext log >>>> INFO: Destroying Spring FrameworkServlet 'webapiServlet' >>>> 4/06/2013 12:32:35 PM org.apache.catalina.core.ApplicationContext log >>>> >>>> >>>> -- >>>> Cordialmente, >>>> >>>> >>>> *Ing. Marko David Garcia M. >>>> * >>>> *Área de Sistemas integrados de Información >>>> Secretaría de Salud Departamental del Cauca >>>> >>>> * >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-users >>>> Post to : dhis2-us...@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-us...@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> _______________________________________________ >> 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 >> >> >
_______________________________________________ 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