dhis2-users team mailing list archive

[easy <lin_xd@xxxxxxx>]

thanks

At 2013-03-06 20:16:19,"Lars Helge Øverland" <larshelge@xxxxxxxxx> wrote:
Hi easy, you can now find user interface for analytics table generation in reporting module. Make sure your user has the all or data mart admin authority.


Lars






On Tue, Mar 5, 2013 at 11:57 AM, easy <lin_xd@xxxxxxx> wrote:
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