Also see https://wiki.openmrs.org/display/docs/Sync+Module+Technical+Overview for a description of the tables.
To add to Dave's questions: Did you set the "do not sync" objects to anything likw * or org.openmrs.* per chance? Ben On Mon, Apr 2, 2012 at 4:16 PM, Dave Thomas <[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]>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 >> > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from > OpenMRS Developers' mailing list _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
