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...@126.com wrote:
thanks
At 2013-03-05 14:34:53,Lars Helge Øverland larshe...@gmail.com 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...@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