* INFO  2019-03-24 11:39:01,652 Found 7 analytics table types: [EVENT, ORG_UNIT_TARGET, COMPLETENESS_TARGET, ENROLLMENT, VALIDATION_RESULT, COMPLETENESS, DATA_VALUE] (DefaultAnalyticsTableGenerator.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,652 Skip 4 analytics table types: [EVENT, COMPLETENESS_TARGET, COMPLETENESS, DATA_VALUE] (DefaultAnalyticsTableGenerator.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,653 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:01 WAT 2019, message: Analytics table update process started] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,654 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:01 WAT 2019, message: Updating tables: ORG_UNIT_TARGET] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,654 Starting update: analytics_orgunittarget, processes: 3, org unit levels: 5: 00:00:00.000 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,656 Table update start: analytics_orgunittarget, partitions: [analytics_orgunittarget], last years: 2, earliest: Mon Jan 01 00:00:00 WAT 2018: 00:00:00.001 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,659 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:01 WAT 2019, message: Performing pre-create table work, org unit levels: 5] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,659 Performed pre-create table work: 00:00:00.004 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,659 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:01 WAT 2019, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,663 Creating table: analytics_orgunittarget_temp, columns: 6 (JdbcOrgUnitTargetTableManager.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,667 Created analytics tables: 00:00:00.012 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,667 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:01 WAT 2019, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,668 Populate table task number: 1 (DefaultAnalyticsTableService.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,722 Populated table in 0,05 seconds: analytics_orgunittarget_temp (AbstractJdbcTableManager.java [taskScheduler-11])
* INFO  2019-03-24 11:39:01,722 Populated analytics tables: 00:00:00.068 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,722 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:01 WAT 2019, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,724 Vacuumed tables (DefaultAnalyticsTableService.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,725 Applied aggregation levels: 00:00:00.070 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,725 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:01 WAT 2019, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,725 No of analytics table indexes: 6 (DefaultAnalyticsTableService.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,937 Created indexes: 00:00:00.282 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:01,937 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:01 WAT 2019, message: Analyzing analytics tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,164 Analyzed tables: 00:00:00.509 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,164 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Swapping analytics tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,186 Dropped SQL views: 00:00:00.532 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,187 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Swapping tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,193 Swapped tables: 00:00:00.538 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,193 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Creating SQL views] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,244 Swapped tables: 00:00:00.590 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,245 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Clearing caches] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,245 Table update done: analytics_orgunittarget: 00:00:00.591 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,245 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Table update done] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,245 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Updating tables: VALIDATION_RESULT] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,246 Starting update: analytics_validationresult, processes: 3, org unit levels: 5: 00:00:00.000 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,247 Get tables using earliest: Mon Jan 01 00:00:00 WAT 2018 (JdbcValidationResultTableManager.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,251 Table update start: analytics_validationresult, partitions: [analytics_validationresult_2018], last years: 2, earliest: Mon Jan 01 00:00:00 WAT 2018: 00:00:00.004 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,251 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Performing pre-create table work, org unit levels: 5] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,252 Performed pre-create table work: 00:00:00.005 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,252 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Creating analytics tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,255 Creating table: analytics_validationresult_temp_2018, columns: 25 (JdbcValidationResultTableManager.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,258 Created analytics tables: 00:00:00.011 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,258 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Populating analytics tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,258 Populate table task number: 1 (DefaultAnalyticsTableService.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,267 Populated table in 0,01 seconds: analytics_validationresult_temp_2018 (AbstractJdbcTableManager.java [taskScheduler-25])
* INFO  2019-03-24 11:39:02,268 Populated analytics tables: 00:00:00.021 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,268 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Applying aggregation levels] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,270 Vacuumed tables (DefaultAnalyticsTableService.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,270 Applied aggregation levels: 00:00:00.023 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,271 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Creating indexes] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,271 No of analytics table indexes: 25 (DefaultAnalyticsTableService.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,382 Created indexes: 00:00:00.136 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,383 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Analyzing analytics tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,387 Analyzed tables: 00:00:00.141 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,387 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Swapping analytics tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,406 Dropped SQL views: 00:00:00.159 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,407 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Swapping tables] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,416 Swapped tables: 00:00:00.169 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,416 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Creating SQL views] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,460 Swapped tables: 00:00:00.214 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,461 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Clearing caches] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,461 Table update done: analytics_validationresult: 00:00:00.214 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,461 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Table update done] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,461 [Level: INFO, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Updating tables: ENROLLMENT] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,462 Starting update: analytics_enrollment, processes: 3, org unit levels: 5: 00:00:00.000 (Clock.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,469 [Level: ERROR, category: ANALYTICSTABLE_UPDATE, time: Sun Mar 24 11:39:02 WAT 2019, message: Process failed: null] (InMemoryNotifier.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,470 'system-process' create org.hisp.dhis.message.MessageConversation, name: Analytics table process failed, uid: NTeda5YTR92 (AuditLogUtil.java [taskScheduler-13])
* INFO  2019-03-24 11:39:02,477 sms notifications are disabled (SmsMessageSender.java [taskScheduler-13])
* ERROR 2019-03-24 11:39:02,493 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-13])
java.lang.NullPointerException
	at org.hisp.dhis.program.Program.lambda$getNonConfidentialTrackedEntityAttributes$3(Program.java:278)
	at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:174)
	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
	at org.hisp.dhis.program.Program.getNonConfidentialTrackedEntityAttributes(Program.java:278)
	at org.hisp.dhis.analytics.table.JdbcEnrollmentAnalyticsTableManager.getDimensionColumns(JdbcEnrollmentAnalyticsTableManager.java:199)
	at org.hisp.dhis.analytics.table.JdbcEnrollmentAnalyticsTableManager.getTables(JdbcEnrollmentAnalyticsTableManager.java:90)
	at org.hisp.dhis.analytics.table.JdbcEnrollmentAnalyticsTableManager.getTables(JdbcEnrollmentAnalyticsTableManager.java:71)
	at sun.reflect.GeneratedMethodAccessor1239.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.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy167.getTables(Unknown Source)
	at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:117)
	at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator.generateTables(DefaultAnalyticsTableGenerator.java:112)
	at org.hisp.dhis.webapi.controller.ResourceTableController.lambda$analytics$0(ResourceTableController.java:112)
	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)
* WARN  2019-03-24 11:40:47,720 Monitoring request failed, status code: null (DefaultMonitoringService.java [taskScheduler-24])
org.springframework.web.client.HttpClientErrorException: 401 null
	at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:63)
	at org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:700)
	at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:653)
	at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:613)
	at org.springframework.web.client.RestTemplate.postForEntity(RestTemplate.java:407)
	at org.hisp.dhis.dxf2.monitoring.DefaultMonitoringService.pushMonitoringInfo(DefaultMonitoringService.java:125)
	at org.hisp.dhis.dxf2.monitoring.DefaultMonitoringService.lambda$init$0(DefaultMonitoringService.java:83)
	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.runAndReset(FutureTask.java:308)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
	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)
* WARN  2019-03-24 11:45:52,276 Monitoring request failed, status code: null (DefaultMonitoringService.java [taskScheduler-8])
org.springframework.web.client.HttpClientErrorException: 401 null
	at org.springframework.web.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:63)
	at org.springframework.web.client.RestTemplate.handleResponse(RestTemplate.java:700)
	at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:653)
	at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:613)
	at org.springframework.web.client.RestTemplate.postForEntity(RestTemplate.java:407)
	at org.hisp.dhis.dxf2.monitoring.DefaultMonitoringService.pushMonitoringInfo(DefaultMonitoringService.java:125)
	at org.hisp.dhis.dxf2.monitoring.DefaultMonitoringService.lambda$init$0(DefaultMonitoringService.java:83)
	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.runAndReset(FutureTask.java:308)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
	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)