Registration page does not load

Software Bahmni
1

I have installed Bahmni on a vagrant-centos-6.7.box using the following wiki link.

https://bahmni.atlassian.net/wiki/display/BAH/Using+a+Fresh+Database

I have created a user that has Super User privileges and i have also added a visit location as Registration. On accessing the URL i get the login page and on logging in i am able to see all the modules that i have configured and registration form is one of them. When i click on registration i get the below screen

Screenshot from 2016-12-20 18-19-13.png1920×1080 138 KB

On checking the openmrs logs i see the below error indicating a failed migration

Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO user_role VALUES (@id, ‘bypass2FA’),(@id,‘Provider’),(@id,‘System Developer’): Duplicate entry ‘Provider-1’ for key ‘PRIMARY’: Caused By: Error executing SQL INSERT INTO user_role VALUES (@id, ‘bypass2FA’),(@id,‘Provider’),(@id,‘System Developer’): Duplicate entry ‘Provider-1’ for key ‘PRIMARY’: Caused By: Duplicate entry ‘Provider-1’ for key ‘PRIMARY’

On checking the user_role table i did not find anything by the name ‘Provider-1’ so not sure how to proceed further. Can someone help me with this?

2

what is the output of the query select user_id from users where username='admin'

3

Below is the output of the query

mysql> select user_id from users where username=‘admin’; ±--------+ | user_id | ±--------+ | 1 | ±--------+ 1 row in set (0.00 sec)

4

Can you also check the contents of user_role table

5

This is a bug with the product. So, the migrations are running again which is the source of this problem. @ajjaswanth Please raise a defect card and provide the card details to track the status.

This is the issue with meta data set up. There should be an entry in entity_mapping table for mapping type login_location and visit_type.

6

@sravanthi17 Created defect card https://bahmni.mingle.thoughtworks.com/projects/bahmni_emr/cards/2989 regarding clean openmrs dump migration issue. Please add more info if required.