Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Improve ways to populate publicationPeriod field

Description

Overview:
publicationPeriod field is a derived field and is populated based on the values of dateOfPublication field as described in https://folio-org.atlassian.net/browse/MODINVSTOR-723#icft=MODINVSTOR-723 and https://folio-org.atlassian.net/browse/MODINVSTOR-724#icft=MODINVSTOR-724 .

During the upgrade process the script that populates publicationPeriod is executed and significantly slows down the upgrade (MODINVSTOR-774). To address the issue the existing implementation has been removed in https://github.com/folio-org/mod-inventory-storage/pull/676/files and the field needs to be populated manually (example: https://github.com/folio-org/mod-inventory-storage/blob/master/src/main/resources/templates/db_scripts/populatePublicationPeriod.sql ).

This story is to cover other possible approach that will continue to populate publicationPeriod automatically without negatively impacting the migration process

Acceptance criteria

  1. publicationPeriod is populated automatically

  2. Migration process for mod-inventory-storage is below 2hours on the bugfest data set (8M instance records)

Environment

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Magda Zacharska November 18, 2021 at 1:35 PM
Edited

The deployment of mod-inventory-storage in kiwi bugfest took approx 15 minutes.

Julian Ladisch October 14, 2021 at 7:03 AM

Thank you!

The code to populate publicationPeriod runs only for R3 2021, it doesn't run for any later migration.

If only one institution (Cornell) or a few institutions are affected the manual migration might be a workaround that is good enough and we don't need a fix with a better automatic migration.

Julian Ladisch October 7, 2021 at 1:27 PM

Could you fill the "Affected institution(s)" field?

Done

Details

Assignee

Reporter

Labels

Priority

Story Points

Sprint

Development Team

Falcon

Fix versions

Release

R3 2021 Bug Fix

Affected Institution

Cornell

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created October 6, 2021 at 9:36 PM
Updated November 24, 2021 at 10:51 AM
Resolved October 25, 2021 at 11:49 AM
Configure
TestRail: Cases
TestRail: Runs