← Back to team overview

dhis2-users team mailing list archive

Re: Troubles running datamart

 

Dear Orvalho,

DHIS2 Datamart sometim sometimes fails to run due to Invalid Data submitted
during Reporting e.g. if it is expected a Number and either Text or just
space or NULL (java.lang.NullPointerException) is submitted, It fails to
run. This has been sorted in the latest version. Please try Upgrading your
DHIS2 to the latest version and Try running again. The latest version will
skip invalid data values and you can track it from the Log file for all the
Ignored data values ...

Hopefully this helps

Stephen

On Tue, May 14, 2013 at 8:46 AM, Orvalho Augusto <orvaquim@xxxxxxxxx> wrote:

> Some organisationunities does not have data on reportting. I am using DHIS
> 2.10 under CentOS 6.3 64bit.
>
> The last log has this:
> * INFO  2013-05-14 07:54:38,130 Created indicator index: 0:23:21.391
> (Clock.java [taskScheduler-1])
> * INFO  2013-05-14 07:54:38,223 Aggregated data export done: 0:23:21.485
> (Clock.java [taskScheduler-1])
> * ERROR 2013-05-14 07:54:45,224 Unexpected error occurred in scheduled
> task. (TaskUtils.java [taskScheduler-1])
> java.lang.NullPointerException
>     at
> org.hibernate.event.internal.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:148)
>     at
> org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:88)
>     at
> org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:55)
>     at
> org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1186)
>     at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1615)
>     at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
>     at
> org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:396)
>     at
> org.hisp.dhis.hibernate.HibernateGenericStore.getObject(HibernateGenericStore.java:178)
>     at
> org.hisp.dhis.hibernate.HibernateGenericStore.getByName(HibernateGenericStore.java:238)
>     at
> org.hisp.dhis.setting.DefaultSystemSettingManager.getSystemSetting(DefaultSystemSettingManager.java:99)
>     at sun.reflect.GeneratedMethodAccessor164.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:318)
>     at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>     at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>     at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
>     at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>     at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
>     at $Proxy78.getSystemSetting(Unknown Source)
>     at
> org.hisp.dhis.datamart.engine.DefaultDataMartEngine.export(DefaultDataMartEngine.java:449)
>     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:601)
>     at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
>     at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>     at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
>     at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
>     at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>     at
> org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
>     at
> org.amplecode.quick.StatementInterceptor.intercept(StatementInterceptor.java:71)
>     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:601)
>     at
> org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
>     at
> org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
>     at
> org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
>     at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>     at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
>     at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
>     at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
>     at $Proxy104.export(Unknown Source)
>     at
> org.hisp.dhis.system.scheduling.DataMartTask.run(DataMartTask.java:163)
>     at
> org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
>     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:1110)
>     at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
>     at java.lang.Thread.run(Thread.java:722)
>
> Can someone help?
>
> Orvalho
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

*You can do anything, but not everything.*

Follow ups

References