dhis2-devs team mailing list archive

[Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx>]

Hi Lars,

we are still getting this error on the log:


* INFO  00:58:01,539 [Level: ERROR, category: DATAMART, time: Thu Jan 16 00:58:01 GMT 2014, message: Process failed: Exception during execution] (InMemoryNotifier.java [taskSchedul
er-3])
* ERROR 00:58:01,610 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-3])
java.lang.RuntimeException: Exception during execution
        at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
        at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.applyAggregationLevels(DefaultAnalyticsTableService.java:235)
        at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:123)
        at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:95)
        at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.util.concurrent.ExecutionException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [update analytics_temp_2009 set uidlevel1 =
null,uidlevel2 = null,uidlevel3 = null,uidlevel4 = null where level > 4 and de in ('qBvHcmJFar7', 'p3O9uIwwilb', 'DjhVZdEGBuD', 'LYUp6Y5jh7p', 'FIbM6WouPGs', 'v0KfOFnCGyw', 'GKyTb4
VpUl1', 'bNx0pcvPC7P', 'kEwEMwSaw1z', 'mNfb2oSG52z')]; nested exception is org.h2.jdbc.JdbcSQLException: Column "UIDLEVEL1" not found; SQL statement:
update analytics_temp_2009 set uidlevel1 = null,uidlevel2 = null,uidlevel3 = null,uidlevel4 = null where level > 4 and de in ('qBvHcmJFar7', 'p3O9uIwwilb', 'DjhVZdEGBuD', 'LYUp6Y5j
h7p', 'FIbM6WouPGs', 'v0KfOFnCGyw', 'GKyTb4VpUl1', 'bNx0pcvPC7P', 'kEwEMwSaw1z', 'mNfb2oSG52z') [42122-173]
        at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
        at java.util.concurrent.FutureTask.get(FutureTask.java:83)
        at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:51)
        ... 13 more
Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [update analytics_temp_2009 set uidlevel1 = null,uidlevel2 = null,uidlevel3 = null,ui
dlevel4 = null where level > 4 and de in ('qBvHcmJFar7', 'p3O9uIwwilb', 'DjhVZdEGBuD', 'LYUp6Y5jh7p', 'FIbM6WouPGs', 'v0KfOFnCGyw', 'GKyTb4VpUl1', 'bNx0pcvPC7P', 'kEwEMwSaw1z', 'mN
fb2oSG52z')]; nested exception is org.h2.jdbc.JdbcSQLException: Column "UIDLEVEL1" not found; SQL statement:
update analytics_temp_2009 set uidlevel1 = null,uidlevel2 = null,uidlevel3 = null,uidlevel4 = null where level > 4 and de in ('qBvHcmJFar7', 'p3O9uIwwilb', 'DjhVZdEGBuD', 'LYUp6Y5j
h7p', 'FIbM6WouPGs', 'v0KfOFnCGyw', 'GKyTb4VpUl1', 'bNx0pcvPC7P', 'kEwEMwSaw1z', 'mNfb2oSG52z') [42122-173]
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
        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.execute(JdbcTemplate.java:428)
        at org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.applyAggregationLevels(JdbcAnalyticsTableManager.java:291)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:95)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        ... 1 more
Caused by: org.h2.jdbc.JdbcSQLException: Column "UIDLEVEL1" not found; SQL statement:
update analytics_temp_2009 set uidlevel1 = null,uidlevel2 = null,uidlevel3 = null,uidlevel4 = null where level > 4 and de in ('qBvHcmJFar7', 'p3O9uIwwilb', 'DjhVZdEGBuD', 'LYUp6Y5j
h7p', 'FIbM6WouPGs', 'v0KfOFnCGyw', 'GKyTb4VpUl1', 'bNx0pcvPC7P', 'kEwEMwSaw1z', 'mNfb2oSG52z') [42122-173]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
        at org.h2.message.DbException.get(DbException.java:171)
        at org.h2.message.DbException.get(DbException.java:148)
        at org.h2.table.Table.getColumn(Table.java:613)
        at org.h2.command.Parser.readTableColumn(Parser.java:658)
        at org.h2.command.Parser.parseUpdate(Parser.java:692)
        at org.h2.command.Parser.parsePrepared(Parser.java:427)
        at org.h2.command.Parser.parse(Parser.java:279)
        at org.h2.command.Parser.parse(Parser.java:251)
        at org.h2.command.Parser.prepareCommand(Parser.java:218)
        at org.h2.engine.Session.prepareLocal(Session.java:428)
        at org.h2.engine.Session.prepareCommand(Session.java:377)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
        at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:168)
        at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
        at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
        ... 13 more


Regards,
Paulo Grácio

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1268787

Title:
  Generating Analytics in Live version

Status in DHIS 2:
  Fix Committed

Bug description:
  DHIS Live 2.13

  * INFO  10:29:50,023 [Level: ERROR, category: DATAMART, time: Fri Dec 13 10:29:50 GMT 2013, message: Process failed:
  er-2])
  * ERROR 10:29:50,123 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
  java.lang.RuntimeException: Exception during execution
          at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
          at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.ja
          at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:113)
          at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:95)
          at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
          at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnabl
          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
          at java.util.concurrent.FutureTask.run(FutureTask.java:138)
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecut
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java
          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
          at java.lang.Thread.run(Thread.java:662)
   
  Regards,
  Paulo Grácio

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1268787/+subscriptions