OS: v8.1 MySQL: 8.0.37 Tomcat: provided tomcat-as
While upgrading OS v8.1 → v11.0 we’re getting the following error:
Migration failed for change set db/10.2/seed-data.xml::Populate registration external subject ID search keyword::vpawar:
Reason: liquibase.exception.DatabaseException: PROCEDURE openspecimen.insert_entity_keywords does not exist [Failed SQL: (1305) call insert_entity_keywords(‘catissue_coll_prot_reg’, ‘external_subject_id’, ‘collection_protocol_registration’, ‘externalSubjectId’)]
this repeats multiple times.
List of openspecimen procedures:
add_cfg_prop
add_secured_cfg_prop
assign_to_role
buildSql
createHierarchy
create_cpr_spmn_stats
create_role
create_specimen_stats_table
getChildrenOf
getIdByIndex
getIdCount
getNextPvId
getPvId
getPvParentId
load_revision_entity_records
migrate
populate_specimen_stats
refresh_anticipated_specimens
refresh_cpr_spmn_stats
refresh_specimen_stats
remove_cfg_prop
rename_pv_attribute
stage_anticipated_specimens
How do I generate any missing procedures?