dhis2-users team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Dear Randy,
If you look at this line: ERROR 2015-03-17 16:08:42,650 ERROR: null value
in column "registrationdate" violates not-null constraint,
the  registrationdate can not be null, check that. Investigate around that.

Alex



On Tue, Mar 17, 2015 at 5:46 PM, Wilson, Randy <rwilson@xxxxxxx> wrote:

> Works fine when we recreated all the same attributes data elements and
> program/stages in 2.17.... must be a bug in 2.18.  We've also tried a very
> recent build (from last week)... and get the same error.
>
> On Tue, Mar 17, 2015 at 4:26 PM, Abyot Gizaw <abyota@xxxxxxxxx> wrote:
>
>> Hello Randy,
>>
>> Are you using the individual records module?
>>
>> Can you try tracker capture app?
>>
>> -----
>> Thank you,
>> Abyot.
>>
>> (sent from mobile)
>> On Mar 17, 2015 3:15 PM, "Wilson, Randy" <rwilson@xxxxxxx> wrote:
>>
>>> We're setting up a tracker module to capture data from individual
>>> community health workers using Multiple events with registration.
>>>
>>> We have the program and stage as well as attributes and data elements -
>>> using 3 different instances of DHIS-2.
>>>
>>> When we try to create a new instance we fill in the form, but when we
>>> click on Add, the screen freezes.  The instance is not saved so we can't
>>> enter any data.
>>>
>>> We are using version 2.18 build 18143
>>>
>>> Any guidance would be much appreciated.... we're stuck.
>>>
>>> Here is the log:
>>> * INFO  2015-03-17 16:08:42,610 'randy' create
>>> org.hisp.dhis.trackedentity.Track
>>> edEntityInstance, uid: S4SGPUtDl0o (AuditLogUtil.java
>>> [http-bio-8080-exec-6])
>>> * INFO  2015-03-17 16:08:42,650 'randy' update
>>> org.hisp.dhis.trackedentity.Track
>>> edEntityInstance, uid: S4SGPUtDl0o (AuditLogUtil.java
>>> [http-bio-8080-exec-6])
>>> * WARN  2015-03-17 16:08:42,650 SQL Error: 0, SQLState: 23502
>>> (SqlExceptionHelpe
>>> r.java [http-bio-8080-exec-6])
>>> * ERROR 2015-03-17 16:08:42,650 ERROR: null value in column
>>> "registrationdate" v
>>> iolates not-null constraint
>>>   Detail: Failing row contains (19556, null, null, null, null, null,
>>> null, null,
>>>  null, 872, null, null, S4SGPUtDl0o, null, 2015-03-17 16:08:42.61,
>>> 2015-03-17 16
>>> :08:42.61, null, 17032). (SqlExceptionHelper.java [http-bio-8080-exec-6])
>>> * ERROR 2015-03-17 16:08:42,660 HHH000352: Unable to release batch
>>> statement...
>>> (AbstractBatchImpl.java [http-bio-8080-exec-6])
>>> * ERROR 2015-03-17 16:08:42,670 HHH000246: SQLException escaped proxy
>>> (AbstractB
>>> atchImpl.java [http-bio-8080-exec-6])
>>> java.sql.SQLException: You can't operate on a closed Statement!!!
>>>
>>> --
>>> *Randy Wilson*
>>> *Team Leader: **Knowledge Management, Data Use and Research*
>>> Rwanda Health System Strengthening Activity
>>> Management Sciences for Health
>>> Rwanda-Kigali
>>> Direct: +250 788308835
>>> E-mail: rwilson@xxxxxxx
>>> Skype: wilsonrandy_us
>>>  <http://www.msh.org/>
>>> Stronger health systems. Greater health impact.
>>>  <https://www.facebook.com/ManagementSciencesForHealth>
>>> <https://twitter.com/MSHHealthImpact>
>>> <https://www.youtube.com/user/MSHHealthImpact>
>>> www.msh.org
>>>
>>> *This message and its attachments are confidential and solely for the
>>> intended recipients. If received in error, please delete them and notify
>>> the sender via reply e-mail immediately.*
>>> _______________________________________________
>>> 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
>>>
>>>
>
>
> --
> *Randy Wilson*
> *Team Leader: **Knowledge Management, Data Use and Research*
> Rwanda Health System Strengthening Activity
> Management Sciences for Health
> Rwanda-Kigali
> Direct: +250 788308835
> E-mail: rwilson@xxxxxxx
> Skype: wilsonrandy_us
>  <http://www.msh.org/>
> Stronger health systems. Greater health impact.
>  <https://www.facebook.com/ManagementSciencesForHealth>
> <https://twitter.com/MSHHealthImpact>
> <https://www.youtube.com/user/MSHHealthImpact>
> www.msh.org
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
>
> _______________________________________________
> 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
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems -
DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "