dhis2-devs team mailing list archive

[Pramil Liyanage <pramilcl@xxxxxxxxx>]

​Hi Lars,

Thanks for the reply. Same issue is there in 2.20 also. When upgraded to
2.22 there are no errors in the analytic table update, but data entered in
the dataset is not available in reports. Log also attached.

Thanks
Pramil

2016-04-25 14:11:18Analytics tables updated: 00:00:51.725  2016-04-25
14:11:18Table update done  2016-04-25 14:11:18Clearing caches  2016-04-25
14:11:18Creating SQL views  2016-04-25 14:11:17Swapping tables  2016-04-25
14:11:17Swapping analytics tables  2016-04-25 14:11:05Creating indexes
 2016-04-25 14:11:05Applying aggregation levels  2016-04-25
14:11:05Populating analytics tables  2016-04-25 14:11:05Creating analytics
tables  2016-04-25 14:11:05Performing pre-create table work, processes: 3,
org unit levels: 4  2016-04-25 14:11:04Updating event analytics table
 2016-04-25 14:11:04Table update done  2016-04-25 14:11:04Clearing caches
 2016-04-25 14:11:04Creating SQL views  2016-04-25 14:11:04Swapping tables
 2016-04-25 14:11:04Swapping analytics tables  2016-04-25 14:11:04Creating
indexes  2016-04-25 14:11:04Applying aggregation levels  2016-04-25
14:11:04Populating analytics tables  2016-04-25 14:11:04Creating analytics
tables  2016-04-25 14:11:04Performing pre-create table work, processes: 3,
org unit levels: 4  2016-04-25 14:11:04Updating organisation unit target
table  2016-04-25 14:11:04Table update done  2016-04-25 14:11:04Clearing
caches  2016-04-25 14:11:04Creating SQL views  2016-04-25 14:11:04Swapping
tables  2016-04-25 14:11:04Swapping analytics tables  2016-04-25
14:11:04Creating indexes  2016-04-25 14:11:04Applying aggregation levels
 2016-04-25 14:11:04Populating analytics tables  2016-04-25
14:11:04Creating analytics tables  2016-04-25 14:11:04Performing pre-create
table work, processes: 3, org unit levels: 4  2016-04-25 14:11:04Updating
completeness target table  2016-04-25 14:11:04Table update done  2016-04-25
14:11:04Clearing caches  2016-04-25 14:11:04Creating SQL views  2016-04-25
14:11:04Swapping tables  2016-04-25 14:11:04Swapping analytics tables
 2016-04-25 14:11:03Creating indexes  2016-04-25 14:11:03Applying
aggregation levels  2016-04-25 14:11:03Populating analytics tables
 2016-04-25 14:11:03Creating analytics tables  2016-04-25
14:11:03Performing pre-create table work, processes: 3, org unit levels: 4
 2016-04-25 14:11:03Updating completeness table  2016-04-25 14:11:03Table
update done  2016-04-25 14:11:03Clearing caches  2016-04-25
14:11:03Creating SQL views  2016-04-25 14:11:03Swapping tables  2016-04-25
14:11:03Swapping analytics tables  2016-04-25 14:11:04Creating indexes
 2016-04-25 14:11:04Applying aggregation levels  2016-04-25
14:11:04Populating analytics tables  2016-04-25 14:11:04Creating analytics
tables  2016-04-25 14:11:04Performing pre-create table work, processes: 3,
org unit levels: 4  2016-04-25 14:11:04Updating completeness target table
 2016-04-25 14:11:04Table update done  2016-04-25 14:11:04Clearing caches
 2016-04-25 14:11:04Creating SQL views  2016-04-25 14:11:04Swapping tables
 2016-04-25 14:11:04Swapping analytics tables  2016-04-25 14:11:03Creating
indexes  2016-04-25 14:11:03Applying aggregation levels  2016-04-25
14:11:03Populating analytics tables  2016-04-25 14:11:03Creating analytics
tables  2016-04-25 14:11:03Performing pre-create table work, processes: 3,
org unit levels: 4  2016-04-25 14:11:03Updating completeness table
 2016-04-25 14:11:03Table update done  2016-04-25 14:11:03Clearing caches
 2016-04-25 14:11:03Creating SQL views  2016-04-25 14:11:03Swapping tables
 2016-04-25 14:11:03Swapping analytics tables  2016-04-25 14:11:00Creating
indexes  2016-04-25 14:10:59Applying aggregation levels  2016-04-25
14:11:00Creating indexes  2016-04-25 14:10:59Applying aggregation levels
 2016-04-25 14:10:59Populating analytics tables  2016-04-25
14:10:58Creating analytics tables  2016-04-25 14:10:58Performing pre-create
table work, processes: 3, org unit levels: 4  2016-04-25 14:10:58Updating
analytics tables  2016-04-25 14:10:59Populating analytics tables
 2016-04-25 14:10:58Creating analytics tables  2016-04-25
14:10:58Performing pre-create table work, processes: 3, org unit levels: 4
 2016-04-25 14:10:58Updating analytics tables  2016-04-25 14:10:26Updating
resource tables  2016-04-25 14:10:26Analytics table update process started

Attachment: catalina.out
Description: Binary data