dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

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

*******************************************