← Back to team overview

dhis2-devs team mailing list archive

Re: DHIS2 tables of unknown origin/purpose

 

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

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

Follow ups

References