dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi easy, this stuff is very much under development, you need to first
generate the analytics tables, I will finalize the user interface for that
during the day and let you know.

regards,

Lars

On Tue, Mar 5, 2013 at 4:00 AM, easy <lin_xd@xxxxxxx> wrote:

> hi,all,
>   I got this error:
>
> * INFO  2013-03-05 10:53:18,796 Query failed, likely because the requested
> analytics table d
> oes not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-45])
> org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad
> SQL grammar [select
> de,Monthly, sum(value) as value from analytics_2012 where de in
> ('fbfJHSPpUQD' ) and Monthly
>  in ('201212', '201211', '201210', '201209', '201208', '201207', '201206',
> '201205', '201204
> ', '201203' ) and uidlevel1 in ('ImspTQPwCqd' ) group by de,Monthly];
> nested exception is or
> g.postgresql.util.PSQLException: error:  relation "analytics_2012" doesn't
> exist position：45
>         at
> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(S
> QLErrorCodeSQLExceptionTranslator.java:233)
>         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:499)
>         at
> org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAna
> lyticsManager.java:151)
>         at sun.reflect.GeneratedMethodAccessor624.invoke(Unknown Source)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java
> :43)
>         at java.lang.reflect.Method.invoke(Method.java:601)
>         at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.
> java:317)
>         at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Refl
> ectiveMethodInvocation.java:183)
>         at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMe
> thodInvocation.java:150)
>         at
> org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecuti
> onInterceptor.java:83)
>         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:722)
> Caused by: org.postgresql.util.PSQLException: ERROR: relation
> "analytics_2012" doesn't exist position：45
>         at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.j
> ava:2103)
>         at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:18
> 36)
>         at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:5
> 12)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Stateme
> nt.java:374)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.j
> ava: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)
>         ... 13 more
>
>
>
>
> --
> 此致
>
>    easy
>
> 莫愁前路无知己，天下谁人不识君。
>
>
>
> _______________________________________________
> 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
>
>