dhis2-users team mailing list archive

[Kamugunga Adolphe <kaadol@xxxxxxxxx>]

Thanks calle for suggestions,
I tried this option before, but didn't drop the resource tables starting
with under-score. The analytics runs and display it is successful , but
from Event reports i can't even list facilty cases reported! Did anyone
tried to disable  all jobs in scheduler and share the effect of that?


*Adolphe Kamugunga*
*MIS Technical Advisor*
Mobile: +250 788 740 578
Email:kaadol@xxxxxxxxx
Skype: ka.adolphe
 RWANDA


On 1 August 2018 at 13:20, Calle Hedberg <calle.hedberg@xxxxxxxxx> wrote:

> Adolphe,
>
> Try to drop all analytics tables manually (EXCEPT
> analyticsperiodboundary!!), and preferably also the resource tables
> starting with under-score. Then try again.
>
> Regards
> Calle
>
> On 31 July 2018 at 18:55, Kamugunga Adolphe <kaadol@xxxxxxxxx> wrote:
>
>> Dear Dave,
>>
>> I tried your workaround but analytics run once successfully  and compile
>> aggregate values of my weekly reports only, the dashboard with  cases based
>> data(program indicators) don't have values. The strange situation is that
>> from Event Reports app, i list/display events reported before upgrade only
>> and when i change the period to "This month" no values displayed.
>>
>> I run again the analytics but it failed with similar message. If someone
>> has another alternative to fix this plz let me know!  I am completely stack?
>> The instance is updated with the today build version Version:2.29Build
>> revision:153207cBuild date:2018-07-31 06:50Jasper reports version:6.3.1
>>
>>
>> Down here is the error message content:
>>
>>
>>
>>
>> Job 'inMemoryAnalyticsJob' failed
>>
>> System title:Integrated Disease Surveillance
>> Base URL:
>> Time: 2018-07-31T16:04:01.496+02:00
>> Message: StatementCallback; uncategorized SQLException for SQL [drop
>> table analytics]; SQL state [2BP01]; error code [0]; ERROR: cannot drop
>> table analytics because other objects depend on it
>> Detail: table analytics_2004 depends on table analytics
>> table analytics_2005 depends on table analytics
>> table analytics_2007 depends on table analytics
>> table analytics_2008 depends on table analytics
>> table analytics_2009 depends on table analytics
>> table analytics_2010 depends on table analytics
>> table analytics_2011 depends on table analytics
>> table analytics_2012 depends on table analytics
>> table analytics_2013 depends on table analytics
>> table analytics_2014 depends on table analytics
>> table analytics_2015 depends on table analytics
>> Hint: Use DROP ... CASCADE to drop the dependent objects too.; nested
>> exception is org.postgresql.util.PSQLException: ERROR: cannot drop table
>> analytics because other objects depend on it
>> Detail: table analytics_2004 depends on table analytics
>> table analytics_2005 depends on table analytics
>> table analytics_2007 depends on table analytics
>> table analytics_2008 depends on table analytics
>> table analytics_2009 depends on table analytics
>> table analytics_2010 depends on table analytics
>> table analytics_2011 depends on table analytics
>> table analytics_2012 depends on table analytics
>> table analytics_2013 depends on table analytics
>> table analytics_2014 depends on table analytics
>> table analytics_2015 depends on table analytics
>> Hint: Use DROP ... CASCADE to drop the dependent objects too.
>>
>> Cause: org.postgresql.util.PSQLException: ERROR: cannot drop table
>> analytics because other objects depend on it
>> Detail: table analytics_2004 depends on table analytics
>> table analytics_2005 depends on table analytics
>> table analytics_2007 depends on table analytics
>> table analytics_2008 depends on table analytics
>> table analytics_2009 depends on table analytics
>> table analytics_2010 depends on table analytics
>> table analytics_2011 depends on table analytics
>> table analytics_2012 depends on table analytics
>> table analytics_2013 depends on table analytics
>> table analytics_2014 depends on table analytics
>> table analytics_2015 depends on table analytics
>> Hint: Use DROP ... CASCADE to drop the dependent objects too.
>> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons
>> e(QueryExecutorImpl.java:2422)
>> at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer
>> yExecutorImpl.java:2167)
>> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut
>> orImpl.java:306)
>> at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
>> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
>> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
>> at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
>> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
>> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
>> at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyS
>> tatement.java:75)
>> at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatement
>> Callback.doInStatement(JdbcTemplate.java:436)
>> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTempl
>> ate.java:408)
>> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTempl
>> ate.java:445)
>> at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.execu
>> teSilently(AbstractJdbcTableManager.java:341)
>> at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.swapT
>> able(AbstractJdbcTableManager.java:508)
>> at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.swapT
>> able(AbstractJdbcTableManager.java:178)
>> at sun.reflect.GeneratedMethodAccessor2130.invoke(Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>> thodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:498)
>> at org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>> gReflection(AopUtils.java:333)
>> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>> JdkDynamicAopProxy.java:207)
>> at com.sun.proxy.$Proxy142.swapTable(Unknown Source)
>> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.l
>> ambda$swapTables$5(DefaultAnalyticsTableService.java:373)
>> at java.util.ArrayList.forEach(ArrayList.java:1249)
>> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.s
>> wapTables(DefaultAnalyticsTableService.java:373)
>> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.u
>> pdate(DefaultAnalyticsTableService.java:171)
>> at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator
>> .generateTables(DefaultAnalyticsTableGenerator.java:115)
>> at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableJob.e
>> xecute(AnalyticsTableJob.java:70)
>> at org.hisp.dhis.scheduling.DefaultJobInstance.executeJob(Defau
>> ltJobInstance.java:145)
>> at org.hisp.dhis.scheduling.DefaultJobInstance.execute(DefaultJ
>> obInstance.java:59)
>> at org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$int
>> ernalExecuteJobConfiguration$2(DefaultSchedulingManager.java:237)
>> at java.util.concurrent.Executors$RunnableAdapter.call(Executor
>> s.java:511)
>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>> at org.springframework.scheduling.support.DelegatingErrorHandli
>> ngRunnable.run(DelegatingErrorHandlingRunnable.java:54)
>> at java.util.concurrent.Executors$RunnableAdapter.call(Executor
>> s.java:511)
>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu
>> tureTask.access$201(ScheduledThreadPoolExecutor.java:180)
>> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFu
>> tureTask.run(ScheduledThreadPoolExecutor.java:293)
>> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
>> Executor.java:1142)
>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
>> lExecutor.java:617)
>> at java.lang.Thread.run(Thread.java:745)
>>
>>
>>
>> *Adolphe Kamugunga*
>> *MIS Technical Advisor*
>> Mobile: +250 788 740 578
>> Email:kaadol@xxxxxxxxx
>> Skype: ka.adolphe
>>  RWANDA
>>
>>
>> On 5 July 2018 at 15:38, David Huser <dhuser@xxxxxxxxxxxxxx> wrote:
>>
>>> Is it possible that the Reports app to run analytics does something
>>> different to what the Scheduler does, not dropping / creating the same
>>> tables? We added a JIRA issue <https://jira.dhis2.org/browse/DHIS2-4214>
>>> describing this - Scheduler cannot complete analytics generation once
>>> Reports has created analytics beforehand.
>>>
>>> A workaround for now is so far is to clear analytics via Data Admin >
>>> Maintenance then using the Scheduler only to run - manually or scheduled.
>>>
>>> Regards,
>>> David
>>>
>>> On Wed, Jul 4, 2018 at 6:28 PM gerald thomas <gerald17006@xxxxxxxxx>
>>> wrote:
>>>
>>>> Dear Jason,
>>>> That is true but the errors are still generating into the various
>>>> analytics tables. That is why I wanted him to check those tables and if
>>>> there are data in them he should delete them.
>>>>
>>>> On Wed, 4 Jul 2018 at 15:53, Jason Pickering <
>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>
>>>>> 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
>>>>>>
>>>>> --
>>>> 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
>>>>
>>>
>>>
>>> --
>>>
>>>
>>> *David Huser*
>>> DHIS2 Support Specialist
>>> dhuser@xxxxxxxxxxxxxx | https://baosystems.com |  2900 K Street, Suite
>>> 507, Washington D.C. 20007
>>>
>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
>
> *******************************************
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> <https://maps.google.com/?q=46D+Alma+Road,+7700+Rosebank,+SOUTH+AFRICA&entry=gmail&source=g>
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>