Problem with tracker module

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@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

www.msh.org

Hi Randy,

Are you using a custom form by any chance?

Busoye

···

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@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

www.msh.org

No. Just the standard section form. We’re trying in version 2.17 because this has always worked before.

Randy

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.

···

On Tue, Mar 17, 2015 at 4:19 PM, Adebusoye Anifalaje busoye@hisp.org wrote:

Hi Randy,

Are you using a custom form by any chance?

Busoye

On 17 Mar 2015, at 14:15, Wilson, Randy rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

www.msh.org

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@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

Yes I’ve tried both interfaces… pretty much the same error in both cases.

Randy

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.

···

On Tue, Mar 17, 2015 at 4:26 PM, Abyot Gizaw abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

www.msh.org

Works fine when we recreated all the same attributes data elements and program/stages in 2.17… must be a bug in 2.18. We’ve also tried a very recent build (from last week)… and get the same error.

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.

···

On Tue, Mar 17, 2015 at 4:26 PM, Abyot Gizaw abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

www.msh.org

Dear Randy,
If you look at this line: ERROR 2015-03-17 16:08:42,650 ERROR: null value in column “registrationdate” violates not-null constraint,

the registrationdate can not be null, check that. Investigate around that.

Alex

···

On Tue, Mar 17, 2015 at 5:46 PM, Wilson, Randy rwilson@msh.org wrote:

Works fine when we recreated all the same attributes data elements and program/stages in 2.17… must be a bug in 2.18. We’ve also tried a very recent build (from last week)… and get the same error.

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

On Tue, Mar 17, 2015 at 4:26 PM, Abyot Gizaw abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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


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@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

www.msh.org

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 "

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@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

Using google chrome Version 40.0.2214.115 (64-bit) on linux mint.

···

On 18 March 2015 at 12:48, Bob Jolliffe bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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?

···

On Wed, Mar 18, 2015 at 1:48 PM, Bob Jolliffe bobjolliffe@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


Thank you,

Abyot.

On 17 March 2015 at 14:26, Abyot Gizaw abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

Abyot,

Here is what Randy provided:

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!!!

Looking at the build 18143, it dates back to 2015-01-29 which I think is an old build? I suggest that they first upgrade to the latest build and test.

Also in the DB structure, do we have a column called registrationdate?

Alex

···

On Wed, Mar 18, 2015 at 4:01 PM, Abyot Gizaw abyota@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?


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


Thank you,

Abyot.

On Wed, Mar 18, 2015 at 1:48 PM, Bob Jolliffe bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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 "

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@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 bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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


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

On 18 March 2015 at 13:01, Abyot Gizaw abyota@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 bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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 "

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.

···

On Wed, Mar 18, 2015 at 2:53 PM, Bob Jolliffe bobjolliffe@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


Thank you,

Abyot.

On 18 March 2015 at 13:01, Abyot Gizaw abyota@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 bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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@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 bobjolliffe@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 abyota@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 bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

Dear Abyot,

I agree to your suggestion.

Thanks.

Alex

···

On Wed, Mar 18, 2015 at 5:32 PM, Abyot Gizaw abyota@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.


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


Thank you,

Abyot.

On Wed, Mar 18, 2015 at 2:53 PM, Bob Jolliffe bobjolliffe@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 abyota@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 bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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 "

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?

···

On Wed, Mar 18, 2015 at 3:36 PM, Bob Jolliffe bobjolliffe@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.


Thank you,

Abyot.

On 18 March 2015 at 14:32, Abyot Gizaw abyota@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 bobjolliffe@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 abyota@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 bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

I think your db must be from an old version - less than 2.13

and in 2.14 we have introduced this script

http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/view/head:/resources/sql/convert-fixed-attributes-to-dynamic-postgres.sql

···

On Wed, Mar 18, 2015 at 3:38 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Abyot,

I agree to your suggestion.

Thanks.

Alex


Thank you,

Abyot.

On Wed, Mar 18, 2015 at 5:32 PM, Abyot Gizaw abyota@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.


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 "


Thank you,

Abyot.

On Wed, Mar 18, 2015 at 2:53 PM, Bob Jolliffe bobjolliffe@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 abyota@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 bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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@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 bobjolliffe@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 abyota@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 bobjolliffe@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 abyota@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 bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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

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.

···

On Wed, Mar 18, 2015 at 4:53 PM, Bob Jolliffe bobjolliffe@gmail.com 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@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 bobjolliffe@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 abyota@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 bobjolliffe@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 abyota@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 bobjolliffe@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 abyota@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” rwilson@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: rwilson@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

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

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@msh.org

Skype: wilsonrandy_us

Stronger health systems. Greater health impact.

www.msh.org