dhis2-users team mailing list archive

["Ferdie Botha" <ferdie@xxxxxxxx>]

Thanks Jason! I’ll confirm when I could get this done. (Hopefully today still). Should I report this as a bug?

 

From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx] 
Sent: 01 July 2015 08:51 AM
To: Ferdie Botha; Knut Staring
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] SQL query pointers requested

 

Hi Ferdie,

 

This is a bit of a  pain. There is a table "reporttable_organisationunit" which is causing this error.  The deletion handler refuses to mess with this table.   I am not sure why this is the case. Maybe the devs can answer. 

You will need to manually delete the offending organisation unit from reporttable_organisationunit, but you must be careful here,  as this table represents a Java list. If you delete the organisation unit from the table, the list will have an empty member in the list, and will result in a null pointer exception when executing the report. So, you must reorder everything as part of deleting the organisation unit. You can accomplish this with a query like 

 

update reporttable_organisationunits set sort_order = -t.i

from (select row_number() over (ORDER BY sort_order) as i, reporttableid, sort_order, organisationunitid

    from reporttable_organisationunits where reporttableid=A order by sort_order) t

where reporttable_organisationunits.organisationunitid = t.organisationunitid and reporttable_organisationunits.reporttableid=A;

 

 

where "A" is the report table ID which you need to fix. 

 

 

As I said, this is a bit of a pain, but should work. 

 

Regards,

Jason

 

 

 

On Tue, Jun 30, 2015, 15:14 Ferdie Botha <ferdie@xxxxxxxx <mailto:ferdie@xxxxxxxx> > wrote:

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 <mailto:jason.p.pickering@xxxxxxxxx> ] 
Sent: 18 June 2015 05:24 PM
To: Knut Staring; Ferdie Botha
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto: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 <tel:%2B4791880522> 

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