Function set_id_in_jsonb is present in migrated Juniper/Kiwi environment - Lotus BF

Description

The following issue is observed in bugfest-juniper.folio.ebsco.com environment.

Bugfest was migrated from Iris to mod-source-record-storage-5.1.4)
We compared the schema in bugfest Juniper with a fresh Juniper install
Differences detected that function set_id_in_jsonb () is still present in bugfest Juniper db but not present in a fresh Juniper install.

Schema migration should have removed this function – issues was raised for Iris and HS releases as well:
MODSOURCE-280

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2

Checklist

hide

TestRail: Results

Activity

Show:

Ann-Marie BreauxApril 12, 2022 at 2:39 PM

Excellent - thank you!

Kateryna SenchenkoApril 12, 2022 at 1:52 PM

Thank you very much !

, I think we can close this issue now. Thank you!

Olamide KolawoleApril 12, 2022 at 1:29 PM

I was able to confirm that the script(from 2021) was executed via upgrade logs and the function in no longer in Lotus Bugfest database schema.

Ann-Marie BreauxApril 12, 2022 at 7:57 AM

Hi Please see Kate's note a couple comments above. Could you confirm that the script worked for deleting the function? Thank you!

Ann-Marie BreauxApril 6, 2022 at 1:13 PM
Edited

improvement for Morning Glory to add parameter runAlways=true to remove this function if exists during each SRS deployment and test properly - was actually done in Lotus BF, so not needed in MG. The only MG Jira is the clone for MG Main release

Done

Details

Assignee

Reporter

Priority

Story Points

Development Team

Folijet Support

Fix versions

Release

Lotus (R1 2022) Bug Fix

RCA Group

Not a bug

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created August 9, 2021 at 6:46 PM
Updated April 15, 2022 at 10:42 AM
Resolved April 4, 2022 at 8:10 AM
TestRail: Cases
TestRail: Runs