dhis2-devs team mailing list archive

[Orvalho Augusto <orvaquim@xxxxxxxxx>]

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.pickering@xxxxxxxxx
> 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 <orvaquim@xxxxxxxxx>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 <knutst@xxxxxxxxx> wrote:
>>
>>> Hi Marko, do an upgrade to 2.11 first
>>> Den 4. juni 2013 18:48 skrev "Marko David Garcia" <
>>> markodavidgm@xxxxxxxxx> 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-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> 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
>>
>>
>