Dear DHIS2 community,
I have two DHIS2 databases, both WAR2.28 and both the same build (b1abb3a) but the datavalue table differs in the ordinal position of the columns within the table. Would this be an indication of an update script somewhere that did not run through properly? Is there a script available that we could use to fix this?
Regards
Ant Snyman
Below the table which seems to reflect an older format
column_name
ordinal_position
dataelementid
1
periodid
2
sourceid
3
categoryoptioncomboid
4
value
5
storedby
6
lastupdated
7
comment
8
followup
9
attributeoptioncomboid
10
created
11
deleted
12
Below the table that seems to be the more recent format
column_name
ordinal_position
dataelementid
1
periodid
2
sourceid
3
categoryoptioncomboid
4
attributeoptioncomboid
5
value
6
storedby
7
created
8
lastupdated
9
comment
10
followup
11
deleted
12
This message and any attachments are subject to a disclaimer published at http://www.hisp.org/policies.html#comms_disclaimer. Please read the disclaimer before opening any attachment or taking any other action in terms of this electronic transmission. If you cannot access the disclaimer, kindly send an email to disclaimer@hisp.org and a copy will be provided to you. By replying to this e-mail or opening any attachment you agree to be bound by the provisions of the disclaimer.
ยทยทยท
Ant Snyman
Cell: 0824910449
Landline: 028 2713242
Health Information Systems Program - SA