dhis2-users team mailing list archive

["Wilson, Randy" <rwilson@xxxxxxx>]

Thanks for the troubleshooting.  We'll try removing the extra static
columns on an offline instance and let you know.

I'm sure it will do the trick.

Randy

On Wed, Mar 18, 2015 at 4:53 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:

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


-- 
*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.*