← Back to team overview

dhis2-devs team mailing list archive

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