dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #07517
Re: SQL query pointers requested
Do you see anything in the Tomcat log when you try to merge?
Knut
On Thu, Jun 18, 2015 at 3:43 PM, Ferdie Botha <ferdie@xxxxxxxx> wrote:
> Hi all, I need someone to point me in the right direction on the SQL
> backend, using DHIS2.18.
>
>
>
> I moved 2 orgunits from 1 parentid to another using the following 2 sql
> statements:
>
>
>
> update organisationunit set parentid = '14948' where organisationunitid =
> '632' ; -- re-link parentid to ls_ap_Additional Partners instead of
> District Partners
>
> update organisationunit set parentid = '14948' where organisationunitid =
> '633' ; -- re-link parentid to ls_ap_Additional Partners instead of
> District Partners
>
>
>
> Now I want to merge these 2 orgunits, but no luck. I tested the merging
> with 2 dummy units and this worked fine. Anything I can go check/verify to
> look for the cause of this?
>
>
>
> Thanks!
>
>
>
> *..*
>
>
>
> *Ferdie Botha*
>
>
>
>
>
> _______________________________________________
> 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
>
>
--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
Follow ups
References