Results of OpenElis test in Bahmni

Hi @openmsf, Can you please look at the entries in failed_events tables and see if there are any and check the exceptions.

HI Manuel,

Can you please check If the Sample source location in elis and the login location from the bahmni is same???

If it is same then the sync from elis to openmrs(bahmni) happens and you can see the ordered tests in patient dashboard.If the sample source location and Login location is different then the sync wont happen. Please check this and let us know if the issue still exists.

Yep, itā€™s the same location but we donā€™t see the results (we can see the tests in the dashboard though)

The contents of table failed_events in OpenELIS DB

id | feed_uri | error_message | event_id | event_content | failed_at | error_hash_code | title | retries | tags -----Ā±-----------------------------------------------------Ā±---------------------------------------------------------------------------------------------------------- -----------------------------------------------------------Ā±------------------------------------------------------------Ā±--------------------------------------------- ---------------------------------Ā±---------------------------Ā±----------------Ā±------Ā±--------Ā±----- 279 | http://localhost:8050/openmrs/ws/atomfeed/lab/recent | Failed processing event in feed [http://localhost:8050/openmrs/ws/atomfeed/lab/69] +| tag:atomfeed.ict4h.org:31101a8a-1dbc-4361-906b-343035ff80cf | /openmrs/ws/rest/v1/reference-data/panel/552b 32c8-13fa-459e-8757-992935ccde93 | 2017-07-31 12:12:43.396+00 | 534864687 | panel | 10 | lab | | org.bahmni.webclients.WebClientsException: Bad response code of 500java.lang.RuntimeException: org.bahmni. webclients.WebClientsException: Bad response code of 500 +| | | | | | | | | at org.bahmni.feed.openelis.feed.transaction.support.AtomFeedHibernateTransactionManager.executeWi thTransaction(AtomFeedHibernateTransactionManager.java:51)+| | | | | | | | | at org.ict4h.atomfeed.client.service.AtomFeedClient.processEvents(AtomFeedClient.java:68) +| | | | | | | | | at org.bahmni.feed.openelis.feed.job.OpenELISFeedReaderJob.processEvents(OpenELISFeedReaderJob.jav a:73) +| | | | | | | | | at org.bahmni.feed.openelis.feed.job.OpenELISFeedReaderJob.execute(OpenELISFeedReaderJob.java:57) +| | | | | | | | | at org.quartz.core.JobRunShell.run(JobRunShell.java:207) +| | | | | | | | | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560) +| | | | | | | | | Caused by: org.bahmni.webclients.WebClientsException: Bad response code of 500 +| | | | | | | | | at org.bahmni.webclients.HttpClient.checkSanityOfResponse(HttpClient.java:76) +| | | | | | | | | at org.bahmni.webclients.HttpClient.get(HttpClient.java:57) +| | | | | | | | | at org.bahmni.webclients.HttpClient.get(HttpClient.java:69) +| | | | | | | | | at org.bahmni.feed.openelis.feed.event.LabFeedEventWorker.process(LabFeedEventWorker.java:66) +| | | | | | | | | at org.ict4h.atomfeed.client.service.AtomFeedClient$EventProcessor.doInTransaction(AtomFeedClient. java:168) +| | | | | | | | | at org.ict4h.atomfeed.transaction.AFTransactionWorkWithoutResult.execute(AFTransactionWorkWithoutR esult.java:6) +| | | | | | | | | at org.bahmni.feed.openelis.feed.transaction.support.AtomFeedHibernateTransactionManager.executeWi thTransaction(AtomFeedHibernateTransactionManager.java:42)+| | | | | | | | | ā€¦ 5 more +| | | | | | | | | | | | | | | | 282 | http://localhost:8050/openmrs/ws/atomfeed/lab/recent | Failed processing event in feed [http://localhost:8050/openmrs/ws/atomfeed/lab/70] +| tag:atomfeed.ict4h.org:66bc28d6-fde3-4300-8846-2df66be1b2d0 | /openmrs/ws/rest/v1/reference-data/panel/12f4 04d7-7615-412d-abb8-9273608c12e5 | 2017-07-31 12:12:43.567+00 | -1261443387 | panel | 10 | lab | | org.bahmni.webclients.WebClientsException: Bad response code of 500java.lang.RuntimeException: org.bahmni. webclients.WebClientsException: Bad response code of 500 +| | | | | | | | | at org.bahmni.feed.openelis.feed.transaction.support.AtomFeedHibernateTransactionManager.executeWi thTransaction(AtomFeedHibernateTransactionManager.java:51)+| | | | | | | | | at org.ict4h.atomfeed.client.service.AtomFeedClient.processEvents(AtomFeedClient.java:68) +| | | | | | | | | at org.bahmni.feed.openelis.feed.job.OpenELISFeedReaderJob.processEvents(OpenELISFeedReaderJob.jav a:73) +| | | | | | | | | at org.bahmni.feed.openelis.feed.job.OpenELISFeedReaderJob.execute(OpenELISFeedReaderJob.java:57) +| | | | | | | | | at org.quartz.core.JobRunShell.run(JobRunShell.java:207) +| | | | | | | | | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560) +| | | | | | | | | Caused by: org.bahmni.webclients.WebClientsException: Bad response code of 500 +| | | | | | | | | at org.bahmni.webclients.HttpClient.checkSanityOfResponse(HttpClient.java:76) +| | | | | | | | | at org.bahmni.webclients.HttpClient.get(HttpClient.java:57) +| | | | | | | | | at org.bahmni.webclients.HttpClient.get(HttpClient.java:69) +| | | | | | | | | at org.bahmni.feed.openelis.feed.event.LabFeedEventWorker.process(LabFeedEventWorker.java:66) +| | | | | | | | | at org.ict4h.atomfeed.client.service.AtomFeedClient$EventProcessor.doInTransaction(AtomFeedClient. java:168) +| | | | | | | | | at org.ict4h.atomfeed.transaction.AFTransactionWorkWithoutResult.execute(AFTransactionWorkWithoutR esult.java:6) +| | | | | | | | | at org.bahmni.feed.openelis.feed.transaction.support.AtomFeedHibernateTransactionManager.executeWi thTransaction(AtomFeedHibernateTransactionManager.java:42)+| | | | | | | | | ā€¦ 5 more +| | | | | | | | | | | | | | | | 280 | http://localhost:8050/openmrs/ws/atomfeed/lab/recent | Failed processing event in feed [http://localhost:8050/openmrs/ws/atomfeed/lab/69] +| tag:atomfeed.ict4h.org:a6be29ad-5a68-4404-9f20-e9ec43452cd4 | /openmrs/ws/rest/v1/reference-data/panel/12f4 04d7-7615-412d-abb8-9273608c12e5 | 2017-07-31 12:12:43.433+00 | 534864687 | panel | 10 | lab | | org.bahmni.webclients.WebClientsException: Bad response code of 500java.lang.RuntimeException: org.bahmni. webclients.WebClientsException: Bad response code of 500 +| | | | | | | | | at org.bahmni.feed.openelis.feed.transaction.support.AtomFeedHibernateTransactionManager.executeWi thTransaction(AtomFeedHibernateTransactionManager.java:51)+| | | | | | | | | at org.ict4h.atomfeed.client.service.AtomFeedClient.processEvents(AtomFeedClient.java:68) +| | | | | | | | | at org.bahmni.feed.openelis.feed.job.OpenELISFeedReaderJob.processEvents(OpenELISFeedReaderJob.jav a:73) +| | | | | | | | | at org.bahmni.feed.openelis.feed.job.OpenELISFeedReaderJob.execute(OpenELISFeedReaderJob.java:57) +| | | | | | | | | at org.quartz.core.JobRunShell.run(JobRunShell.java:207) +| | | | | | | | | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560) +| | | | | | | | | Caused by: org.bahmni.webclients.WebClientsException: Bad response code of 500 +| | | | | | | | | at org.bahmni.webclients.HttpClient.checkSanityOfResponse(HttpClient.java:76) +| | | | | | | | | at org.bahmni.webclients.HttpClient.get(HttpClient.java:57) +| | | | | | | | | at org.bahmni.webclients.HttpClient.get(HttpClient.java:69) +| | | | | | | | | at org.bahmni.feed.openelis.feed.event.LabFeedEventWorker.process(LabFeedEventWorker.java:66) +| | | | | | | | | at org.ict4h.atomfeed.client.service.AtomFeedClient$EventProcessor.doInTransaction(AtomFeedClient. java:168) +| | | | | | | | | at org.ict4h.atomfeed.transaction.AFTransactionWorkWithoutResult.execute(AFTransactionWorkWithoutR esult.java:6) +| | | | | | | | | at org.bahmni.feed.openelis.feed.transaction.support.AtomFeedHibernateTransactionManager.executeWi thTransaction(AtomFeedHibernateTransactionManager.java:42)+| | | | | | | | | ā€¦ 5 more +| | | | | | | | | | | | | | | | 281 | http://localhost:8050/openmrs/ws/atomfeed/lab/recent | Failed processing event in feed [http://localhost:8050/openmrs/ws/atomfeed/lab/70] +| tag:atomfeed.ict4h.org:6b850f50-ebde-48f1-9d27-4106df899374 | /openmrs/ws/rest/v1/reference-data/panel/552b 32c8-13fa-459e-8757-992935ccde93 | 2017-07-31 12:12:43.529+00 | -1261443387 | panel | 10 | lab | | org.bahmni.webclients.WebClientsException: Bad response code of 500java.lang.RuntimeException: org.bahmni. webclients.WebClientsException: Bad response code of 500 +| | | | | | | | | at org.bahmni.feed.openelis.feed.transaction.support.AtomFeedHibernateTransactionManager.executeWi thTransaction(AtomFeedHibernateTransactionManager.java:51)+| | | | | | | | | at org.ict4h.atomfeed.client.service.AtomFeedClient.processEvents(AtomFeedClient.java:68) +| | | | | | | | | at org.bahmni.feed.openelis.feed.job.OpenELISFeedReaderJob.processEvents(OpenELISFeedReaderJob.jav a:73) +| | | | | | | | | at org.bahmni.feed.openelis.feed.job.OpenELISFeedReaderJob.execute(OpenELISFeedReaderJob.java:57) +| | | | | | | | | at org.quartz.core.JobRunShell.run(JobRunShell.java:207) +| | | | | | | | | at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560) +| | | | | | | | | Caused by: org.bahmni.webclients.WebClientsException: Bad response code of 500 +| | | | | | | | | at org.bahmni.webclients.HttpClient.checkSanityOfResponse(HttpClient.java:76) +| | | | | | | | | at org.bahmni.webclients.HttpClient.get(HttpClient.java:57) +| | | | | | | | | at org.bahmni.webclients.HttpClient.get(HttpClient.java:69) +| | | | | | | | | at org.bahmni.feed.openelis.feed.event.LabFeedEventWorker.process(LabFeedEventWorker.java:66) +| | | | | | | | | at org.ict4h.atomfeed.client.service.AtomFeedClient$EventProcessor.doInTransaction(AtomFeedClient. java:168) +| | | | | | | | | at org.ict4h.atomfeed.transaction.AFTransactionWorkWithoutResult.execute(AFTransactionWorkWithoutR esult.java:6) +| | | | | | | | | at org.bahmni.feed.openelis.feed.transaction.support.AtomFeedHibernateTransactionManager.executeWi thTransaction(AtomFeedHibernateTransactionManager.java:42)+| | | | | | | | | ā€¦ 5 more +| | | | | | | | | | | | | | | | (4 rows)

If I understand it right, the results do not show up on EMR side, (Bahmniā€™s patient dashboard for exmaple) In that case please check the ā€œmarkersā€ table and ā€œfailed_eventsā€ table on OpenMRS mysql db.