dhis2-users team mailing list archive

[Ant Snyman <ant@xxxxxxxx>]

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




*Ant Snyman*

*Cell: 0824910449*

*Landline: 028 2713242*


Health Information Systems Program - SA

-- 


*This message and any attachments are subject to a disclaimer published

at http://www.hisp.org/policies.html#comms_disclaimer 
<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@xxxxxxxx 
<mailto:disclaimer@xxxxxxxx> 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.*