Investigate migration issues caused by Poppy upgrade

Description

Some profiles after migration lose their Actions (relevant for re-used Actions in different Profiles). Investigate the causes, look for possible solutions.

Cornell will provide examples of their profiles. Create Orchid env (actually we only need the mod-di-converter-storage schema and the module) with provided data, migrate data - see what happens. Before migration see what logs could be added, turn the most detailed level of logging.

 

Critical service patch details

  1. Describe issue impact on business - Issue will cause Job profiles to unlink from Match profiles and Action profiles during system migration process (e.g. Orchid to Poppy)

  2. What institutions are affected? (field “Affected Institutions” in Jira to be populated) - Reported by Cornell, 5 Colleges, potential to affect any institution.

  3. What is the workaround if exists? No workaround.

  4. What areas will be impacted by fix (i.e. what areas need to be retested) - Existing job profiles prior to the migration and creation of new profiles and linking them.

  5. Brief explanation of technical implementation and the level of effort (in workdays) and technical risk (low/medium/high). - Previously the migration was part Java and part SQL, there was some context missing on the SQL side that caused wrong links to be selected. The migration is now all SQL to retain the context. This involved 9 workdays of effort with a technical risk of low.

  6. Brief explanation of testing required and level of effort (in workdays). Provide test plan agreed with by QA Manager and PO.  -
    - Creation of new profiles, linking them and performing data import jobs with those profiles.
    - Checking existing job profiles ensuring that there are no missing links.

  7. What is the roll back plan in case the fix does not work? Revert to previous version.

CSP Request Details

CSP Request on 2/12/24 via Slack

CSP Rejection Details

None

Environment

None

Potential Workaround

None

Attachments

6

Checklist

hide

TestRail: Results

Activity

Show:

Kateryna SenchenkoMarch 7, 2024 at 11:16 AM

Regarding Poppy CSP#1 → Poppy CSP#2 migration -current fix resolves the problem of lost associations during Orchid → Poppy migration, particularly with Default profiles. On Poppy bugfest we can still observe some profiles with lost associations, but that happened independently of migration, as a result of editing those profiles due to the bug (fixed for CSP#1).

Therefore, moving this ticket back to In Bugfix Review, it is safe to upgrade to CSP#2.

Kateryna SenchenkoMarch 7, 2024 at 11:11 AM

Hi , loadSample param is not needed for mod-di-converter-storage, default profiles will populate regardless of the passed parameters. If you think we need to investigate further the issues that you faced during Nolana → Orchid migration, please create a separate Jira, it will be out of scope of this ticket. Thank you!

Jason RootMarch 6, 2024 at 5:25 PM

One question I do have - did I need to enable loading sample data for this module when I enabled/upgraded it for my tenant post-module rename?

Jason RootMarch 6, 2024 at 5:18 PM
Edited

I checked that the schema was renamed in our testing env, and it was. I also did run that script and it said it updated data. Sadly, in the UI the profiles all remain unlinked.

Jason RootMarch 6, 2024 at 5:09 PM

Sadly I no longer have access to the upgrade logs, but Okapi gave me no failed status during the upgrade. I will check out the script, thank you.

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Folijet

Fix versions

Release

Poppy (R2 2023) Service Patch #2

CSP Approved

Yes

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created February 2, 2024 at 9:28 AM
Updated August 28, 2024 at 9:42 AM
Resolved March 7, 2024 at 11:16 AM
Loading...