Amorphic upgrade may fail for limited application due to missing TenantName attribute in the metadata of datasets.
When the above issue occurs, the application tries to send an email notification to the administrators. This causes a follow-up issue: In roleUtil.search_permissions, Malformed Service level Permissions Json, service requested apps, action name fullaccess.
Affected Versions: 2.1
Fix Version: 2.2
Root cause(s)
For providing Domains and Datasets permissions to a user in Redshift we need to create the Redshift connection. While providing the respective Tenant name for creating the redshift connection, We are fetching the tenant name information from the metadata of the dataset. For Datasets with no TenantName attribute in their metadata ( No TenantName attribute in DatasetsTable for that dataset), creating a redshift connection will fail with the error ‘TenantName’.
Impact
The above happens with the applications which were deployed before Multi-Tenancy was introduced in version 1.12 and they try to upgrade to version 2.1.
Mitigation
Tenant issue - Backfill default tenant names manually in the dataset available in the Datasets table with missing TenantName attribute. Permission Issue - This would not occur, if the above issue is being handled gracefully.
Fix is available in Amorphic v2.2. Please upgrade to the latest version to resolve this issue.
Timeline
- 2023-04-20: Bug reported/identified (CLOUD-3263)
- 2023-04-20: Bug triaged
- 2023-04-24: Bug fixed
- 2023-05-05: Testing completed and fix is available