Bob,
May be the 'registrationdate' is from a dump from other versions? This may
have been retained in subsequent upgrades? or it is something referred to
in the tracker app.
If you have access, check the DB structure and ensure that there is no
column called registrationdate in any the referenced tables.
>From there, we can assess the tracker app.
Thanks.
Alex
On Wed, Mar 18, 2015 at 4:53 PM, Bob Jolliffe <bobjolli...@gmail.com> wrote:
> Hi Abyot
>
> The log shows what Randy initially reported:
>
> * ERROR 2015-03-18 14:19:55,836 ERROR: null value in column
> "registrationdate" v
> iolates not-null constraint
> Detail: Failing row contains (29412, null, null, null, null, null, null,
> null,
> null, 872, null, null, Ktl3NTLuGlK, null, 2015-03-18 14:19:55.805,
> 2015-03-18 1
> 4:19:55.805, null, 17032). (SqlExceptionHelper.java [tomcat-http-10])
>
> I am not sure about which instance randy has tested 2.18 on, but this is
> definitely 2.17. (I think he thought that this instance was also 2.18, but
> its not)
>
> According to the form the Enrollment date and Reporting date are required
> fields (see screenshot). Do you mean that they are simply ignored on
> initial registration?
>
> So where does the registration date come from? From the server date?
>
> Bob
>
>
> On 18 March 2015 at 13:01, Abyot Gizaw <aby...@gmail.com> 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 <bobjolli...@gmail.com>
>> 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 <aby...@gmail.com> 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" <rwil...@msh.org> 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: rwil...@msh.org
>>>>> 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@lists.launchpad.net
>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>> More help : https://help.launchpad.net/ListHelp
>>>>>
>>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-users@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> 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 "
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
