Hi Blake, could you please try to delete these dataelementoperands with SQL and see if you get any complaints from PostgreSQL constraints?
If not they are orphans - we need to look for places where these are not cleaned up. If you get complaints, please let us know from which constraints/tables. regards, Lars On Thu, Jun 9, 2016 at 6:53 PM, Blake Hansen <[email protected]> wrote: > Dear All, > > I’m trying to delete some Cat Combos. > > I went through the api and attempted a delete of the Cat Option Combos for > the Cat Combo and was returned an error saying the deletion couldn’t > proceed because of an association with the dataelementoperand table. > > So, I have several rows in dataelementoperand table preventing me from > deleting several catoptioncombos. Now, these rows seems to be orphans, > because they have no children in the following tables: > datadimensionitem, datasetoperands, sectiongreyedfields. > > > > Is that correct? Should I delete these manually via SQL? > > > > Many thanks, > Blake > > > -- > > > > *Blake Hansen* > DHIS 2 Analyst, BAO Systems > +1 202-536-1541 | [email protected] | http://www.baosystems.com | > Skype: blake.a.hansen | 2900 K Street, Suite 404, Washington D.C. 20007 > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland [email protected] http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
