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?)
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
Sorry, I meant to say how do we know ALL of those tables are not relevant any more? I agree with you that they most likely are, but it is preferable to know for sure (and actually that such tables are automatically removed)
I think the reason they have not been automatically removed is exactly that… they might have been retired, but we don’t want to remove just in case you have something there of value… regarding all the tables, I don’t recognize all of them myself… but translation has been replaced by other tables, metadatafilter is not in use anymore, the rest like importobject… I’m not sure if i have ever seen actually…