Versions Compared

Old Version 1

changes.mady.by.user Krishna Waidande

Saved on

compared with

New Version Current

changes.mady.by.user Prayuja Teli

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The below error may occur when upgrading OpenSpecimen from v6.1 to the latest versions. This error comes because of mismatching of author/id/md5sum values present for ‘db'db/2.0/permissible-values.xml’ xml' changeset in the databasechangelog table.

Reason: liquibase.exception.DatabaseException:  Cannot Cannot add or update a child row: a foreign key constraint fails (`openspecimenopenspecimen_test`test.`catissuecatissue_permissible_value`value, CONSTRAINT `FK57DDCE1FC56C2B1` FK57DDCE1FC56C2B1 FOREIGN KEY (`PUBLICPUBLIC_ID`ID) REFERENCES `catissuecatissue_cde` cde (`PUBLICPUBLIC_ID`ID) ON DELETE NO ACTION ON UPDATE NO ACTION)

To resolve the issue, we need to manually add the correct ‘db'db/2.0/permissble-values.xml’ xml' changesets using below steps:

...