dhis2-users team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Abyot,

Here is what Randy provided:
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!!!



Looking at the build 18143, it dates back to 2015-01-29 which I think is an
old build? I suggest that they first upgrade to the latest build and test.

Also in the DB structure, do we have a column called registrationdate?

Alex

On Wed, Mar 18, 2015 at 4:01 PM, Abyot Gizaw <abyota@xxxxxxxxx> wrote:

> Hi Bob,
>
> That is just for registration ... then enrollment follows with enrollment
> and incident dates. Most probably something has failed in between - is
> there any log?
>
>
> ---
> Thank you,
> Abyot.
>
> On Wed, Mar 18, 2015 at 1:48 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>
> wrote:
>
>> Hi Abyot
>>
>> I just had a quick look at the tracker app on one of the Rwanda dhis2
>> instances (it is running 2.17 built on  2015-01-21 02:05 - strange I
>> don't see the build revision)
>>
>> The form has some attributes and the Enrollment date and Reporting date
>> at the bottom.  When I try to save I see that the following is POSTed.
>>
>>
>> {"trackedEntity":"BQu4uXKyrRE","orgUnit":"BPZcHDS6OO0","attributes":[{"attribute":"xyp3l9obelI","value":55654},{"attribute":"ul7UIuUoP1Z","value":"5654"},{"attribute":"rOwntnIQh2P","value":"56546"},{"attribute":"QnwIsiKw2NF","value":"5654"},{"attribute":"SZ05eUTBMEN","value":"6546"},{"attribute":"tNGC3SeoHbb","value":"5656"},{"attribute":"FQGMFSwKUkB","value":56546},{"attribute":"VsUAhCcttyf","value":"56546"}]}
>>
>> Note there are no dates in this even though they were entered on the
>> form.  This seems wrong,  I guess this is what causes the sql to fail.
>>
>> Regards
>> Bob
>>
>> On 17 March 2015 at 14:26, 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
>>>>
>>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>
> _______________________________________________
> 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 "