Issue migrating from v3.2.0 to v3.3.1

Description

We upgraded mod-kb-ebsco-java in bugfest environment
from mod-kb-ebsco-java-3.2.0
to mod-kb-ebsco-java-3.3.1

The migration was a success, however, we observed that table access_types_mapping did not get created as part of the upgrade process

Attached are log files

and

with entries observed during the upgrade

We assumed the following should have executed as part of this process https://github.com/folio-org/mod-kb-ebsco-java/blob/34c2f3996f73c32f78882858cd72dbb35804db56/src/main/resources/templates/db_scripts/schema.json#L84

We manually ran the following script to add in what was detected as missing (Note – this was done after trying to upgrade the module using the standard process)

Note - bugfest was at version 3.2.0 of mod-kb-ebsco-java due to testing - whereas 3.1.0 is official edelweiss release
https://github.com/folio-org/mod-kb-ebsco-java/releases/tag/v3.1.0

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

3

defines

Checklist

hide

TestRail: Results

Activity

Show:

Carole Godfrey March 29, 2020 at 4:17 PM
Edited

03/29 – Believe this issue is due the fact that we were migrating from 3.2.0 to 3.3.1

The change to introduce access_types_mapping table was made as part of 3.3.0 release ()
https://github.com/folio-org/mod-kb-ebsco-java/releases/tag/v3.3.0

The script should be updated
https://github.com/folio-org/mod-kb-ebsco-java/blob/ff21ae5a501c15237509c5ccbaa7850f8ef1e901/src/main/resources/templates/db_scripts/schema.json#L81

Instead of
"fromModuleVersion": "mod-kb-ebsco-java-3.1.1"

Its should be a version greater than the 3.2 release – or the release in which the change was made (3.3.0) - since the change was introduced after v 3.2.0
"fromModuleVersion": "mod-kb-ebsco-java-3.3.0"

Believe this requires the same change as well
https://github.com/folio-org/mod-kb-ebsco-java/blob/ff21ae5a501c15237509c5ccbaa7850f8ef1e901/src/main/resources/templates/db_scripts/schema.json#L105

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

Fix versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created March 23, 2020 at 7:05 PM
Updated April 9, 2020 at 5:07 PM
Resolved April 6, 2020 at 1:51 PM
TestRail: Cases
TestRail: Runs