dhis2-users team mailing list archive

[Sarah Searle <ssearle@xxxxxxxxxxxxxx>]

Hi there,

There are a few Jira tickets related to Scheduler and Analytics:
https://jira.dhis2.org/browse/DHIS2-4214
https://jira.dhis2.org/browse/DHIS2-4664

I've also experienced inconsistencies related to Scheduler and analytics in
2.29 (and have seen that error message many times). Technically, per the
documentation, Scheduler is still experimental. We've sometimes had better
results scheduling analytics jobs on the server side, or running manually
through Reports in 2.29.

Best,
Sarah


On Wed, Nov 7, 2018 at 12:41 AM Em Le Hong <em.hispvietnam@xxxxxxxxx> wrote:

> Dear all,
>
> I realize that sometime our instance running on 2.29 can't generate
> analytic tables automatically as set in Scheduler.
> Then I try to run it manually and get the error message below:
>
> Process failed: StatementCallback; uncategorized SQLException for SQL
> [drop table if exists analytics_event_ii2ycz7om1u;alter table
> analytics_event_temp_ii2ycz7om1u rename to analytics_event_ii2ycz7om1u;];
> SQL state [2BP01]; error code [0]; ERROR: cannot drop table
> analytics_event_ii2ycz7om1u because other objects depend on it Detail:
> table analytics_event_2008_ii2ycz7om1u depends on table
> analytics_event_ii2ycz7om1u Hint: Use DROP ... CASCADE to drop the
> dependent objects too.; nested exception is
> org.postgresql.util.PSQLException: ERROR: cannot drop table
> analytics_event_ii2ycz7om1u because other objects depend on it Detail:
> table analytics_event_2008_ii2ycz7om1u depends on table
> analytics_event_ii2ycz7om1u Hint: Use DROP ... CASCADE to drop the
> dependent objects too.
>
> To solve this issue, I need to clean Analytic tables in Data
> Administration module before running analytic table
> [image: image.png]
>
> Is there any way that we can solve this issue completely? Because in the
> system About (dhis-web-commons-about/about.action) it's still show the *Time
> since last analytics table generation, *The time is correct, but actually
> data value not generated especially event data.
>
> Thanks,
>
> --
> *Em Le Hong*
> DHIS2 Implementation| *HISP Vietnam*
> em.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>
>
>
>
>
> _______________________________________________
> 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
>


-- 


*Sarah Searle*
Project Implementation Manager, BAO Systems
+1 202-536-1541 | ssearle@xxxxxxxxxxxxxx <ssearle@xxxxxxxxxxxxxx> |
http://www.baosystems.comSkype: searle.sarah | 2900 K Street, Suite 507,
Washington D.C. 20007

Register for the 2019 DHIS 2 Symposium:
<https://dhis2symposium.org>