Hello everyone. I have just completed initialization of OpenMRS core on PostgreSQL. All changesets in core are executing after some changes. I have added the legacy UI module and was trying to create a patient where I got the error
Caused by: org.postgresql.util.PSQLException: ERROR: relation "hibernate_sequence" does not exist
Here is the link to the logs: https://pastebin.com/Mp0GjKyi I went through the Patient Hibernate config file and found that there is no sequence set on patient_id https://github.com/openmrs/openmrs-core/blob/d16c00515d31f47bf1b852f763597f0254c7398e/api/src/main/resources/org/openmrs/api/db/hibernate/Patient.hbm.xml#L20-L23
Looking at postgresql database, it appears that there is a sequence with name patient_identifier_patient_identifier_id_seq but it has not been linked to patient_id.
Is there a reason for this or am I missing something?
Any help is appreciated.