API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 5th, 2013
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JavaScript 18.09 KB | None | 0 0
raw download clone embed print report
  1. * INFO  2013-06-06 06:34:33,857 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-252])
  2. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select de,Monthly, sum(value) as value from analytics_2013 where de in ('LWqJxyolr7e') and Monthly in ('201301', '201302', '201303', '201304', '201305') and (uidlevel1 in ('uCPNdu9BPYq')) group by de,Monthly]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2013" does not exist
  3.   Position: 45
  4.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
  5.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  6.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  7.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
  8.     at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
  9.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:306)
  10.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:122)
  11.     at sun.reflect.GeneratedMethodAccessor666.invoke(Unknown Source)
  12.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  13.     at java.lang.reflect.Method.invoke(Method.java:616)
  14.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  15.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  16.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  17.     at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:89)
  18.     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  19.     at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  20.     at java.lang.Thread.run(Thread.java:679)
  21. Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2013" does not exist
  22.   Position: 45
  23.     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  24.     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  25.     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  26.     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  27.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  28.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
  29.     at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
  30.     at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
  31.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  32.     ... 14 more
  33. * INFO  2013-06-06 06:34:33,862 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-254])
  34. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select de,Quarterly, sum(value) as value from analytics_2013 where de in ('LWqJxyolr7e') and Quarterly in ('2013Q2') and (uidlevel1 in ('uCPNdu9BPYq')) group by de,Quarterly]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2013" does not exist
  35.   Position: 47
  36.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
  37.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  38.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  39.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
  40.     at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
  41.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:306)
  42.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:122)
  43.     at sun.reflect.GeneratedMethodAccessor666.invoke(Unknown Source)
  44.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  45.     at java.lang.reflect.Method.invoke(Method.java:616)
  46.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  47.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  48.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  49.     at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:89)
  50.     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  51.     at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  52.     at java.lang.Thread.run(Thread.java:679)
  53. Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2013" does not exist
  54.   Position: 47
  55.     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  56.     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  57.     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  58.     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  59.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  60.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
  61.     at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
  62.     at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
  63.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  64.     ... 14 more
  65. * INFO  2013-06-06 06:34:33,862 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-253])
  66. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select de,Monthly, sum(value) as value from analytics_2013 where de in ('jJmVzCnXWQu') and Monthly in ('201301', '201302', '201303', '201304', '201305') and (uidlevel1 in ('uCPNdu9BPYq')) group by de,Monthly]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2013" does not exist
  67.   Position: 45
  68.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
  69.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  70.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  71.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
  72.     at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
  73.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:306)
  74.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:122)
  75.     at sun.reflect.GeneratedMethodAccessor666.invoke(Unknown Source)
  76.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  77.     at java.lang.reflect.Method.invoke(Method.java:616)
  78.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  79.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  80.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  81.     at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:89)
  82.     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  83.     at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  84.     at java.lang.Thread.run(Thread.java:679)
  85. Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2013" does not exist
  86.   Position: 45
  87.     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  88.     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  89.     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  90.     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  91.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  92.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
  93.     at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
  94.     at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
  95.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  96.     ... 14 more
  97. * INFO  2013-06-06 06:34:33,865 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-256])
  98. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select de,Monthly, sum(value) as value from analytics_2012 where de in ('LWqJxyolr7e') and Monthly in ('201206', '201207', '201208', '201209', '201210', '201211', '201212') and (uidlevel1 in ('uCPNdu9BPYq')) group by de,Monthly]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2012" does not exist
  99.   Position: 45
  100.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
  101.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  102.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  103.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
  104.     at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
  105.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:306)
  106.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:122)
  107.     at sun.reflect.GeneratedMethodAccessor666.invoke(Unknown Source)
  108.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  109.     at java.lang.reflect.Method.invoke(Method.java:616)
  110.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  111.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  112.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  113.     at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:89)
  114.     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  115.     at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  116.     at java.lang.Thread.run(Thread.java:679)
  117. Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2012" does not exist
  118.   Position: 45
  119.     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  120.     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  121.     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  122.     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  123.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  124.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
  125.     at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
  126.     at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
  127.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  128.     ... 14 more
  129. * INFO  2013-06-06 06:34:33,867 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-255])
  130. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select de,Quarterly, sum(value) as value from analytics_2013 where de in ('jJmVzCnXWQu') and Quarterly in ('2013Q2') and (uidlevel1 in ('uCPNdu9BPYq')) group by de,Quarterly]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2013" does not exist
  131.   Position: 47
  132.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
  133.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  134.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  135.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
  136.     at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
  137.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:306)
  138.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:122)
  139.     at sun.reflect.GeneratedMethodAccessor666.invoke(Unknown Source)
  140.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  141.     at java.lang.reflect.Method.invoke(Method.java:616)
  142.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  143.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  144.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  145.     at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:89)
  146.     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  147.     at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  148.     at java.lang.Thread.run(Thread.java:679)
  149. Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2013" does not exist
  150.   Position: 47
  151.     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  152.     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  153.     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  154.     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  155.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  156.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
  157.     at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
  158.     at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
  159.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  160.     ... 14 more
  161. * INFO  2013-06-06 06:34:33,867 Query failed, likely because the requested analytics table does not exist (JdbcAnalyticsManager.java [SimpleAsyncTaskExecutor-257])
  162. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select de,Monthly, sum(value) as value from analytics_2012 where de in ('jJmVzCnXWQu') and Monthly in ('201206', '201207', '201208', '201209', '201210', '201211', '201212') and (uidlevel1 in ('uCPNdu9BPYq')) group by de,Monthly]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "analytics_2012" does not exist
  163.   Position: 45
  164.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
  165.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  166.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
  167.     at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
  168.     at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:501)
  169.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:306)
  170.     at org.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:122)
  171.     at sun.reflect.GeneratedMethodAccessor666.invoke(Unknown Source)
  172.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  173.     at java.lang.reflect.Method.invoke(Method.java:616)
  174.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  175.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  176.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  177.     at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:89)
  178.     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
  179.     at java.util.concurrent.FutureTask.run(FutureTask.java:166)
  180.     at java.lang.Thread.run(Thread.java:679)
  181. Caused by: org.postgresql.util.PSQLException: ERROR: relation "analytics_2012" does not exist
  182.   Position: 45
  183.     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
  184.     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
  185.     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  186.     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
  187.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
  188.     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
  189.     at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
  190.     at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
  191.     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
  192.     ... 14 more
  193. Time: 19141 micros: Got aggregated values for query group
  194. Time: 19195 micros: Got aggregated values
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!