I have the following in the database: '148', '3', '52', 'COMMITTED', '2', NULL '149', '1', '52', 'NEW', '0', NULL '150', '2', '52', 'NEW', '0', NULL
- adam On 03/14/2012 01:42 PM, Ben Wolfe wrote:
What about sync_server_record where record_id = 52 ? Ben On Tue, Mar 13, 2012 at 5:24 PM, Adam Thompson <[email protected] <mailto:[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]> <mailto:[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:[email protected]> <mailto:openmrs.erick@gmail.__com <mailto:[email protected]>> <mailto:openmrs.erick@gmail. <mailto:openmrs.erick@gmail.>____com <mailto:openmrs.erick@gmail.__com <mailto:[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]>> <mailto:[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:[email protected]> <mailto:openmrs.erick@gmail.__com <mailto:[email protected]>> <mailto:openmrs.erick@gmail. <mailto:openmrs.erick@gmail.>____com <mailto:openmrs.erick@gmail.__com <mailto:[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 <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. <mailto:LISTSERV@LISTSERV.>__IU__PUI.EDU <http://IUPUI.EDU> <mailto:LISTSERV@LISTSERV.__IUPUI.EDU <mailto:[email protected]>>?body=SIGNOFF%____20openmrs-implement-l> from OpenMRS Implementers' mailing list ------------------------------____----------------------------__--__------------ Click here to unsubscribe <mailto:LISTSERV@LISTSERV. <mailto:LISTSERV@LISTSERV.>__IU__PUI.EDU <http://IUPUI.EDU> <mailto:LISTSERV@LISTSERV.__IUPUI.EDU <mailto:[email protected]>>?body=SIGNOFF%____20openmrs-implement-l> from OpenMRS Implementers' mailing list ------------------------------____----------------------------__--__------------ Click here to unsubscribe <mailto:LISTSERV@LISTSERV. <mailto:LISTSERV@LISTSERV.>__IU__PUI.EDU <http://IUPUI.EDU> <mailto:LISTSERV@LISTSERV.__IUPUI.EDU <mailto:[email protected]>>?body=SIGNOFF%____20openmrs-implement-l> from OpenMRS Implementers' mailing list ------------------------------____----------------------------__--__------------ Click here to unsubscribe <mailto:LISTSERV@LISTSERV. <mailto:LISTSERV@LISTSERV.>__IU__PUI.EDU <http://IUPUI.EDU> <mailto:LISTSERV@LISTSERV.__IUPUI.EDU <mailto:[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> <tel:%2B234.%280%29809.515.__0590> h (us): +1.707.440.9904 <tel:%2B1.707.440.9904> <tel:%2B1.707.440.9904>, m (us): +1.831.212.8397 <tel:%2B1.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 <mailto:[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:[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]
