openmrs and odoo not synced on bahmni-standard ?

hi @dkayiwa @ibacher @apuda here pls can help i am facing issue to know how exactly openmrs and odoo sync in bahmni-standard docker compose . i have put my db configuration in openmrs db config setting in .env file.

if anybody knows pls comment.

Hello @sumitkapar. Share logs of your atomfeed-console

for 11.928) 2023-06-14 07:33:49.122 INFO 7 — [nio-9080-exec-1] o.a.c.c.C.[.[.[/atomfeed-console] : Initializing Spring FrameworkServlet ‘dispatcherServlet’ 2023-06-14 07:33:49.122 INFO 7 — [nio-9080-exec-1] o.s.web.servlet.DispatcherServlet : FrameworkServlet ‘dispatcherServlet’: initialization started 2023-06-14 07:33:49.137 INFO 7 — [nio-9080-exec-1] o.s.web.servlet.DispatcherServlet : FrameworkServlet ‘dispatcherServlet’: initialization completed in 15 ms 2023-06-14 07:33:52.196 INFO 7 — [nio-9080-exec-8] c.m.v.c.i.AbstractPoolBackedDataSource : Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → true, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → null, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName → 1br4368aw1f99b4dsr9r5p|4f695b2f, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → null, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, identityToken → 1br4368aw1f99b4dsr9r5p|4f695b2f, idleConnectionTestPeriod → 0, initialPoolSize → 3, jdbcUrl → jdbc:postgresql://odoodb/odoo, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 0, maxIdleTimeExcessConnections → 0, maxPoolSize → 15, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 3, numHelperThreads → 3, numThreadsAwaitingCheckoutDefaultUser → 0, preferredTestQuery → null, properties → {user=, password=}, propertyCycle → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, usesTraditionalReflectiveProxies → false ] 2023-06-14 07:34:00.430 INFO 7 — [io-9080-exec-10] c.m.v.c.i.AbstractPoolBackedDataSource : Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement → 3, acquireRetryAttempts → 30, acquireRetryDelay → 1000, autoCommitOnClose → true, automaticTestTable → null, breakAfterAcquireFailure → false, checkoutTimeout → 0, connectionCustomizerClassName → null, connectionTesterClassName → com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName → 1br4368aw1f99b4dsr9r5p|5f8607ab, debugUnreturnedConnectionStackTraces → false, description → null, driverClass → null, factoryClassLocation → null, forceIgnoreUnresolvedTransactions → false, identityToken → 1br4368aw1f99b4dsr9r5p|5f8607ab, idleConnectionTestPeriod → 0, initialPoolSize → 3, jdbcUrl → jdbc:mysql://our_host_internal_ip/my_database, maxAdministrativeTaskTime → 0, maxConnectionAge → 0, maxIdleTime → 0, maxIdleTimeExcessConnections → 0, maxPoolSize → 15, maxStatements → 0, maxStatementsPerConnection → 0, minPoolSize → 3, numHelperThreads → 3, numThreadsAwaitingCheckoutDefaultUser → 0, preferredTestQuery → null, properties → {user=, password=}, propertyCycle → 0, testConnectionOnCheckin → false, testConnectionOnCheckout → false, unreturnedConnectionTimeout → 0, usesTraditionalReflectiveProxies → false

this is the last information i got from the atomfeed-console container . if u find something pls provide some guidance

I can’t pick anything in the log. Also check your openmrs log for any errors relating to authentication between openmrs and Odoo.

Hi @tapologo @angshuonline ,

These are some logs coming into odoo 10 container -

2023-06-14 05:58:00,170 1 INFO odoo werkzeug: 13.233.27.182 - - [14/Jun/2023 05:58:00] "POST /xmlrpc/object HTTP/1.1" 200 -
2023-06-14 05:58:30,187 1 INFO odoo odoo.addons.bahmni_atom_feed.models.atom_event_worker: vals
2023-06-14 05:58:30,187 1 INFO odoo odoo.addons.bahmni_atom_feed.models.atom_event_worker: {'category': 'create.sale.order', 'locationName': 'AIIMS', 'feed_uri': 'http://backend.mini.io:8080/openmrs/ws/atomfeed/encounter/recent', 'orders': '{"id":"f19c1eda-789a-434f-92b1-c05ae183600e","openERPOrders":[{"orderId":"032f010c-d8c6-4aa3-8940-0a97f158cc43","previousOrderId":null,"encounterId":"f19c1eda-789a-434f-92b1-c05ae183600e","productId":"mini0000000000000000000000000003007712","productName":"CROCIN PAIN RELIEF","quantity":7.0,"quantityUnits":"Milligram","action":"NEW","visitId":"c0f34b63-b835-48ce-a768-3ad6e3d91da7","visitType":"OPD","type":"Drug Order","description":null,"voided":false,"locationName":null,"providerName":"Kartik Patel","dispensed":"false","conceptName":"8305a165-bbcf-11eb-8d47-02a85f324ec8"}]}', 'feed_uri_for_last_read_entry': 'http://miniopenmrs-env-vanillacore.ap-southeast-1.elasticbeanstalk.com:3000/openmrs/ws/atomfeed/encounter/recent', 'last_read_entry_id': 'tag:atomfeed.ict4h.org:d7dbd852-ed8c-4a37-9632-bbf1d30b025c', 'customer_id': 'NEW93725', 'encounter_id': 'f19c1eda-789a-434f-92b1-c05ae183600e'}
2023-06-14 05:58:30,189 1 INFO odoo odoo.addons.bahmni_atom_feed.models.atom_event_worker: 
 Processing event threw error: ('Patient Id not found in Odoo', '')