Orchid (R1 2023) - Bugfest env preparation - Issues/preparation we needed to resolve on environment

1. Migrate subjects of instances for all tenants

As mentioned in Release Notes Orchid (R1 2023) Release Notes we needed to run migration script for all tenants

Be aware that with 2 instances of mod-inventory-storage it takes for us in about 10.5 hours.

The process could be speed up with scaling up mod-inventory-storage replica count!

2. We needed to drop old permissions "ui-finance.all", "ui-finance.view" that was assigned to 30 users because it blocked for them possibility to manage permissions even if they had rights.

We did by running next script in DB:

update {{TENANT_ID}}_mod_permissions.permissions_users
set jsonb = 
    jsonb_set(jsonb, '{permissions}', (jsonb->'permissions') - 'ui-finance.all') 

update {{TENANT_ID}}_mod_permissions.permissions_users
set jsonb = 
    jsonb_set(jsonb, '{permissions}', (jsonb->'permissions') - 'ui-finance.view')

3. Run scripts from https://folio-org.atlassian.net/wiki/display/FOLIJET/Script+to+remove+SRS+MARC_BIB+records+with+no+links+to+Instance+Id?
and optionally https://folio-org.atlassian.net/wiki/display/FOLIJET/Script+to+remove+child+and+parent+elements+from+data+import+profiles for all tenants

BE AWARE that running the script Script to remove SRS MARC_BIB records with no links to Instance Id for main tenant with 8 million instance records took 1h 20min

4. Run SQL script to hide deprecated permissions for all tenants - BF-444 - Getting issue details... STATUS

Script:

UPDATE {TENANT_ID}_mod_permissions.permissions
SET jsonb = jsonb_set(jsonb, '{visible}', 'false')
WHERE jsonb->>'deprecated' in ('true') 
AND jsonb->>'visible' in ('true')

5. Generate Default mapping rules for marc-authority/marc-bib - all tenants

empty PUT request to https://{okapi_url}/mapping-rules/marc-bib/restore, https://{okapi_url}/mapping-rules/marc-authority/restore

6. BF-463 - Getting issue details... STATUS issue was resolved with reinstall mod-inventory-storate, mod-inventory with loadreference loadsample data flags set to true.

7. !!! AFTER CREATION OF ENVIRONMENT {ENVIRONMENT}.Default.fs09000000.DI_ all topics except - {ENVIRONMENT}.Default.fs09000000.DI_INITIALIZATION_STARTED should have 2 Partitions, after setting count of topics to 2, restart data-import, di-converter-storage, srs, srm, inventory, inventory-storage

8. BE AWARE that release of mod-remote-storage v2.0.0 have a bug related to /admin/health endpoint that don't allow module to stand to stable state and do migration. The bug was fixed in v2.0.1