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...@126.com> 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@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-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
