thanks
At 2013-03-06 20:16:19,"Lars Helge Øverland" <larshe...@gmail.com> 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...@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
