Hi all
I’m trying to set up a push analysis on DHIS2 2.29 Build: 75f33d4 with a dashboard containing only tables but when I run it I get the error below:
Any Solution please ?
* INFO 2020-04-21 12:09:28,869 Scheduler initiated execute of job: jfjDl0JhxPI, pushAnalysisJob from controller, PUSH_ANALYSIS, (DefaultSchedulingManager.java [tomcat-http-4740])
* INFO 2020-04-21 12:09:28,870 Job 'pushAnalysisJob from controller' started (DefaultJobInstance.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,871 [Level: INFO, category: PUSH_ANALYSIS, time: Tue Apr 21 12:09:28 WAT 2020, message: Starting pre-check on PushAnalysis] (InMemoryNotifier.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,871 Starting pre-check on PushAnalysis (DefaultPushAnalysisService.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,872 [Level: INFO, category: PUSH_ANALYSIS, time: Tue Apr 21 12:09:28 WAT 2020, message: pre-check completed successfully] (InMemoryNotifier.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,872 pre-check completed successfully (DefaultPushAnalysisService.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,872 [Level: INFO, category: PUSH_ANALYSIS, time: Tue Apr 21 12:09:28 WAT 2020, message: Composing list of receiving users] (InMemoryNotifier.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,872 Composing list of receiving users (DefaultPushAnalysisService.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,872 [Level: INFO, category: PUSH_ANALYSIS, time: Tue Apr 21 12:09:28 WAT 2020, message: List composed. 1 eligible users found.] (InMemoryNotifier.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,872 List composed. 1 eligible users found. (DefaultPushAnalysisService.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,872 [Level: INFO, category: PUSH_ANALYSIS, time: Tue Apr 21 12:09:28 WAT 2020, message: Generating and sending reports] (InMemoryNotifier.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,872 Generating and sending reports (DefaultPushAnalysisService.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,872 [Level: INFO, category: PUSH_ANALYSIS, time: Tue Apr 21 12:09:28 WAT 2020, message: Generating PushAnalysis for user 'tdiallo'.] (InMemoryNotifier.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,873 Generating PushAnalysis for user 'tdiallo'. (DefaultPushAnalysisService.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,888 [Level: ERROR, category: PUSH_ANALYSIS, time: Tue Apr 21 12:09:28 WAT 2020, message: Could not create or send report for PushAnalysis 'MAIDUGURI REPORTING RATE' and User 'tdiallo': null] (InMemoryNotifier.java [taskScheduler-16])
* ERROR 2020-04-21 12:09:28,889 Could not create or send report for PushAnalysis 'MAIDUGURI REPORTING RATE' and User 'tdiallo': null (DefaultPushAnalysisService.java [taskScheduler-16])
java.lang.NullPointerException
at org.hisp.dhis.analytics.security.DefaultAnalyticsSecurityManager.decideAccessDataReadObjects(DefaultAnalyticsSecurityManager.java:152)
at org.hisp.dhis.analytics.security.DefaultAnalyticsSecurityManager.decideAccess(DefaultAnalyticsSecurityManager.java:89)
at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValues(DefaultAnalyticsService.java:232)
at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:295)
at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:306)
at org.hisp.dhis.reporttable.impl.DefaultReportTableService.getReportTableGridByUser(DefaultReportTableService.java:149)
at sun.reflect.GeneratedMethodAccessor2823.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy133.getReportTableGridByUser(Unknown Source)
at org.hisp.dhis.pushanalysis.DefaultPushAnalysisService.generateReportTableHtml(DefaultPushAnalysisService.java:411)
at org.hisp.dhis.pushanalysis.DefaultPushAnalysisService.getItemHtml(DefaultPushAnalysisService.java:319)
at org.hisp.dhis.pushanalysis.DefaultPushAnalysisService.generateHtmlReport(DefaultPushAnalysisService.java:261)
at org.hisp.dhis.pushanalysis.DefaultPushAnalysisService.runPushAnalysis(DefaultPushAnalysisService.java:221)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy138.runPushAnalysis(Unknown Source)
at org.hisp.dhis.pushanalysis.scheduling.PushAnalysisJob.execute(PushAnalysisJob.java:61)
at org.hisp.dhis.scheduling.DefaultJobInstance.executeJob(DefaultJobInstance.java:145)
at org.hisp.dhis.scheduling.DefaultJobInstance.execute(DefaultJobInstance.java:59)
at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$internalExecuteJobConfiguration$2(DefaultSchedulingManager.java:237)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
* INFO 2020-04-21 12:09:28,890 'system-process' create org.hisp.dhis.message.MessageConversation, name: Job 'pushAnalysisJob from controller' failed, uid: pF1sDdYqNts (AuditLogUtil.java [taskScheduler-16])
* INFO 2020-04-21 12:09:28,920 no recipient (SmsMessageSender.java [taskScheduler-16])
* ERROR 2020-04-21 12:09:28,925 Job 'pushAnalysisJob from controller' failed (DefaultJobInstance.java [taskScheduler-16])
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:518)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy138.runPushAnalysis(Unknown Source)
at org.hisp.dhis.pushanalysis.scheduling.PushAnalysisJob.execute(PushAnalysisJob.java:61)
at org.hisp.dhis.scheduling.DefaultJobInstance.executeJob(DefaultJobInstance.java:145)
at org.hisp.dhis.scheduling.DefaultJobInstance.execute(DefaultJobInstance.java:59)
at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$internalExecuteJobConfiguration$2(DefaultSchedulingManager.java:237)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Thanks,
Tafsir