dhis2-users team mailing list archive

[easy <lin_xd@xxxxxxx>]

thanks

At 2013-03-05 14:34:53,"Lars Helge Øverland" <larshelge@xxxxxxxxx> wrote:
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