← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Analytics Error

 

Dear Knut,
Please find the attached copy of the full process.

On May 28, 2017 14:49, "Knut Staring" <knutst@xxxxxxxxx> wrote:
>
> Dear Gerald,
>
> The picture you sent only shows the last 20 steps or so, and indicates that they took only a second. Are you able to see which earlier steps took so much longer?
>
> Knut
>
> On Sun, May 28, 2017 at 3:23 PM, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>>
>> Dear all,
>> I finally got it to successfully run but it took almost 4 hours for it
>> to ran completely after tweaking the postgresql.conf file based on the
>> explanations on the implementation manual.
>>
>> Now, my question will be how can i reduce time for analytics giving
>> that my RAM is 7168 MB, 150 GB disk space.
>>
>> On 5/28/17, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>> > Dear All,
>> > I created a test instance but analytics takes time to run and doesn't
>> > complete. The error below was found in the catalina.out file during
>> > analytics:
>> >
>> > Caused by: org.Postgresql.util.PSQLException: ERROR: relation
>> > "analytics_completenesstarget" does not exist
>> > Postion: 51
>> >
>> > Please find the screen print after analytics failed.
>> >
>> > --
>> > Regards,
>> >
>> > Gerald
>> >
>>
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
2017-05-28 12:58:43	Analytics tables updated: 03:53:14.237  
2017-05-28 12:58:43	No events exist, not updating event analytics tables  
2017-05-28 12:58:43	Updating tables: ENROLLMENT  
2017-05-28 12:58:43	No events exist, not updating event analytics tables  
2017-05-28 12:58:43	Updating tables: EVENT  
2017-05-28 12:58:43	Table update done  
2017-05-28 12:58:43	Clearing caches  
2017-05-28 12:58:43	Creating SQL views  
2017-05-28 12:58:43	Swapping tables  
2017-05-28 12:58:43	Swapping analytics tables  
2017-05-28 12:58:43	Analyzing analytics tables  
2017-05-28 12:58:43	Creating indexes  
2017-05-28 12:58:43	Applying aggregation levels  
2017-05-28 12:58:42	Populating analytics tables  
2017-05-28 12:58:42	Creating analytics tables  
2017-05-28 12:58:42	Performing pre-create table work, org unit levels: 4  
2017-05-28 12:58:42	Updating tables: ORG_UNIT_TARGET  
2017-05-28 12:58:42	Table update done  
2017-05-28 12:58:42	Clearing caches  
2017-05-28 12:58:42	Creating SQL views  
2017-05-28 12:58:42	Swapping tables  
2017-05-28 12:58:42	Swapping analytics tables  
2017-05-28 12:58:42	Analyzing analytics tables  
2017-05-28 12:58:42	Creating indexes  
2017-05-28 12:58:42	Applying aggregation levels  
2017-05-28 12:58:41	Populating analytics tables  
2017-05-28 12:58:41	Creating analytics tables  
2017-05-28 12:58:41	Performing pre-create table work, org unit levels: 4  
2017-05-28 12:58:41	Updating tables: COMPLETENESS_TARGET  
2017-05-28 12:58:41	Table update done  
2017-05-28 12:58:41	Clearing caches  
2017-05-28 12:58:41	Creating SQL views  
2017-05-28 12:58:41	Swapping tables  
2017-05-28 12:58:41	Swapping analytics tables  
2017-05-28 12:58:35	Analyzing analytics tables  
2017-05-28 12:58:14	Creating indexes  
2017-05-28 12:58:14	Applying aggregation levels  
2017-05-28 12:58:09	Populating analytics tables  
2017-05-28 12:58:09	Creating analytics tables  
2017-05-28 12:58:09	Performing pre-create table work, org unit levels: 4  
2017-05-28 12:58:08	Updating tables: COMPLETENESS  
2017-05-28 12:58:08	Table update done  
2017-05-28 12:58:08	Clearing caches  
2017-05-28 12:58:07	Creating SQL views  
2017-05-28 12:58:04	Swapping tables  
2017-05-28 12:58:03	Swapping analytics tables  
2017-05-28 12:55:46	Analyzing analytics tables  
2017-05-28 12:11:30	Creating indexes  
2017-05-28 11:37:19	Applying aggregation levels  
2017-05-28 09:06:50	Populating analytics tables  
2017-05-28 09:06:49	Creating analytics tables  
2017-05-28 09:06:49	Performing pre-create table work, org unit levels: 4  
2017-05-28 09:05:56	Updating tables: DATA_VALUE  
2017-05-28 09:05:29	Updating resource tables  
2017-05-28 09:05:29	Analytics table update process started  

References