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 <rwil...@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. > > On Tue, Mar 17, 2015 at 4:26 PM, Abyot Gizaw <aby...@gmail.com> wrote: > >> Hello Randy, >> >> Are you using the individual records module? >> >> Can you try tracker capture app? >> >> ----- >> Thank you, >> Abyot. >> >> (sent from mobile) >> On Mar 17, 2015 3:15 PM, "Wilson, Randy" <rwil...@msh.org> wrote: >> >>> We're setting up a tracker module to capture data from individual >>> community health workers using Multiple events with registration. >>> >>> We have the program and stage as well as attributes and data elements - >>> using 3 different instances of DHIS-2. >>> >>> When we try to create a new instance we fill in the form, but when we >>> click on Add, the screen freezes. The instance is not saved so we can't >>> enter any data. >>> >>> We are using version 2.18 build 18143 >>> >>> Any guidance would be much appreciated.... we're stuck. >>> >>> Here is the log: >>> * INFO 2015-03-17 16:08:42,610 'randy' create >>> org.hisp.dhis.trackedentity.Track >>> edEntityInstance, uid: S4SGPUtDl0o (AuditLogUtil.java >>> [http-bio-8080-exec-6]) >>> * INFO 2015-03-17 16:08:42,650 'randy' update >>> org.hisp.dhis.trackedentity.Track >>> edEntityInstance, uid: S4SGPUtDl0o (AuditLogUtil.java >>> [http-bio-8080-exec-6]) >>> * WARN 2015-03-17 16:08:42,650 SQL Error: 0, SQLState: 23502 >>> (SqlExceptionHelpe >>> r.java [http-bio-8080-exec-6]) >>> * ERROR 2015-03-17 16:08:42,650 ERROR: null value in column >>> "registrationdate" v >>> iolates not-null constraint >>> Detail: Failing row contains (19556, null, null, null, null, null, >>> null, null, >>> null, 872, null, null, S4SGPUtDl0o, null, 2015-03-17 16:08:42.61, >>> 2015-03-17 16 >>> :08:42.61, null, 17032). (SqlExceptionHelper.java [http-bio-8080-exec-6]) >>> * ERROR 2015-03-17 16:08:42,660 HHH000352: Unable to release batch >>> statement... >>> (AbstractBatchImpl.java [http-bio-8080-exec-6]) >>> * ERROR 2015-03-17 16:08:42,670 HHH000246: SQLException escaped proxy >>> (AbstractB >>> atchImpl.java [http-bio-8080-exec-6]) >>> java.sql.SQLException: You can't operate on a closed Statement!!! >>> >>> -- >>> *Randy Wilson* >>> *Team Leader: **Knowledge Management, Data Use and Research* >>> Rwanda Health System Strengthening Activity >>> Management Sciences for Health >>> Rwanda-Kigali >>> Direct: +250 788308835 >>> E-mail: rwil...@msh.org >>> Skype: wilsonrandy_us >>> <http://www.msh.org/> >>> Stronger health systems. Greater health impact. >>> <https://www.facebook.com/ManagementSciencesForHealth> >>> <https://twitter.com/MSHHealthImpact> >>> <https://www.youtube.com/user/MSHHealthImpact> >>> www.msh.org >>> >>> *This message and its attachments are confidential and solely for the >>> intended recipients. If received in error, please delete them and notify >>> the sender via reply e-mail immediately.* >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-users@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-users >>> More help : https://help.launchpad.net/ListHelp >>> >>> > > > -- > *Randy Wilson* > *Team Leader: **Knowledge Management, Data Use and Research* > Rwanda Health System Strengthening Activity > Management Sciences for Health > Rwanda-Kigali > Direct: +250 788308835 > E-mail: rwil...@msh.org > Skype: wilsonrandy_us > <http://www.msh.org/> > Stronger health systems. Greater health impact. > <https://www.facebook.com/ManagementSciencesForHealth> > <https://twitter.com/MSHHealthImpact> > <https://www.youtube.com/user/MSHHealthImpact> > www.msh.org > > *This message and its attachments are confidential and solely for the > intended recipients. If received in error, please delete them and notify > the sender via reply e-mail immediately.* > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- 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 "
_______________________________________________ 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
