Unable to apply Bahmni Liquibase changes on a 'fresh' OpenMRS database.

Description

Steps to reproduce:

Start OpenMRS platform on Core 2.1.1 (using OpenMRS SDK for instance).
Let the Core Liquibase migrations run.
Once migrations are done and server fully started, stop the server.

Add the Bahmni 0.91 modules to the installation: bacteriology, operating theater and bahmni core.
Start the server again.
Confirm that Liquibase migrations are failing and Bahmni Core module won't start.

Acceptance criteria:

  • Bahmni should still work when providing the new artifacts, prior any Liquibase migration, ie, at first start.:

    • install default Bahmni and place the new artifacts (Bahmni Core and Bacteriology likely), right before the first start of OpenMRS.

  • Bahmni should still work when providing the new artifcats after all Liquibase migrations have run:

    • install default Bahmni and let it fully run. Then place the new artifacts and restart OpenMRS.

  • OpenMRS should work when providing the artifacts on an empty database:

    • start an SDK-based OpenMRS and provide the new artifacts right when OpenMRS migrations start.

  • OpenMRS should work when providing the artifacts after OpenMRS migrations have run:

    • start an SDK-based OpenMRS and let it start. Then replace with the new artifacts and start again.

Activity

Show:
Zoheir CHINE
November 25, 2019, 2:50 PM
Edited
  • Testing with the demo dump database is confirmed to work perfectly.

  • Testing with the clean dump database is throwing no error from bahmn-core and bacteriology modules, but because of an predicted issue from the SQL file I can’t login to OpenMRS

databases used are :

  • demo dump database :

  • clean dump database :

 

Romain Buisson
November 25, 2019, 5:03 PM

Thanks ,
About this:

Testing with the clean dump database is throwing no error from bahmn-core and bacteriology modules, but because of an predicted issue from the SQL file I can’t login to OpenMRS

Would you be able to try it without the PR? Because I suspect that the database just does not work out of the box and the issue likely does not come from those PRs.

Zoheir CHINE
November 28, 2019, 8:23 AM

, Testing Bahmni using OpenMRS clean dump database without the PRs shows the same result, (no errors during bahmni-core and bacteriology migration but can’t login to OpenMRS)

Romain Buisson
November 28, 2019, 11:53 AM

Thanks .

Thanks as well.


, I think we can safely merge the PR associated with this issue: PR #51 and PR #5

Himabindu Thungathurty
February 19, 2020, 9:21 AM

Reviewed and merged the PR to bahmni-core master

Assignee

Zoheir CHINE

Reporter

Romain Buisson

Labels

None

Units

None

PercentDone

None

DueTime

None

Clients

None

External issue ID

None

UAT Assignee

None

Reviewer

None

Sprint

0.93 Product M2

Fix versions