Details
-
Bug
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
None
-
Prokopovych - Sprint 114, Prokopovych - Sprint 115, Prokopovych - Sprint 116, Prokopovych - Sprint 117, Prokopovych - Sprint 118, Prokopovych - Sprint 119, Prokopovych - Sprint 120, Prokopovych - Sprint 121, Prokopovych - Sprint 122
-
3
-
Prokopovych
Description
Overview:
The following issue is observed in bugfest-iris.folio.ebsco.com environment.
Functions update_effective_location_on_holding_update () and update_effective_location_on_item_update () are both present in bugfest iris db
Bugfest-iris was updated from mod-inventory-storage-19.4.4 to mod-inventory-storage-20.2.1
We compared db schema to a cleanly installed Iris environment db schema (environment was not upgraded)
These functions do not exist in the cleanly installed environment
Migration scripts should be put in place for cleanup of no longer needed functions.
looks like triggers were removed but trigger functions still remain
https://github.com/folio-org/mod-inventory-storage/blob/v20.2.1/src/main/resources/templates/db_scripts/dropLegacyItemEffectiveLocationTriggers.sql
Expected Results:
Functions update_effective_location_on_holding_update () and update_effective_location_on_item_update () are removed as part of module upgrade
Actual Results:
Functions are present in upgraded environment
Additional Information:
URL:
Interested parties:
TestRail: Results
Attachments
Issue Links
- relates to
-
MODINVSTOR-625 Change effective location for items if parent holding or item location is changed
-
- Closed
-
- mentioned in
-
Page Loading...