Error populating Analytics Tables

Support - Assistance technique
1

Hi Devs,

Got this error while populating analytics tables( 2.12 Revision 11243) … Any Ideas?

  • WARN 2013-07-23 00:30:21,549 StatementCallback; bad SQL grammar [drop table analytics_temp]; nested exception is org.postgresql.util.PSQLException: ERROR: table “analytics_temp” does not exist (AbstractJdbcTableManager.java [taskScheduler-1])

  • INFO 2013-07-23 00:30:21,566 Create SQL: create table analytics_temp (UnOmEE9l51L character(11),wAKuCUteI0e character(11),Xb8MVrtez6o character(11),HS8DcTHiREJ character(11),WvnXLJQg6vR character(11),RR8jNDrhGKL character(11),kmuv0cVwV2A character(11),GvScnquL6Se character(11),zKUIte9NQVI character(11),vjdQ0soqG24 character(11),BTwFpDrSY5Q character(11),mWJkZ2Yp6X1 character(11),NHT9VXj7gub character(11),cQ9m1al6lXs character(11),MFWPbSu5QD9 character(11),bVXoPNpgXAi character(11),BbXxca4U7pV character(11),dAOtelbj68d character(11),NKLFG5JbYGc character(11),XTfbt38vQ85 character(11),gVNZMVzwIft character(11),WLQLDowcGDZ character(11),KAnPRETzLNh character(11),xZh88Rnx7WD character(11),HCD7Irwavc9 character(11),YKmOpwwRn25 character(11),veWwr1DhYrn character(11),PkxB7CaMq5m character(11),uidlevel1 character(11),uidlevel2 character(11),uidlevel3 character(11),uidlevel4 character(11),uidlevel5 character(11),uidlevel6 character(11),uidlevel7 character(11),daily character varying(10),weekly character varying(10),monthly character varying(10),bimonthly character varying(10),quarterly character varying(10),sixmonthly character varying(10),yearly character varying(10),financialapril character varying(10),financialjuly character varying(10),financialoct character varying(10),de character(11) not null,co character(11) not null,level integer,daysxvalue double precision, daysno integer not null, value double precision) (JdbcAnalyticsTableManager.java [taskScheduler-1])

  • INFO 2013-07-23 00:30:21,578 Created analytics tables: 0:00:21.484 (Clock.java [taskScheduler-1])

  • ERROR 2013-07-23 00:30:21,620 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

java.lang.RuntimeException: Exception during execution

            at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:54)

            at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.java:178)

            at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:110)

            at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:88)

            at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:59)

            at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)

            at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)

            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

            at java.util.concurrent.FutureTask.run(FutureTask.java:166)

            at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)

            at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)

            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

            at java.lang.Thread.run(Thread.java:724)

Caused by: java.util.concurrent.ExecutionException: java.lang.NullPointerException

            at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252)

            at java.util.concurrent.FutureTask.get(FutureTask.java:111)

            at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:50)

            ... 14 more

Caused by: java.lang.NullPointerException

            at org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTableAsync(JdbcAnalyticsTableManager.java:122)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            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:89)

            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

            at java.util.concurrent.FutureTask.run(FutureTask.java:166)

            ... 1 more

…………………………………………………………………

Regards

Dapo Adejumo

+2348033683677

Skype : dapojorge