Re: [Dhis2-users] Deleting old data elements
Hi Jose, If you try deleting those elements from PGAdmin, the error message will include the object/table to which the data element is associated. You should then delete that association and try deleting the data element again. You could also follow what is happening in your tomcat window when you press delete. This will also let you know the data element cannot be deleted because it is referenced in another table like an org unit group. Hope this helps. Regards Busoye On 28 Aug 2013, at 00:41, Jose Garcia Muñoz josem...@gmail.com wrote: Dear all, I am trying to delete some old dataelements. Previously I have deleted, using SQL delete sentences, all datavalues associated to them. Everything goes well, but still some data elements don't want to disappear. I mean, when I click on the Remove button (web interface): 1) Some times appear the message Deleting , but nothing really happens. or 2) Other times appear the following message: Object not deleted because it is associated by object of type Any ideas about 1) or 2)? I am using DHIS 2.12 and postgresql Thanks! Jose ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] How to Track a Patient across multiple org units for the same program
Hi all, Not sure how the patient tracker handles patient registration in a program that cuts across multiple orgunits. This is a scenario: - Patient is admitted into a ward (e.g medical). a) This is where the patient details are registered and enrolled into the midnight census program -Admissions is the first stage of the program b) Patient stays x number of nights in this ward c) Patient is then separated e.g. transferred internally… - Separation is the second event (program stage) - Inpatient days can be calculated by ward - If patient is transferred to another speciality within the same ward the event is just repeated i.e. admissions and separation… - However, if the transfer is to a different ward, we have to choose a different org unit. At this stage, the patient is already registered so we don't want to have to register the patient again. We would want to a) Choose new org unit b) Find patient details b) Enrol into the same program - Maybe I just don't understand the patient module enough but at the moment it seems like you can't track the same patient across multiple orgunits for the same program… Would appreciate if anyone can throw some light on how to do this. Kind regards, Busoye ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
[Dhis2-users] Error with Validation Group: DHIS2.12 build 11290
Dear all, We receive an error message when trying to add a validation rule to a group. I noticed that during start up, there is an error message: * ERROR 2013-08-28 12:24:32,468 HHH000388: Unsuccessful: alter table validationrulegroupmembers add constraint fk_validationrulegroupmembers_validatio nrulegroupid foreign key (validationgroupid) references validationrulegroup (SchemaUpdate.java [pool-2-thread-1]) * ERROR 2013-08-28 12:24:32,468 ERROR: constraint fk_validationrulegroupmembers_validationrulegroupid for relation validationrulegroupmembers already exists (SchemaUpdate.java [pool-2-thread-1]) The error message during the operation is: * ERROR 2013-08-28 12:25:53,515 ERROR: null value in column validationgroupid violates not-null constraint Detail: Failing row contains (null, null, null, null, null, palidusime, , 2562). (SqlExceptionHelper.java [http-apr-8080-exec-5]) * ERROR 2013-08-28 12:25:53,531 Error while executing action (ExceptionInterceptor.java [http-apr-8080-exec-5]) org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [validationgroupid]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement Caused by: org.postgresql.util.PSQLException: ERROR: null value in column validationgroupid violates not-null constraint Detail: Failing row contains (null, null, null, null, null, palidusime, , 2562). I am using DHIS2.12 build 11290 Does anyone know what's happening here? Thanks Busoye ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Error with Validation Group: DHIS2.12 build 11290
Did you upgrade from 2.11 to 2.12? JM El 28/08/2013, a las 05:42, Adebusoye Anifalaje bus...@hisp.org escribió: Dear all, We receive an error message when trying to add a validation rule to a group. I noticed that during start up, there is an error message: * ERROR 2013-08-28 12:24:32,468 HHH000388: Unsuccessful: alter table validationrulegroupmembers add constraint fk_validationrulegroupmembers_validatio nrulegroupid foreign key (validationgroupid) references validationrulegroup (SchemaUpdate.java [pool-2-thread-1]) * ERROR 2013-08-28 12:24:32,468 ERROR: constraint fk_validationrulegroupmembers_validationrulegroupid for relation validationrulegroupmembers already exists (SchemaUpdate.java [pool-2-thread-1]) The error message during the operation is: * ERROR 2013-08-28 12:25:53,515 ERROR: null value in column validationgroupid violates not-null constraint Detail: Failing row contains (null, null, null, null, null, palidusime, , 2562). (SqlExceptionHelper.java [http-apr-8080-exec-5]) * ERROR 2013-08-28 12:25:53,531 Error while executing action (ExceptionInterceptor.java [http-apr-8080-exec-5]) org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [validationgroupid]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement Caused by: org.postgresql.util.PSQLException: ERROR: null value in column validationgroupid violates not-null constraint Detail: Failing row contains (null, null, null, null, null, palidusime, , 2562). I am using DHIS2.12 build 11290 Does anyone know what's happening here? Thanks Busoye ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] How to Track a Patient across multiple org units for the same program
Hi Busoye, If provided the authority to do so the user at the second facility can search and find the person and open the person dashboard. There the user can continue endring data for new stages in the same enrollment or enroll into the program again (if the previous enrolment was completed). By authority I refer to the authorities you can assign to user roles in DHIS 2. On the phone now and can't look up the exact name of this authority, but think it's called something like 'Search Persons in all facilities'. There is also a 'Search Person in User facilities' that limit the search to the subtree of the orgunit hierarchy the user can see (has been assigned), if e.g the user is located at a district office supporting multiple facilities or I guess at a hospital supporting multiple words. Being able to track individuals over time AND across facilities (orgunits) is supported and one of the key use cases for Tracker. Ola -- On 28 Aug 2013 09:51, Adebusoye Anifalaje bus...@hisp.org wrote: Hi all, Not sure how the patient tracker handles patient registration in a program that cuts across multiple orgunits. This is a scenario: - Patient is admitted into a ward (e.g medical). a) This is where the patient details are registered and enrolled into the midnight census program -Admissions is the first stage of the program b) Patient stays x number of nights in this ward c) Patient is then separated e.g. transferred internally… - Separation is the second event (program stage) - Inpatient days can be calculated by ward - If patient is transferred to another speciality within the same ward the event is just repeated i.e. admissions and separation… - However, if the transfer is to a different ward, we have to choose a different org unit. At this stage, the patient is already registered so we don't want to have to register the patient again. We would want to a) Choose new org unit b) Find patient details b) Enrol into the same program - Maybe I just don't understand the patient module enough but at the moment it seems like you can't *track the same patient across multiple orgunits for the same program*… Would appreciate if anyone can throw some light on how to do this. Kind regards, Busoye ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] How to Track a Patient across multiple org units for the same program
Hi Ola, This is most useful. We have been testing with a single superuser login and the same user trying to register the same patient across orgunits. We will try your suggestion with a couple of users profiles. Thanks a bunch. Regards, Busoye On 28 Aug 2013, at 17:25, Ola Hodne Titlestad ol...@ifi.uio.no wrote: Hi Busoye, If provided the authority to do so the user at the second facility can search and find the person and open the person dashboard. There the user can continue endring data for new stages in the same enrollment or enroll into the program again (if the previous enrolment was completed). By authority I refer to the authorities you can assign to user roles in DHIS 2. On the phone now and can't look up the exact name of this authority, but think it's called something like 'Search Persons in all facilities'. There is also a 'Search Person in User facilities' that limit the search to the subtree of the orgunit hierarchy the user can see (has been assigned), if e.g the user is located at a district office supporting multiple facilities or I guess at a hospital supporting multiple words. Being able to track individuals over time AND across facilities (orgunits) is supported and one of the key use cases for Tracker. Ola -- On 28 Aug 2013 09:51, Adebusoye Anifalaje bus...@hisp.org wrote: Hi all, Not sure how the patient tracker handles patient registration in a program that cuts across multiple orgunits. This is a scenario: - Patient is admitted into a ward (e.g medical). a) This is where the patient details are registered and enrolled into the midnight census program -Admissions is the first stage of the program b) Patient stays x number of nights in this ward c) Patient is then separated e.g. transferred internally… - Separation is the second event (program stage) - Inpatient days can be calculated by ward - If patient is transferred to another speciality within the same ward the event is just repeated i.e. admissions and separation… - However, if the transfer is to a different ward, we have to choose a different org unit. At this stage, the patient is already registered so we don't want to have to register the patient again. We would want to a) Choose new org unit b) Find patient details b) Enrol into the same program - Maybe I just don't understand the patient module enough but at the moment it seems like you can't track the same patient across multiple orgunits for the same program… Would appreciate if anyone can throw some light on how to do this. Kind regards, Busoye ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Error with Validation Group: DHIS2.12 build 11290
Hi Juan, I didn't upgrade from 2:11. The file was converted from DHIS1.4 Busoye On 28 Aug 2013, at 15:15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com wrote: Did you upgrade from 2.11 to 2.12? JM El 28/08/2013, a las 05:42, Adebusoye Anifalaje bus...@hisp.org escribió: Dear all, We receive an error message when trying to add a validation rule to a group. I noticed that during start up, there is an error message: * ERROR 2013-08-28 12:24:32,468 HHH000388: Unsuccessful: alter table validationrulegroupmembers add constraint fk_validationrulegroupmembers_validatio nrulegroupid foreign key (validationgroupid) references validationrulegroup (SchemaUpdate.java [pool-2-thread-1]) * ERROR 2013-08-28 12:24:32,468 ERROR: constraint fk_validationrulegroupmembers_validationrulegroupid for relation validationrulegroupmembers already exists (SchemaUpdate.java [pool-2-thread-1]) The error message during the operation is: * ERROR 2013-08-28 12:25:53,515 ERROR: null value in column validationgroupid violates not-null constraint Detail: Failing row contains (null, null, null, null, null, palidusime, , 2562). (SqlExceptionHelper.java [http-apr-8080-exec-5]) * ERROR 2013-08-28 12:25:53,531 Error while executing action (ExceptionInterceptor.java [http-apr-8080-exec-5]) org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [validationgroupid]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement Caused by: org.postgresql.util.PSQLException: ERROR: null value in column validationgroupid violates not-null constraint Detail: Failing row contains (null, null, null, null, null, palidusime, , 2562). I am using DHIS2.12 build 11290 Does anyone know what's happening here? Thanks Busoye ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-users] [Dhis2-devs] Error with Validation Group: DHIS2.12 build 11290
I had the same problem upgrading from 2.11 to 2.12 and found a work around, you need to have at least one validation rule group before doing the upgrade. Regards, JM El 28/08/2013, a las 12:13, Adebusoye Anifalaje bus...@hisp.org escribió: Hi Juan, I didn't upgrade from 2:11. The file was converted from DHIS1.4 Busoye On 28 Aug 2013, at 15:15, Juan Manuel Alcantara Acosta jmalcanta...@gmail.com wrote: Did you upgrade from 2.11 to 2.12? JM El 28/08/2013, a las 05:42, Adebusoye Anifalaje bus...@hisp.org escribió: Dear all, We receive an error message when trying to add a validation rule to a group. I noticed that during start up, there is an error message: * ERROR 2013-08-28 12:24:32,468 HHH000388: Unsuccessful: alter table validationrulegroupmembers add constraint fk_validationrulegroupmembers_validatio nrulegroupid foreign key (validationgroupid) references validationrulegroup (SchemaUpdate.java [pool-2-thread-1]) * ERROR 2013-08-28 12:24:32,468 ERROR: constraint fk_validationrulegroupmembers_validationrulegroupid for relation validationrulegroupmembers already exists (SchemaUpdate.java [pool-2-thread-1]) The error message during the operation is: * ERROR 2013-08-28 12:25:53,515 ERROR: null value in column validationgroupid violates not-null constraint Detail: Failing row contains (null, null, null, null, null, palidusime, , 2562). (SqlExceptionHelper.java [http-apr-8080-exec-5]) * ERROR 2013-08-28 12:25:53,531 Error while executing action (ExceptionInterceptor.java [http-apr-8080-exec-5]) org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [validationgroupid]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement Caused by: org.postgresql.util.PSQLException: ERROR: null value in column validationgroupid violates not-null constraint Detail: Failing row contains (null, null, null, null, null, palidusime, , 2562). I am using DHIS2.12 build 11290 Does anyone know what's happening here? Thanks Busoye ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-d...@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp