dhis2-users team mailing list archive

["Ferdie Botha" <ferdie@xxxxxxxx>]

Hi there – 

 

Thanks for your responses. I’ll try to give the bigger picture being less cryptic …

 

A new instance of the db was created from the client’s Live (2.18) instance (now called ‘training’, running Tomcat 8 and Postgresql 9.4), and then upgraded to dhis2.19.

 

On this new instance -  

*        I ran the Maintenance function with options shown as attached;

*        I ran Analytics with it’s defaults as attached;

*        I went to the Merge functionality screen;

*        I made a copy of the catalina.out file;

*        I performed the merge as attached;

*        I then made a second copy of the catalina.out file and extracted the changes, also attached.

 

In the catalina.out file (attached file on line 7) I saw an error where the delete of the indicated orgunit was ‘prohibited’ “Delete was not allowed by ReportTableDeletionHandler” .

 

I’m unsure what this really means and how this can be resolved?

 

(If required, I can provide you a sql dump of the training instance – it is currently undergoing lots of changes and doesn’t have a lot of data in it).

 

Kind regards

 

Ferdie

 

From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx] 
Sent: 18 June 2015 05:24 PM
To: Knut Staring; Ferdie Botha
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] SQL query pointers requested

 

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 <mailto: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 <mailto: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 <mailto: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 <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> 
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Attachment: OrgunitMergeError.zip
Description: Zip compressed data