← Back to team overview

dhis2-users team mailing list archive

Re: Error Adding Data Elements

 

I might have been a bit quick there, I see no active in 2.17 either. Do you
have a column named active for data-element table?

--
Morten

On Thu, Feb 5, 2015 at 1:55 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx>
wrote:

> Hi
>
> The active column was removed from 2.18, so maybe there was an upgrade job
> that didn't work? could you try and remove that column? it shouldn't need
> to be there anymore
>
> --
> Morten
>
> On Thu, Feb 5, 2015 at 1:46 PM, Jason Phillips <jason@xxxxxxxx> wrote:
>
>> Hi all,
>>
>>
>>
>> We have an odd one:
>>
>> When trying to add a new Data Element, dhis 2.18 throws an exception in
>> the UI (“sorry, the system failed to…”) and the logs show a “null value in
>> column ‘active’” (Data Integrity Exception Violation) error.
>>
>> I get the meaning – for some reason the new DE doesn’t have a value for
>> ‘active’, which obviously cannot be null.  But what would cause this, and
>> more importantly, how do I fix it?
>>
>>
>>
>> Kind Regards,
>>
>> *Jason Phillips*
>>
>> [image: hisp]
>> *Software & Information Systems*
>>
>> *Health Information Systems Program*
>> -------------------------------------------------------------
>>
>> eMail:
>>
>> jason@xxxxxxxx
>>
>> Landline:
>>
>> +27 21 712 0170
>>
>> Mobile:
>>
>> +27 72 973 7250
>>
>> Skype:
>>
>> jason.n.phillips
>>
>>
>>
>>
>>
>>
>>
>> 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@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.
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

PNG image


Follow ups

References