Error on programenrollment atomfeed event

aidjali · April 22, 2022, 1:57pm

I am trying to make the suggested changes on openmrs so that I will be able to get all program enrollment related events in the event_records table of the atomfeed.

So far I have:

set atomfeed.publish.eventsForPatientProgramStateChange to true
atomfeed.event.urlPatternForProgramStateChange to /openmrs/ws/rest/v1/programenrollment/{uuid}?v=full which is the default value

Once I am trying to enroll a patient in a program (e.g. HIV) I get the event on the event_records table but once I visit the link I am not able to get the details of it for example I can do with bahmniencounter

This is the error I am getting:

URL:

https://IP:PORT/openmrs/ws/rest/v1/programenrollment/8d3edb39-7669-454d-bf35-f557df4c675d?v=full

Am I missing some changes or there might be an error with my own instance?

gsluthra · April 28, 2022, 11:55am

Which version of Bahmni are you using?

aidjali · April 28, 2022, 12:07pm

@gsluthra I am using v0.93

gsluthra · April 28, 2022, 12:22pm

I was able to reproduce the issue on Demo server. Same exception… for program enrollment. Does this user have 2 enrollments (one done in the past and one just now)? Still… the UUID for enrollment should be unique.

Exception is being thrown on this line of code:

github.com

openmrs/openmrs-core/blob/2.1.x/api/src/main/java/org/openmrs/api/db/hibernate/HibernateProgramWorkflowDAO.java#L287

      
        
            	public ConceptStateConversion getConceptStateConversionByUuid(String uuid) {
            		return (ConceptStateConversion) sessionFactory.getCurrentSession().createQuery(
            		    "from ConceptStateConversion csc where csc.uuid = :uuid").setString("uuid", uuid).uniqueResult();
            	}
            	
            	/**
            	 * @see org.openmrs.api.db.ProgramWorkflowDAO#getPatientProgramByUuid(java.lang.String)
            	 */
            	public PatientProgram getPatientProgramByUuid(String uuid) {
            		return (PatientProgram) sessionFactory.getCurrentSession().createQuery(
            		    "from PatientProgram pp where pp.uuid = :uuid").setString("uuid", uuid).uniqueResult();
            	}
            	
            	/**
            	 * @see org.openmrs.api.db.ProgramWorkflowDAO#getProgramByUuid(java.lang.String)
            	 */
            	public Program getProgramByUuid(String uuid) {
            		return (Program) sessionFactory.getCurrentSession().createQuery("from Program p where p.uuid = :uuid").setString(
            		    "uuid", uuid).uniqueResult();
            	}

On demo server today: https://demo.mybahmni.org/openmrs/ws/rest/v1/programenrollment/eefcdc14-5ab7-4710-8ded-d7fd2bde404b

Will need to raise a bug in JIRA, for further investigation. This issue might already be fixed in latest version of OpenMRS… but need to investigate further.

aidjali · April 28, 2022, 12:30pm

@gsluthra thank you. I was about to present this on yesterday’s PAT call but couldn’t participate. I would be happy if I would be informed if this is the case with the latest OpenMRS version.

gsluthra · May 9, 2022, 8:44am

I have raised a JIRA ticket in the Community board here: Log in with Atlassian account