Odoo not synced after cleaning patient data

Tags: #<Tag:0x00007f0a297e16b8>

I am experiencing an issue on my machine, after cleaning up the patient data. Patients are not getting synced from Openmrs to Odoo. I know the solution to clean up the markers and then retry. But, I don’t want to use it because I have done some UI level changes, Once I clean the markers then all of those would be lost. So I don’t want to try cleaning up markers. If anyone in the community knows the other way around please reply here. Thanks in Advance!

Analyse the entries in the failed_events table. They can help you understand the sync failure reason

One of my colleagues solved the issue by

1)Logging into PSQL dB- psql -Uodoo odoo

2)Ran the following two queries on postgres DB:

delete from markers where feed_uri like '%feed/encounter/recent%' ;
delete from markers where feed_uri like '%feed/patient/recent%' ;

3)Similarly, now login to Mysql(OpenMRS) DB- MySQL -uroot -pP@ssw0rd

4)Ran the following query:

delete from markers where feed_uri like '%feed/encounter/recent%' ;

And then patient’s got synced.

1 Like

Good that you have reached the solution.

Deleting markers entry will not affect any UI changes made [As you mentioned in the thread]. It will only restart the sync.

For more understanding on the same/ or a similar approach, Kindly go through this wiki link.

https://bahmni.atlassian.net/wiki/spaces/BAH/pages/111411208/Troubleshooting+steps+for+ERP+sync

1 Like