dhis2-users team mailing list archive

[Abyot Gizaw <abyota@xxxxxxxxx>]

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 <bobjolliffe@xxxxxxxxx> 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 <abyota@xxxxxxxxx> 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 <bobjolliffe@xxxxxxxxx>
>> 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 <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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>