[Dhis2-devs] System can't generate analytic tables
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.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] trackedEntityInstances SYNC
Hi Tomas,
It looks like this can be a possible bug (the program allows only 1 ACTIVE
enrollment, the system imports first the ACTIVE one and then it doesn't
consider that the second is COMPLETE and not ACTIVE. But I need to confirm
this).
Could you please provide a payload you are sending into the DHIS2? (If you
test it on Demo DB (and the payload is for Demo DB) it will be a plus). You
can send it directly to my email if you want.
Regarding mergeMode: I think, merging does not apply here and it applies
only to data values.
On Tue, Nov 6, 2018 at 12:39 PM, Tomas Sala
wrote:
> Hi,
>
>
>
> I am trying to import a trackedEntityInstance with two enrollments using
> the strategy SYNC, one is ACTIVE and the other one is COMPLETED. It only
> import the ACTIVE one and ignore the other one:
>
>
>
> "responseType": "ImportSummary",
>
> "status": "ERROR",
>
> "description": "TrackedEntityInstance
> z8txd6oJzR6 already has an active enrollment in program ORvg6A5ed7z",
>
> "importCount": {
>
> "imported": 0,
>
> "updated": 0,
>
> "ignored": 1,
>
> "deleted": 0
>
>
>
>
>
> I’m making this POST call /trackedEntityInstances?
> strategy=SYNC=MERGE
>
>
>
> Is it possible to avoid DHIS ignoring the COMPLETED enrolment and import
> both of them?
>
>
>
> Thank you!
>
>
>
> *Tomàs Sala Camarena*
>
> *Ehealth Technician, eHealth Team *
>
> *eHealth & Operations Applications (´Apps4OPS´)*
>
> *Projects & IT Unit *
>
> *Médecins Sans Frontières (MSF) Spain – Barcelona Office*
> Fixed: +34 933 213 043
>
> Email / Skype: *tomas.s...@barcelona.msf.org
> * - www.msf.org
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help : https://help.launchpad.net/ListHelp
>
>
--
Best regards / Mvh,
David Katuscak
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] Analytics Table Is Accumulating Data
Dear All, We task our instance to be running analytics every 4 hours during the course of the daily (24hours). But we just noticed that the analytic tables in the Postgres database is accumulating rather than dropping the old tables and repopulating them again which currently affecting our disk space. I am currently running PostgreSQL 10 and DHIS2 2.27 on our instance. Please can someone help with solution because i don't want to be manually delete analytics tables every time i notice an increase in my disk space. -- Regards, Gerald ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] trackedEntityInstances SYNC
Hi,
I am trying to import a trackedEntityInstance with two enrollments using the
strategy SYNC, one is ACTIVE and the other one is COMPLETED. It only import the
ACTIVE one and ignore the other one:
"responseType": "ImportSummary",
"status": "ERROR",
"description": "TrackedEntityInstance z8txd6oJzR6
already has an active enrollment in program ORvg6A5ed7z",
"importCount": {
"imported": 0,
"updated": 0,
"ignored": 1,
"deleted": 0
I'm making this POST call
/trackedEntityInstances?strategy=SYNC=MERGE
Is it possible to avoid DHIS ignoring the COMPLETED enrolment and import both
of them?
Thank you!
Tomàs Sala Camarena
Ehealth Technician, eHealth Team
eHealth & Operations Applications (´Apps4OPS´)
Projects & IT Unit
Médecins Sans Frontières (MSF) Spain - Barcelona Office
Fixed: +34 933 213 043
Email / Skype:
tomas.s...@barcelona.msf.org -
www.msf.org
Re: [Dhis2-devs] [Dhis2-users] DHIS2 2.30 IMPORT/EXPORT ISSUE
Hi Peter / Kris, We fixed the bug related to importing CSV (file extension) in caps. Can you guys send us the files to test so we can resolve the bugs. Additionally you can file bugs in jira.dhis2.org and assign me to resolve them. Regards, Adeel On Tue, Nov 6, 2018 at 6:38 AM Viet Nguyen wrote: > Hi Peter, > > Please help to report the issues you got on jira.dhis2.org so we could > check and fix the import/export app. > > Thanks, > > On Tue, Nov 6, 2018 at 10:24 AM Peter D Lubambi > wrote: > >> I think the import function in dhis2 2.30 is not working completely, can >> someone confirm otherwise? I, as well tried importing in 2.30 several times >> it never worked, had to downgrade to 2.29 then I was able to import. >> >> Peter >> >> On Mon, Nov 5, 2018, 3:09 PM Kristiyan Panayotov < >> kristi...@logicaloutcomes.net wrote: >> >>> Hi all – thank for your support and suggestions. >>> >>> >>> >>> We managed to find a solution to our problem. We downgraded to version >>> 2.29 and found a good balance between using the new Android app together >>> with import functionalities. >>> For importing Org Units through a .csv file in version 2.30 – I will say >>> that it was not possible after all. We tried many different combinations >>> for creating the .csv files and none was successful. Together with the fact >>> that some of the Org Unit csv files have been successfully imported in >>> versions 2.25 – 2.29 >>> >>> >>> >>> Regards and thank you all >>> >>> Kris >>> >>> >>> >>> *From:* Viet Nguyen [mailto:v...@dhis2.org] >>> *Sent:* Friday, November 2, 2018 10:24 AM >>> *To:* dco...@baosystems.com >>> *Cc:* Georgi Chakarov ; dhis2-users < >>> dhis2-us...@lists.launchpad.net>; Kristiyan Panayotov < >>> kristi...@logicaloutcomes.net>; dhis2-devs < >>> dhis2-devs@lists.launchpad.net> >>> *Subject:* Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE >>> >>> >>> >>> Hi Georgi and Kristiyan, >>> >>> >>> >>> Could you try to change the file extension from ".CSV" to lowercase and >>> import again ? I think this is a bug, already reported to the app developer >>> and he's fixing it. >>> >>> >>> >>> We also have added the import summary which will show all the import >>> errors. It's on master and being backported to 2.30. >>> >>> >>> >>> Regards, >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> On Fri, Nov 2, 2018 at 5:04 AM Dan Cocos wrote: >>> >>> Is it encoded as UTF-8? I noticed as few “special” charters and that >>> might cause problems. >>> >>> >>> >>> Dan Cocos >>> >>> *BAO Systems* >>> >>> On Nov 1, 2018, at 5:33 PM, Georgi Chakarov >>> wrote: >>> >>> Hi Blake, >>> >>> >>> >>> Thanks for your response! >>> >>> >>> >>> I am a colleague of Kristiyan. We use csv format as we have always used >>> for DHIS2 versions 2.28 and below. >>> >>> So it seems that DHIS2 changed standards for csv for some reason. The >>> exact same csv that Kris sent you was used to import org units in 2.28 >>> instance and now is not recognized. We compared the template layout in 2.30 >>> and it matches a 100% our file. I have also tried a csv export software >>> with different options of csv files with no luck. >>> >>> >>> >>> Maybe you could advice on how you generate csv files? >>> >>> >>> >>> Regards, >>> >>> Georgi >>> >>> >>> >>> *From:* Blake Hansen >>> *Sent:* Thursday, November 1, 2018 7:17 PM >>> *To:* Kristiyan Panayotov >>> *Cc:* calle.hedb...@gmail.com; DHIS 2 Users list < >>> dhis2-us...@lists.launchpad.net>; Georgi Chakarov < >>> geo...@logicaloutcomes.net>; dhis2-devs >>> *Subject:* Re: [Dhis2-devs] DHIS2 2.30 IMPORT/EXPORT ISSUE >>> >>> >>> >>> Hi Kris, >>> >>> >>> >>> I haven’t looked at your .csv file, but from your screenshot it is clear >>> DHIS2 is not recognising it as a .csv file type. If it were, you would see >>> an extra menu appear and be able to select the object type you are >>> attempting to create (see my screenshot). This is not visible in your >>> screenshot. >>> >>> >>> >>> >>> >>> >>> >>> Some things to check: >>> >>> Has your template *strictly *followed the csv template layout in the >>> documentation? >>> https://docs.dhis2.org/2.30/en/developer/html/webapi_csv_metadata_import.html#webapi_csv_org_units >>> >>> Is your .csv format the correct .csv format for DHIS2? (Some .csv in >>> francophone countries struggle as they use semi-colon) >>> >>> >>> >>> Hopefully something there is helpful. If not, it may be a bug but let’s >>> test those things first. >>> >>> It is also worth checking whether your import strategies are doing what >>> you expect. The default on the new system is different to the old. >>> Strategies are also found in the documentation - section 1.11 >>> >>> >>> >>> All best, >>> >>> Blake >>> >>> >>> >>> >>> >>> -- >>> >>> >>> >>> >>> >>> >>> *Blake Hansen* >>> Projects Implementation Manager, BAO Systems >>> >>> +1 202-536-1541 | bhan...@baosystems.com | http://www.baosystems.com | >>> >>> Skype: blake.a.hansen | 2900 K Street, Suite 507, Washington D.C. 20007 >>> >>> >>> >>> Register
