PowerScale: InsightIQ Upgrade from v6.0.1 to v6.1 Fails during Alert Migration

Error message encountered when the InsightIQ upgrade fails due to an alert migration issue:

[2025-10-28 02:28:35] [INFO] [UPGRADE ALERT] Status of alerts migration is: Failed
[2025-10-28 02:28:35] [INFO] [UPGRADE ALERT] Message from alerts migration is: Failed to migrate data
[2025-10-28 02:28:35] [ERROR] [UPGRADE ALERT] Data migration failed. Response is: 12 | 2025-10-28 06:28:32 | Failed | Failed to migrate data

• Case 1: While migrating top generated alerts whose associated alert policy has been deleted, the following error occurs:

2025-10-07 10:09:04 [ERROR] <MainThread : 140351500199104> [alerts_migration : upgrade() : 1435] Failed to do data migration - cannot access local variable 'updated_alert_rule_id' where it is not associated with a value.
2025-10-07 10:09:04 [INFO] <MainThread : 140351500199104> [alerts_migration : update_migration_status() : 1327] Updating status as: Failed in migration status table.

• Case 2: While migrating top generated alerts whose associated alert rule has been deleted, the following error occurs:

2025-10-07 10:23:32 [ERROR] <MainThread : 139820256457920> [alerts_migration : upgrade() : 1435] Failed to do data migration - cannot access local variable 'filter_json_value_name' where it is not associated with a value.
2025-10-07 10:23:32 [INFO] <MainThread : 139820256457920> [alerts_migration : update_migration_status() : 1327] Updating status as: Failed in migration status table.

• Case 3: While migrating top generated alerts whose associated alert policy and alert rule have been deleted, the following error occurs:

2025-10-07 14:45:12 [ERROR] <MainThread : 140518446396608> [alerts_migration : upgrade() : 1435] Failed to do data migration - cannot access local variable 'filter_json_value_name' where it is not associated with a value.
2025-10-07 14:45:12 [INFO] <MainThread : 140518446396608> [alerts_migration : update_migration_status() : 1327] Updating status as: Failed in migration status table.

Alert migration fails when upgrading InsightIQ from version 6.0.1 to 6.1.0, when attempting to migrate generated alerts that are associated with deleted alert policies and or alert rules that existed previously.

This issue occurs only when the top alerts (according to alert ID) in the View Alerts section on InsightIQ UI belong to the deleted policy and or rule category.

If the top alert is associated with an existing rule and policy, the migration proceeds without any issue, even if there are generated alerts linked to deleted rules or policies following the valid alert.

If a failure occurs during the InsightIQ upgrade due to alert migration, follow the steps below:

1. Download the tar from location: list_deleted_rules_policies_delete_associated_alerts.tar
2. Untar the tar using command:

tar -xvf list_deleted_rules_policies_delete_associated_alerts.tar

3. Run the script:

bash list_deleted_rules_policies_delete_associated_alerts.sh

4. Retrigger the upgrade

Verification:

To confirm the upgrade status, check logs using command:

showupg -l

The successful upgrade shows the below message:
Successfully completed 100% of the upgrade and related activities

If the upgrade still does not complete, contact Dell Support.