dhis2-users team mailing list archive

[Abyot Gizaw <abyota@xxxxxxxxx>]

Let's hope for that ... but at the same time it not about removing a column
 - it is more than that and a bit complex.


---
Thank you,
Abyot.

On Wed, Mar 18, 2015 at 4:06 PM, Wilson, Randy <rwilson@xxxxxxx> wrote:

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