trunk version of pivot table service

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

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:5

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

莫愁前路无知己,天下谁人不识君。

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

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:5

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

thanks

···

At 2013-03-05 14:34:53,“Lars Helge Øverland” larshelge@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_xd@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

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:5

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

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@126.com wrote:

thanks

At 2013-03-05 14:34:53,“Lars Helge Øverland” larshelge@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_xd@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

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:5

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

thanks

···

At 2013-03-06 20:16:19,“Lars Helge Øverland” larshelge@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_xd@126.com wrote:

thanks

At 2013-03-05 14:34:53,“Lars Helge Øverland” larshelge@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_xd@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

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:5

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