dhis2-devs team mailing list archive

["Dapo Adejumo" <dapo_adejumo@xxxxxxxxx>]

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(De
faultAnalyticsTableService.java:178)

                at
org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAna
lyticsTableService.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(D
elegatingErrorHandlingRunnable.java:53)

                at
org.springframework.scheduling.concurrent.ReschedulingRunnable.run(Reschedul
ingRunnable.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(Sch
eduledThreadPoolExecutor.java:292)

                at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:11
45)

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

                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(J
dbcAnalyticsTableManager.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(AopU
tils.java:317)

                at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(ReflectiveMethodInvocation.java:183)

                at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:150)

                at
org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncEx
ecutionInterceptor.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