← Back to team overview

dhis2-users team mailing list archive

Re: trunk version of pivot table service

 

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
>>
>>
>
>
>

Follow ups

References