Skip to end of banner
Go to start of banner

Ramsons (R2 2024) Required manual migrations

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Module

Instructions

Comments

Contact person

mod-entities-links

Manually executed script for each tenant

-- Check if such record exists
SELECT 1 FROM <tenantId>_mod_entities_links.authority WHERE deleted = true;
-- Move to archive
INSERT INTO <tenantId>_mod_entities_links.authority_archive
SELECT * FROM <tenantId>_mod_entities_links.authority WHERE deleted = true
ON CONFLICT DO NOTHING;
-- Delete deleted
DELETE FROM <tenantId>_mod_entities_links.authority WHERE deleted = true;

Due to migration issues in previous releases, there may be cases where deleted authority records are not transferred to the authority archive. While this doesn't significantly impact functionality, moving them to the correct location would enhance consistency.

  • No labels