dhis2-users team mailing list archive

["Jason Phillips" <jason@xxxxxxxx>]

Hi Morten,

 

Just verified in a copy: a DROP CASCADE of the field solved the issue.

Thanks again!

 

Kind regards,

Jason.

 

From: Dhis2-users [mailto:dhis2-users-bounces+jason=hisp.org@xxxxxxxxxxxxxxxxxxx] On Behalf Of Jason Phillips
Sent: 05 February 2015 09:22 AM
To: 'Morten Olav Hansen'
Cc: 'DHIS 2 Users List'
Subject: Re: [Dhis2-users] Error Adding Data Elements

 

Hi Morten,

 

Yup - active there.  I am assuming it should not be; I knew “active” was removed from OrgUnits, and assume it was also removed from other tables…?

 

Many thanks!

Jason

 

From: Morten Olav Hansen [mailto:mortenoh@xxxxxxxxx] 
Sent: 05 February 2015 08:58 AM
To: Jason Phillips
Cc: DHIS 2 Users List
Subject: Re: [Dhis2-users] 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

hisp
Software & Information Systems
Health Information Systems Program
-------------------------------------------------------------



eMail:

 <mailto:jason@xxxxxxxx> jason@xxxxxxxx


Landline:

+27 21 712 0170 <tel:%2B27%2021%20712%200170> 


Mobile:

+27 72 973 7250 <tel:%2B27%2072%20973%207250> 


Skype:

jason.n.phillips

  

 

 

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  <mailto:disclaimer@xxxxxxxx> 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