dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

After the query, you must clear the DHIS2 cache.  Did you do this?

This operation could be more reliably done with the hierarchy operations,
followed by an organization unit merge (through the user interface).

Regards,
Jason

On Thu, Jun 18, 2015, 16:59 Knut Staring <knutst@xxxxxxxxx> wrote:

> 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
>  _______________________________________________
> 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
>