Symptoms

Error message encountered when the InsightIQ upgrade fails due to an alert migration issue: Upgrade fails with error message due to alert migration failure. [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: Error when initial policies are deleted: 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: Error when initial rules are deleted: 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: Error when initial policies and rules are deleted: 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.

Cause

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.

Resolution

If a failure occurs during the InsightIQ upgrade due to alert migration, follow the steps below: Download the tar from location: list_deleted_rules_policies_delete_associated_alerts.tar Untar the tar using command: tar -xvf list_deleted_rules_policies_delete_associated_alerts.tar Run the script: bash list_deleted_rules_policies_delete_associated_alerts.sh 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 activitiesIf the upgrade still does not complete, contact Dell Support.

Support Cases