dhis2-users team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

Adolphe,

So after deleting both analytics tables and resource tables - which might
have become corrupted due to e.g. lack of harddisk space previously - you
are now running analytics successfully, with no errors? BUT you are now not
getting any output from Events Reports?

In that case, take a good look at the enrollment analytics table(s) and the
event analytics table(s), and verify that the facility cases you are trying
to display in event reports
- do exist in the relevant enrollment and/or event tables
- that all typical lookup fields in those tables have valid values (e.g.
compare with the same table in another well-functioning instance).

Regards
Calle

On 1 August 2018 at 16:13, Kamugunga Adolphe <kaadol@xxxxxxxxx> wrote:

> 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
>>
>> *******************************************
>>
>>
>


-- 

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************