dhis2-users team mailing list archive

["Abdul karim Jaafar" <abdulkarim.jaafar87@xxxxxxxxx>]

Dears Uwe and knut,

 

-          I actually tried new build for DHIS2 2.22 also I tried upgrading to 2.23 and 2.24 without any change in analytics period, in Catalina.out there is no error in analytics period, but the first step that according to ”organisationunit structure” takes too much time than the other steps also it create a lot of analytic tables like “analytics_event_2061_weonplpea8a” with no data and expectable  year “2061, 2006,2018,2010,2017”

 

-          What do you mean by: “rebuild/repair all the indexes in my installation”, how can I do maintains to database

 

I thing the problem came from categoryoptioncombo when I’ve compared between these tables: _categoryoptioncomboname, categoryoptioncombo and > Categoryombos_optioncombos I found about two hundred thousand categoryoptioncomboid that not exist in table and not exist in others, also I noticed that analytic period increase when I add new category options to attribute categories.

 

Any idea?

 

From: Knut Staring [mailto:knutst@xxxxxxxxx] 
Sent: Wednesday, October 12, 2016 3:35 PM
To: Uwe Wahser <uwe@xxxxxxxxx>
Cc: Abdul karim Jaafar <abdulkarim.jaafar87@xxxxxxxxx>; dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] long period of analytics

 

Maybe also test an upgrade? 

 

On 12 Oct 2016 14:22, "Uwe Wahser" <uwe@xxxxxxxxx <mailto:uwe@xxxxxxxxx> > wrote:

Hi Abdul,

I saw that you posted this already a few months ago - without success, as it
seems. So let me just take a lucky guess, of what else you could try (that's
what I'd try):

- in catalina.out, can you identify a specific phase of the analytics run where
most of the time is spent or is everything taking longer. Maybe with that detail
info the DEV team can help you further.
- can you try to list the available database indexes in your installation and
compare with a fresh install of DHIS2.22 if any are missing?
- can you try to rebuild/repair all the indexes in your installation (never
tried this in PostgreSQL myself, though)

Don't know if this makes sense, but better than nothing :-)

Regards, Uwe


> Abdul karim Jaafar <abdulkarim.jaafar87@xxxxxxxxx <mailto:abdulkarim.jaafar87@xxxxxxxxx> > hat am 12. Oktober 2016 um
> 12:22 geschrieben:
>
>
> Dears all,
>
>
>
> I’ve been facing a problem with analytic period for over than two months,
>
>
>
> And I didn’t find any solution for this problem.
>
>
>
> I did a tuning for Postgres and every week I did maintains from data
> administration, also there is no problems in data integrity.
>
>
>
> But the analytic period is increasing gradually for over than 20 hours
>
>
>
> I don’t know what are thing that increase the period for analytics table
> update.
>
>
>
> we have:
>
> Tracked entity instance: 97358
>
> Tracked entity data value: 1872790
>
> Tracked entity attribute data value: 1217314
>
> Data value: 614956
>
>
>
> Also I have these rows in table below:
>
> _Categoryoptioncomboname: 437689 rows
>
> Categoryombos_optioncombos: 669471 rows
>
>
>
> We did hosting in our own server kindly look for information below:
>
> DHIS2, Database and hosting information:
>
> Version: 2.22
>
> Build revision: 22090
>
> Environment variable:DHIS2_HOME
>
> External configuration directory:/home/dhis/config
>
> File store provider: filesystem
>
> Database type: PostgreSQL
>
> Database name: dhis2
>
> Database user: dhis
>
> Java opts: -Xmx16000m -Xms8000m
>
> Java home: /usr/lib/jvm/java-8-oracle/jre
>
> Java temporary directory: /home/dhis/tomcat-dhis/temp
>
> Java version: 1.8.0_101
>
> Java vendor: Oracle Corporation
>
> OS name: Linux
>
> OS architecture: amd64
>
> OS version: 4.4.0-34-generic
>
> Server memory: Mem Total in JVM: 10237 Free in JVM: 8507 Max Limit: 14222
>
> CPU cores:12
>
> Users information:
>
> There are: 63 users
>
> User role: 13
>
>
>
> I think this volume data not too much to effects the analytics.
>
>
>
> Any solutions please?
>
>
>
>
>
> Best regards,
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> 
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> 
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp