dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

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(Executors.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(Executors.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

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

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

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