* 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,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 Performed pre-create table work: 00:00:00.004 (Clock.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,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,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 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:02,164 Analyzed tables: 00:00:00.509 (Clock.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,193 Swapped tables: 00:00:00.538 (Clock.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 Table update done: analytics_orgunittarget: 00:00:00.591 (Clock.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,252 Performed pre-create table work: 00:00:00.005 (Clock.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 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,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 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,387 Analyzed tables: 00:00:00.141 (Clock.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,416 Swapped tables: 00:00:00.169 (Clock.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 Table update done: analytics_validationresult: 00:00:00.214 (Clock.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])