dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #44592
Re: Datamart error
Any help on this error?
On Mon, Apr 25, 2016 at 7:53 PM, Pramil Liyanage <pramilcl@xxxxxxxxx> wrote:
> 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
>
References