Erick- Hmm... it is hard to figure out exactly what the situation is here.
Do you have access to the log file on the parent server? If so, can you take a look at it? Specifically, try updating/saving some data, and see if an error shows up in the logs. You said that you were able to confirm that records on the child servers were being synced properly to the parent server, correct? Take care, Mark From: Erick Mugoma [mailto:[email protected]] Sent: Tuesday, April 03, 2012 1:08 AM To: Dave Thomas; Mark Goodrich; [email protected] Subject: Re: SYNC Module Question Hi Dave, I believe my configuration is ok. Am able to see all the child servers. What I don't understand is why the parent server is no Longer marking the records for sync and inserting them in the sync_server_record table?. By the way everything was working fine till 28-03-12. I can't tell what happened that stalled the sync process on the parent. How do we ensure that the records are being inserted in the sync_server_record table. I suspect that this is where we are having trouble? Thanks Erick On Mon, Apr 2, 2012 at 11:16 PM, Dave Thomas <[email protected]<mailto:[email protected]>> wrote: Hi. If you're not seeing any new records in sync_server_record on the parent, you're in trouble. This is the table that is used to keep track of what records have propagated to what child servers. Without rows being inserted into this table, no data will ever propagate to the children. In your sync overview page on the parent, can you actually see the child servers, and are they configured correctly? Did you change the server uuids at all, either on the children or on the parent? On the parent, the state field in the sync_record table isn't important. Its the state field in the sync_server_record that governs propagation. d On Mon, Apr 2, 2012 at 8:05 AM, Erick Mugoma <[email protected]<mailto:[email protected]>> wrote: Hi Ben and Mark Am just wondering what may or may not be happening with the sync_server_record and sync_record tables on the central/parent server. Plse help me understand something, I expect that every time a new record is created on the parent, the record details are logged to the above tables and you can even use these tables to track if the record was committed, sent, new or failed. Why is it that when I do a query to check if there any records in the sync_server_record table I can't see any record for example I should be able to see today's records (02-04-12) since the clean -up was last done on 31 march 2012. Any I deas on what is not Happenning? On the parent sync_record table, the state field is not being updated. The state column value is 'NEW' for all the records. I expect that the state should change once the record is committed to all the children. Any reason why this is not so? When I look at the same table on the child servers, the state column value is 'COMMITTED' Looking at the History Changes on the UI What I see are old changes like last updated is 28-03-2012. That is last week wed when we have new records being entered even today (02-04-12) and should be able to see them under history changes. Any Explanation why I can't see the newest/latest updates. Thanks Erick _________________________________________ 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]
