What about sync_server_record where record_id = 52 ? Ben
On Tue, Mar 13, 2012 at 5:24 PM, Adam Thompson <[email protected]>wrote: > Ben, > > Sorry 1st server that I set up to sync and used the maintenance backport > worked with out problems. Every other server I try to backport with the > same setting and copied from the exact same SQL fails with the error that I > sent. > > I've had issues with the ChangedBy not existing in one server of the > other. Could that be the problem here? > > Sync server record has the following: > > '52', '2', '29', 'NEW', '0', NULL > > Sync record has the following information: > > 52, 4132ef53-3111-4633-bc99-**3acc09a678cc, > 1d6dcbee-c8b5-11e0-983a-**00ff2c80bde4, > 1.8.3.24510, 2012-02-21 11:06:08, 0, NEW, <items><SyncItem > containedType="org.openmrs.**Person" > key="566dd18b-806b-4a64-9800-**25756f456488" > state="UPDATED"><content><![**CDATA[<org.openmrs.Person><**personChangedBy > type="org.openmrs.User">**1d6dcbee-c8b5-11e0-983a-** > 00ff2c80bde4</personChangedBy>**<patient > type="boolean">false</patient>**<personCreator > type="org.openmrs.User">**1d6dcbee-c8b5-11e0-983a-** > 00ff2c80bde4</personCreator><**personDateChanged type="timestamp">2012-02- > **21T11:06:07.550+0000</**personDateChanged><**personDateCreated > type="timestamp">2012-02-**21T11:06:07.242+0000</**personDateCreated><**birthdateEstimated > type="boolean">false</**birthdateEstimated><birthdate > type="timestamp">2012-02-**21T11:06:07.222+0000</**birthdate><gender > type="string">M</gender><**personVoided > type="boolean">false</**personVoided><uuid > type="string">566dd18b-806b-**4a64-9800-25756f456488</uuid><**dead > type="boolean">false</dead></**org.openmrs.Person>]]></**content></SyncItem><SyncItem > containedType="org.openmrs.**User" > key="6a96376c-0c45-4731-b1bc-**08c3d7c7b84a" > state="NEW"><content><![CDATA[**<org.openmrs.User><**userProperties > type="java.util.Map(org.**openmrs.User.userProperties)">**</userProperties><username > type="string">ehn11707b31</**username><person type="org.openmrs.Person">** > 566dd18b-806b-4a64-9800-**25756f456488</person><retired > type="boolean">false</retired>**<dateCreated type="timestamp">2012-02-** > 21T11:06:07.550+0000</**dateCreated><systemId type="string">IHVNKano_8-3</ > **systemId><uuid type="string">6a96376c-0c45-** > 4731-b1bc-08c3d7c7b84a</uuid><**creator type="org.openmrs.User">** > 1d6dcbee-c8b5-11e0-983a-**00ff2c80bde4</creator></org.** > openmrs.User>]]></content></**SyncItem><SyncItem > containedType="org.openmrs.**api.db.LoginCredential" > key="6a96376c-0c45-4731-b1bc-**08c3d7c7b84a" state="UPDATED"><content><![* > *CDATA[<org.openmrs.api.db.**LoginCredential><changedBy > type="org.openmrs.User">**1d6dcbee-c8b5-11e0-983a-**00ff2c80bde4</changedBy><uuid > type="string">6a96376c-0c45-**4731-b1bc-08c3d7c7b84a</uuid><**dateChanged > type="timestamp">2012-02-**21T11:06:08.031+0000</** > dateChanged></org.openmrs.api.**db.LoginCredential>]]></**content></SyncItem><SyncItem > containedType="org.hibernate.**collection.PersistentSet" > key="6a96376c-0c45-4731-b1bc-**08c3d7c7b84a|roles" > state="UPDATED"><content><![**CDATA[<org.hibernate.** > collection.PersistentSet><**owner action="recreate" properyName="roles" > type="org.openmrs.User" uuid="6a96376c-0c45-4731-b1bc-**08c3d7c7b84a"/><entry > action="update" primaryKey="System Developer" type="org.openmrs.Role" > uuid="8d94f852-c2cc-11de-8d13-**0010c6dffd0f"/></org.** > hibernate.collection.**PersistentSet>]]></content></**SyncItem></items>, > org.openmrs.Person,org.**openmrs.api.db.**LoginCredential,org.openmrs.**User, > 4132ef53-3111-4633-bc99-**3acc09a678cc > > > > > On 03/13/2012 05:55 PM, Ben Wolfe wrote: > >> What do you mean by "subsequent attempt". Are you trying again on the >> same server? Again on same server with different parameters? What >> happens if you try with same parameters again? >> >> Looks like it might be a problem with sync record 52. What is in >> sync_record and sync_server_record for that record id? >> >> Ben >> >> On Tue, Mar 13, 2012 at 12:16 PM, Adam Thompson <[email protected] >> <mailto:[email protected]>**> wrote: >> >> Hi Ben, >> >> I'm having another issue with sync as it relates to the Maintenance >> Feature. I'm trying to back port changes for several systems. The >> first system worked fine an all sync records were backported. Each >> subsequent attempt at backporting results in an >> org.hibernate.__**LazyInitializationException (see attached full >> trace). >> >> >> Any ideas about how I can resolve this issue? >> >> Thanks, adam >> >> >> >> On 03/13/2012 04:24 PM, Ben Wolfe wrote: >> >> I think you have to set up the ssl certificates in tomcat or >> java to get >> them to talk to each other over https. There used to be a wiki >> page >> that PIH wrote about it, but I can't find it now. >> >> Ben >> >> On Tue, Mar 13, 2012 at 10:59 AM, Erick Mugoma >> <[email protected] >> <mailto:openmrs.erick@gmail.**com<[email protected]> >> > >> <mailto:openmrs.erick@gmail.__**com >> >> <mailto:openmrs.erick@gmail.**com <[email protected]>>>> >> wrote: >> >> Hi Ben, >> Thanks very much for your response. >> >> One other issue is that we are not able to sync >> https/servername/openmrs parent server. It works very well with >> http/server name/openmrs server. >> >> Is it that it is not possible to sync thro' >> https/servername/openmrs >> server. Kindly advice me how to about this. >> >> Thanks >> >> >> On Mon, Mar 12, 2012 at 11:15 PM, Ben Wolfe <[email protected] >> <mailto:[email protected]> >> <mailto:[email protected] <mailto:[email protected]>>> wrote: >> >> Erick, looks like this was a bug introduced in 1.0. I >> opened >> this ticket and published a sync 1.0.1 for you today. >> >> https://tickets.openmrs.org/__**browse/SYNC-268<https://tickets.openmrs.org/__browse/SYNC-268> >> >> >> <https://tickets.openmrs.org/**browse/SYNC-268<https://tickets.openmrs.org/browse/SYNC-268> >> > >> >> The servers were still being created, it was just an >> error on >> the redirect. So if you returned to the Configuration >> screen >> you would see the new server in the list. >> >> Ben >> >> On Tue, Mar 6, 2012 at 11:10 AM, Erick Mugoma >> <[email protected] >> <mailto:openmrs.erick@gmail.**com<[email protected]> >> > >> <mailto:openmrs.erick@gmail.__**com >> >> <mailto:openmrs.erick@gmail.**com <[email protected]>>>> >> wrote: >> >> Hi >> Am trying to configure sync 1.0 on openmrs 1.8.3 and >> the >> following occurs every time you try to save >> anything. see >> the stack trace. >> >> >> An Internal Error has Occurred >> >> *java.lang.__**NullPointerException* >> >> Consult the help document >> >> <http://127.0.0.1:8080/__**openmrs/help.htm<http://127.0.0.1:8080/__openmrs/help.htm> >> >> >> <http://127.0.0.1:8080/**openmrs/help.htm<http://127.0.0.1:8080/openmrs/help.htm> >> >>. >> >> Contact your friendly neighborhood administrator if it >> cannot be resolved. >> >> Hide stack trace >> <http://127.0.0.1:8080/__**openmrs/module/sync/__** >> configServer.form#<http://127.0.0.1:8080/__openmrs/module/sync/__configServer.form#>< >> http://127.0.0.1:8080/**openmrs/module/sync/**configServer.form#<http://127.0.0.1:8080/openmrs/module/sync/configServer.form#> >> >> >> >> *org.openmrs.module.sync.web._**_controller.__** >> ConfigServerFormController.__**saveOrUpdateTask(__** >> ConfigServerFormController.__**java:392)* >> >> *org.openmrs.module.sync.web._**_controller.__** >> ConfigServerFormController.__**onSaveParent(__** >> ConfigServerFormController.__**java:260)* >> >> >> sun.reflect.__**NativeMethodAccessorImpl.__**invoke0(Native >> Method) >> >> sun.reflect.__**NativeMethodAccessorImpl.__**invoke(Unknown >> Source) >> >> sun.reflect.__**DelegatingMethodAccessorImpl._**_invoke(Unknown >> Source) >> java.lang.reflect.Method.__**invoke(Unknown Source) >> >> org.springframework.web.bind._**_annotation.support.__** >> HandlerMethodInvoker.__**invokeHandlerMethod(__** >> HandlerMethodInvoker.java:176) >> >> org.springframework.web.__**servlet.mvc.annotation.__** >> AnnotationMethodHandlerAdapter**__.invokeHandlerMethod(__** >> AnnotationMethodHandlerAdapter**__.java:426) >> >> org.springframework.web.__**servlet.mvc.annotation.__** >> AnnotationMethodHandlerAdapter**__.handle(__** >> AnnotationMethodHandlerAdapter**__.java:414) >> >> org.springframework.web.__**servlet.DispatcherServlet.__** >> doDispatch(DispatcherServlet._**_java:790) >> >> org.springframework.web.__**servlet.DispatcherServlet.__** >> doService(DispatcherServlet.__**java:719) >> >> org.springframework.web.__**servlet.FrameworkServlet.__** >> processRequest(__**FrameworkServlet.java:644) >> >> org.springframework.web.__**servlet.FrameworkServlet.__** >> doPost(FrameworkServlet.java:_**_560) >> >> javax.servlet.http.__**HttpServlet.service(__** >> HttpServlet.java:637) >> >> javax.servlet.http.__**HttpServlet.service(__** >> HttpServlet.java:717) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> internalDoFilter(__**ApplicationFilterChain.java:__**290) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> doFilter(__**ApplicationFilterChain.java:__**206) >> >> *org.openmrs.module.web.__**filter.__** >> ForcePasswordChangeFilter.__**doFilter(__**ForcePasswordChangeFilter.__** >> java:65)* >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> internalDoFilter(__**ApplicationFilterChain.java:__**235) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> doFilter(__**ApplicationFilterChain.java:__**206) >> >> *org.openmrs.module.web.__**filter.ModuleFilterChain.__** >> doFilter(ModuleFilterChain.__**java:76)* >> >> *org.openmrs.module.web.__**filter.ModuleFilter.doFilter(_** >> _ModuleFilter.java:58)* >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> internalDoFilter(__**ApplicationFilterChain.java:__**235) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> doFilter(__**ApplicationFilterChain.java:__**206) >> >> *org.openmrs.web.filter.__**OpenmrsFilter.__** >> doFilterInternal(__**OpenmrsFilter.java:112)* >> >> >> org.springframework.web.__**filter.OncePerRequestFilter.__** >> doFilter(OncePerRequestFilter.**__java:76) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> internalDoFilter(__**ApplicationFilterChain.java:__**235) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> doFilter(__**ApplicationFilterChain.java:__**206) >> >> org.springframework.orm.__**hibernate3.support.__** >> OpenSessionInViewFilter.__**doFilterInternal(__** >> OpenSessionInViewFilter.java:_**_198) >> >> org.springframework.web.__**filter.OncePerRequestFilter.__** >> doFilter(OncePerRequestFilter.**__java:76) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> internalDoFilter(__**ApplicationFilterChain.java:__**235) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> doFilter(__**ApplicationFilterChain.java:__**206) >> >> *org.openmrs.web.filter.__**StartupFilter.doFilter(__** >> StartupFilter.java:83)* >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> internalDoFilter(__**ApplicationFilterChain.java:__**235) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> doFilter(__**ApplicationFilterChain.java:__**206) >> >> *org.openmrs.web.filter.__**StartupFilter.doFilter(__** >> StartupFilter.java:83)* >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> internalDoFilter(__**ApplicationFilterChain.java:__**235) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> doFilter(__**ApplicationFilterChain.java:__**206) >> >> *org.openmrs.web.filter.__**StartupFilter.doFilter(__** >> StartupFilter.java:83)* >> >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> internalDoFilter(__**ApplicationFilterChain.java:__**235) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> doFilter(__**ApplicationFilterChain.java:__**206) >> >> org.springframework.web.__**filter.__** >> CharacterEncodingFilter.__**doFilterInternal(__** >> CharacterEncodingFilter.java:_**_88) >> >> org.springframework.web.__**filter.OncePerRequestFilter.__** >> doFilter(OncePerRequestFilter.**__java:76) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> internalDoFilter(__**ApplicationFilterChain.java:__**235) >> >> org.apache.catalina.core.__**ApplicationFilterChain.__** >> doFilter(__**ApplicationFilterChain.java:__**206) >> >> org.apache.catalina.core.__**StandardWrapperValve.invoke(__** >> StandardWrapperValve.java:233) >> >> org.apache.catalina.core.__**StandardContextValve.invoke(__** >> StandardContextValve.java:191) >> >> org.apache.catalina.core.__**StandardHostValve.invoke(__** >> StandardHostValve.java:127) >> >> org.apache.catalina.valves.__**ErrorReportValve.invoke(__** >> ErrorReportValve.java:102) >> >> org.apache.catalina.core.__**StandardEngineValve.invoke(__** >> StandardEngineValve.java:109) >> >> org.apache.catalina.connector.**__CoyoteAdapter.service(__** >> CoyoteAdapter.java:298) >> >> org.apache.coyote.http11.__**Http11Processor.process(__** >> Http11Processor.java:857) >> >> org.apache.coyote.http11.__**Http11Protocol$__** >> Http11ConnectionHandler.__**process(Http11Protocol.java:__**588) >> org.apache.tomcat.util.net >> >> <http://org.apache.tomcat.**util.net<http://org.apache.tomcat.util.net> >> >.__JIoEndpoint$**Worker.run(__JIoEndpoint.java:**489) >> >> java.lang.Thread.run(Unknown Source) >> >> >> OpenMRS Version: 1.8.3 Build 24510 >> >> >> ------------------------------**__----------------------------** >> --__------------ >> Click here to unsubscribe >> <mailto:LISTSERV@LISTSERV.__IU**PUI.EDU <http://IUPUI.EDU> >> <mailto:LISTSERV@LISTSERV.**IUPUI.EDU<[email protected]> >> >?body=SIGNOFF%__**20openmrs-implement-l> >> >> >> from OpenMRS Implementers' mailing list >> >> >> >> ------------------------------**__----------------------------** >> --__------------ >> Click here to unsubscribe >> <mailto:LISTSERV@LISTSERV.__IU**PUI.EDU <http://IUPUI.EDU> >> <mailto:LISTSERV@LISTSERV.**IUPUI.EDU<[email protected]> >> >?body=SIGNOFF%__**20openmrs-implement-l> >> >> >> from OpenMRS Implementers' mailing list >> >> >> >> ------------------------------**__----------------------------** >> --__------------ >> Click here to unsubscribe >> <mailto:LISTSERV@LISTSERV.__IU**PUI.EDU <http://IUPUI.EDU> >> <mailto:LISTSERV@LISTSERV.**IUPUI.EDU<[email protected]> >> >?body=SIGNOFF%__**20openmrs-implement-l> >> >> >> from OpenMRS Implementers' mailing list >> >> >> ------------------------------**__----------------------------** >> --__------------ >> Click here to unsubscribe >> <mailto:LISTSERV@LISTSERV.__IU**PUI.EDU <http://IUPUI.EDU> >> <mailto:LISTSERV@LISTSERV.**IUPUI.EDU<[email protected]> >> >?body=SIGNOFF%__**20openmrs-implement-l> >> >> >> from OpenMRS Implementers' mailing list >> >> >> -- >> Adam Thompson >> Director, eHealth & Information Systems Nigeria >> m (ng): +234.(0)809.515.0590 <tel:%2B234.%280%29809.515.**0590> >> h (us): +1.707.440.9904 <tel:%2B1.707.440.9904>, m (us): >> +1.831.212.8397 <tel:%2B1.831.212.8397> >> >> skype: adothompson >> http://ehealthnigeria.org/, http://infoactivist.net/ >> 25 Race Course Rd, Kano, Nigeria >> >> >> ------------------------------**------------------------------** >> ------------ >> Click here to unsubscribe >> <mailto:LISTSERV@LISTSERV.**IUPUI.EDU <[email protected]> >> ?body=SIGNOFF%**20openmrs-implement-l> >> from OpenMRS Implementers' mailing list >> > > -- > Adam Thompson > Director, eHealth & Information Systems Nigeria > m (ng): +234.(0)809.515.0590 > h (us): +1.707.440.9904, m (us): +1.831.212.8397 > skype: adothompson > http://ehealthnigeria.org/, http://infoactivist.net/ > 25 Race Course Rd, Kano, Nigeria > _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
