The table does look exactly like it has many static atteruibutes which
should have moved to dynamic, so probably some upgrade script was not
applied.
The rwanda implementation does have a fairly long vintage. I'll check that
old upgrade script and see if it fixes the problem. Thanks Abyot.
On 18 March 2015 at 14:45, Abyot Gizaw <aby...@gmail.com> wrote:
> we used to have that attribute. see the commit from Tran (Rev: 13239)
>
> That was supposed to be removed when migrating static to dynamic
> attributes ... this then leads to another bigger issue - have you made a
> proper upgrade?
>
>
> ---
> Thank you,
> Abyot.
>
> On Wed, Mar 18, 2015 at 3:36 PM, Bob Jolliffe <bobjolli...@gmail.com>
> wrote:
>
>> Hi Abyot
>>
>> Thanks for the explanation. That makes sense. So the second post is
>> never happening because the registration is not completed.
>>
>> Alex raises an interesting possibility. There is a column
>> called registrationdate on trackedentityinstance. Is this meant to be
>> there or could it be a hangover from an earlier version of the table?
>>
>> I guess randy can try with 2.18 but I have been testing on one of the
>> production servers so I can't really upgrade just to test this.
>>
>> On 18 March 2015 at 14:32, Abyot Gizaw <aby...@gmail.com> wrote:
>>
>>> It is a two step process... first registration is done meaning server
>>> returning uid, then using this uid another json is posted (this time the
>>> enrollment details are sent). What I think has happened is server failed to
>>> complete registration. Looking the log - do you have an attribute called
>>> registrationdate
>>> which is set mandatory?
>>>
>>> Also, can you make sure you are trying this in 2.18? of course you can
>>> continue with 2.17 but just saying that 2.18 is more stable. I just did a
>>> test on the demo server (which is 2.18) and it is working fine.
>>>
>>> One more thing... if you have made changes to your metadata once the
>>> tracker app has run - you need to clear cache to that the new meta-data is
>>> cached locally. We don't have a feature to auto-update local-cache.
>>>
>>>
>>> ---
>>> Thank you,
>>> Abyot.
>>>
>>> On Wed, Mar 18, 2015 at 2: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
