Okay. Please let us know if these are orphans are coming back, and if you have a feel for which system operation they come from.
regards, Lars On Fri, Jun 10, 2016 at 6:35 PM, Blake Hansen <[email protected]> wrote: > Hi Lars, > > Many thanks. The delete worked without complaint and it seems these are > orphans. > > Regards, > -- > > > > *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 > > On 9 Jun 2016, at 18:48, Lars Helge Øverland <[email protected]> wrote: > > 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. >> >> <Screen Shot 2016-06-09 at 9.38.25 AM.png> >> >> Is that correct? Should I delete these manually via SQL? >> >> >> >> Many thanks, >> Blake >> >> >> -- >> >> <logo.png> >> >> *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/> > > > -- 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
