OK, so a time ago a tried to sync a version of openmrs 1.9.8 and failed.
I’ve been testing sync module 1.3 with that version and successfully achieved syncing. I grabbed an old version of my system on 1.9.8 and dumped the DB, installed the same DB on 2 different computers, set 1 as parent and the other as child, strangely both computer had same uuid in the sync config , modified 1 of the uuid manually. Set it up, cloned data from parent, and successfully syncd all fields that i believed critical.
Here’s the weird part, it all went smooth until the day after when I started both computers to do more through testing, both presented an error message, saying the sync module could not be started. When i went to see the error, this was what was displayed.
Error while trying to start module Error while running sql: INSERT INTO scheduler_task_config (name, description, schedulable_class, start_time, start_time_pattern, repeat_interval, start_on_startup, started, created_by, date_created, changed_by, date_changed, uuid) VALUES (‘Cleanup Old Sync Records’, ‘This task deletes old rows in the sync_record and sync_server_record tables. The default settings work on all servers, but for advanced users, you can change the properties to suit your needs.’, ‘org.openmrs.module.sync.scheduler.CleanupSyncTablesTask’, ‘2009-12-18 17:26:31’, ‘MM/dd/yyyy HH:mm:ss’, ‘604800’, ‘1’, ‘0’, ‘1’, ‘2009-12-18 17:28:39’, null, null, ‘d3122955-00d7-454c-b17f-e3f87206c74b’) . Message: Duplicate entry ‘d3122955-00d7-454c-b17f-e3f87206c74b’ for key ‘scheduler_task_config_uuid_index’
Any thoughts? Thank You.