Morten, That is the dilemma - how do we know those tables are irrelevant? And if they are - why doesn't the startup routines (tablealteror etc) remove them?
Regards Calle On Mon, 27 Aug 2018 at 13:12, Morten Olav Hansen <mor...@dhis2.org> wrote: > Hi Calle > > I'm not going to start digging down in the HBM history we have... but if > you see tables not relevant anymore, you can just delete them.. most of > this is not relevant anymore I'm sure > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > Team Integration Lead > University of Oslo > http://www.dhis2.org > > > On Sat, Aug 25, 2018 at 8:32 PM Calle Hedberg <calle.hedb...@gmail.com> > wrote: > >> Hi, >> >> Further to the list above, here are six additional tables we have in one >> instance that do not exist in the standard current 2.28 data model: >> >> *Query12* >> table_name >> importdatavalue >> importobject >> instanceconfig >> metadatafilter >> trackedentityattributegroup >> translation >> >> On Fri, 24 Aug 2018 at 13:48, Calle Hedberg <calle.hedb...@gmail.com> >> wrote: >> >>> Devs, >>> >>> While investigating the many duplicates and gaps found in many existing >>> 2.28 instances - most of them created in version 2.18 - 2.22 and then >>> upgraded over time - we also found a number of tables (and at least one >>> field) that no longer exist in a "clean" 2.28 instance. >>> >>> The single "missing" field is the field trackedentityattributeid in >>> table datadimensionitem. Is that field outdated? >>> >>> The tables are below - can somebody please indicate if these are >>> outdated tables no longer in use? (Jason P - note a number of them relate >>> to translations. You might know if they are redundant?) >>> >>> Regards >>> Calle >>> >>> table_name >>> >>> dependencysynchstatus >>> desynchstatus >>> desynchstatus >>> indicatorsynchstatus >>> indicatorsynchstatus >>> instance_businessrules >>> maplayertranslations >>> maplayertranslations >>> metadatafiltertranslations >>> metadatafiltertranslations >>> metadatasynchlog >>> organisationunitsynchstatus >>> organisationunitsynchstatus >>> predictororglevels >>> programinstance_outboundsms >>> programinstance_outboundsms >>> programstageinstance_outboundsms >>> programstageinstance_outboundsms >>> programvalidation >>> programvalidation >>> programvalidation >>> programvalidationtranslations >>> programvalidationtranslations >>> trackedentityattributegrouptranslations >>> trackedentityattributegrouptranslations >>> trackedentityaudit >>> trackedentityinstancereminder >>> trackedentityinstancereminder >>> trackedentityinstancereminder >>> trackedentityinstanceremindertranslations >>> trackedentityinstanceremindertranslations >>> validationrulegroupusergroupstoalert >>> validationrulegroupusergroupstoalert >>> validationrulesynchstatus >>> validationrulesynchstatus >>> >>> -- >>> >>> ******************************************* >>> >>> Calle Hedberg >>> >>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >>> >>> Tel/fax (home): +27-21-685-6472 >>> >>> Cell: +27-82-853-5352 >>> >>> Iridium SatPhone: +8816-315-19119 >>> >>> Email: calle.hedb...@gmail.com >>> >>> Skype: calle_hedberg >>> >>> ******************************************* >>> >>> >> >> -- >> >> ******************************************* >> >> Calle Hedberg >> >> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA >> >> Tel/fax (home): +27-21-685-6472 >> >> Cell: +27-82-853-5352 >> >> Iridium SatPhone: +8816-315-19119 >> >> Email: calle.hedb...@gmail.com >> >> Skype: calle_hedberg >> >> ******************************************* >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > -- ******************************************* Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: calle.hedb...@gmail.com Skype: calle_hedberg *******************************************
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp