← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Job 'inMemoryAnalyticsJob' failed

 

Hi Adolphe,

The error points to lack of disk space. Check that as well.

Regards,
Jason

On Wed, Jul 4, 2018, 10:55 gerald thomas <gerald17006@xxxxxxxxx> wrote:

> Dear Kamugunga,
> I think they are still in the completedatasetregistration. Please run the
> query below so that we can know the quantity.
> We will have to delete them here and at the analytics tables again.
>
> dhis-# SELECT p.startdate, count(dv.datasetid) as recno from
> completedatasetregistration dv INNER JOIN period p on
> p.periodid=dv.periodid group by p.startdate order by p.startdate;
>
>
> On Wed, 4 Jul 2018 at 14:43, Kamugunga Adolphe <kaadol@xxxxxxxxx> wrote:
>
>> Hi Thomas and Dan for sharing your experience,
>> However i have dropped the analytics table and analytics_temp tables. and
>> deploy my the recent war file. Then i run the analytics successfully.
>> Afterward i started receiven the same massage as by attachment.
>>
>> I am suspecting jobs that are by default created in the new feature of
>> "Scheduler" Can any one explain reasons of having these? And please share
>> more hints on how to deal with this problem.
>>
>> Regards
>>
>>
>>
>>
>>
>>
>> *Adolphe Kamugunga*
>> *MIS Technical Advisor*
>> Mobile: +250 788 740 578
>> Email:kaadol@xxxxxxxxx
>> Skype: ka.adolphe
>>  RWANDA
>>
>>
>> On 3 July 2018 at 23:56, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>>
>>> Dear Kamugunga,
>>> I think you need to shutdown instance; remove your current war file
>>> folder e.g ROOT or dhis which depends on the name of your war file.
>>> Switch to your Postgres database and manually delete all those analytics
>>> tables. Then you restart instance and monitor log at startup and when
>>> running analytics again.
>>>
>>>
>>> On Tue, 3 Jul 2018 at 16:57, Kamugunga Adolphe <kaadol@xxxxxxxxx> wrote:
>>>
>>>> Hi,
>>>>
>>>> I have upgraded my 2.28 instance to 2.29  version,7c81fba
>>>> Build date: 2018-06-28 06:46 . I have run the upgrade scripts before as
>>>> instructed in guide. My server runs ubuntu 14.04 and postgresql 9.5.5.
>>>>
>>>> However since then, my analytics is not running, i am receiving number
>>>> of system emails with subject " Job 'Credentials expiry alert' failed; Job
>>>> 'inMemoryAnalyticsJob' failed;Analytics table process failed "
>>>>
>>>> Attached are some screenshots of the message. I tried to clear
>>>> analytics tables and run analytics again but its not  improving.
>>>>
>>>> The online 2.29 demo also has the same message bu with different
>>>> contents.
>>>>
>>>> Please share the hints on how i can dealt with these. As my system has
>>>> to sent out notification messages when thresholds are reached.
>>>>
>>>> Regards,
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *Adolphe Kamugunga*
>>>> *MIS Technical Advisor*
>>>> Mobile: +250 788 740 578;
>>>> Email:kaadol@xxxxxxxxx
>>>> Skype: ka.adolphe
>>>>  RWANDA
>>>>
>>>>
>>>> On 1 July 2018 at 01:04, gerald thomas <gerald17006@xxxxxxxxx> wrote:
>>>>
>>>>> Djibril,
>>>>> Why not try to install java 8 manually?
>>>>>
>>>>> Follow these steps:
>>>>>
>>>>> https://tecadmin.net/install-oracle-java-8-ubuntu-via-ppa/
>>>>>
>>>>> On Sat, 30 Jun 2018 at 22:26, DJIBRIL Hakim <djib.hakim@xxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi all,
>>>>>> I am setting up dhis2 instance on ubuntu 16.04 with dhis2-tools.
>>>>>> When I am running this instance and choose to view log with
>>>>>> dhis2-logtail, I got this error
>>>>>> *usr/share/tomcat7/bin/catalina.sh: 1: eval:
>>>>>> /usr/lib/jvm/java-8-oracle/jre/bin/java: not found*
>>>>>>
>>>>>> What can I do to fix it ?
>>>>>> Best
>>>>>> _______________________________________________
>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>
>>>>> --
>>>>> Regards,
>>>>>
>>>>> Gerald
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>> Post to     : 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
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>> --
>>> 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
>

PNG image

PNG image

PNG image

PNG image


Follow ups

References