Liquibase Provider Errors - e.provider_id for tables without a provider

Implementing
1

In the process of running an upgrade from 1.11.6 to 2.x, I am running into a strange error for liquibase changesets which as for e.provider_id

  1. Error https://gist.github.com/ssmusoke/486bd245d3e4ad0130052f55eb42cd95 from this changeset https://github.com/openmrs/openmrs-core/blob/2.0.x/api/src/main/resources/liquibase-update-to-latest.xml#L8626-L8632

  2. Error https://gist.github.com/ssmusoke/02c36130397b5668dd4fbc3117878067 from this changeset https://github.com/openmrs/openmrs-module-reporting/blob/master/api/src/main/resources/liquibase.xml#L397-L402

@mogoodrich would you have run into this with the provider management module - it seems strange since none of the tables being touched have direct links to the provider table

2

Do you get the same error if you try to manually drop this foreign key constraint from the database?

3

The error is in the precondition not the actual changeset

4

Tip of the day: when troubleshooting, do whatever you are told, even when it may not make sense to you. :smile:

1 Like
5

@dkayiwa :sweat_smile::wink::exploding_head: Thanks for the tip

6

@dkayiwa Works for #1 but not #2

The strange thing is that #2 totally has nothing to do with providers

7

What happens when you manually try to drop the “report_definition_uuid for reporting_report_design” index from the database?

1 Like
8

I dropped it but no change the error still happens

9

How does the current error log look like?

10
11

Did you get any error while manually dropping the “report_definition_uuid for reporting_report_design” index ?

12

@dkayiwa Nope I did not, but just to make doubly sure I will restore the database and check again … Will update this post in the morning

13

In your database, do you have any table named “import” or just as part of its name?

14

@dkayiwa only metadatasharing_imported_item and metadatasharing_imported_package

15

Similar error was reported here Platform upgrade

16

Can you describe the reporting_report_design table?

17
18

And what does show tables return?

19

Just reading this very quickly, but is this different than what @ningosi linked to above?

(Just ignore if you’ve already checked, that, wanted to point it out again just in case… :slight_smile: )

20

Thanks @mogoodrich was just reading through that and its different

@dkayiwa https://gist.github.com/ssmusoke/7401b2ec613f195f5b4dfb1525e5bc5e