Resource sync process for Redshift datasets are failing with error (RTE-1001, 'adp'.) in a non multi-tenant environment where the tenant table is empty and the dataset or the domain table records do not have TenantName metadata in them. When the TenantName metadata is added to the records in datasets and domain table, the process is sending incorrect emails with message "Dataset which was created using Amorphic was deleted via AWS console" for all redshift datasets.
Affected Versions: 2.0
Fix Version: 2.1 2.0*
Customers upgrading to 2.0 after March 24, 2023 does not require explicit patching as the fix will be part of the release artifacts.
Root cause(s)
While creating a connection to Redshift, tenantname was not being added in the connection credentials and hence the dataset list returned from Redshift is not matching with Amorphic list of datasets.
Impact
Amorphic admins will receive incorrect email notifications saying that deleting datasets directly from AWS Console is not recommended.
Mitigation
A fix is available in Amorphic version 2.1. Please upgrade to the latest version to resolve this issue.
Patch is available for Amorphic versions v2.0.
Timeline
- 2023-03-19: Bug reported/identified (CLOUD-3152)
- 2023-03-19: Bug triaged
- 2023-03-22: Bug fixed
- 2023-03-23: Testing of patch on v2.0 is completed
- 2023-03-24: Patch for v2.0 released(v2.0 artifacts updated)
- 2023-03-28: Amorphic version 2.1 Released with the bugfix