dhis2-devs team mailing list archive

[Morten Olav Hansen <morten@xxxxxxxxx>]

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..

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
Team Integration Lead
University of Oslo
http://www.dhis2.org


On Mon, Aug 27, 2018 at 6:29 PM Calle Hedberg <calle.hedberg@xxxxxxxxx>
wrote:

> Morten,
>
> 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)
>
> Regards
> calle
>
> On Mon, 27 Aug 2018 at 13:27, Calle Hedberg <calle.hedberg@xxxxxxxxx>
> wrote:
>
>> 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 <morten@xxxxxxxxx>
>> 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.hedberg@xxxxxxxxx>
>>> 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.hedberg@xxxxxxxxx>
>>>> 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.hedberg@xxxxxxxxx
>>>>>
>>>>> 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.hedberg@xxxxxxxxx
>>>>
>>>> Skype: calle_hedberg
>>>>
>>>> *******************************************
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> 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.hedberg@xxxxxxxxx
>>
>> 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.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>