Unable to connect to ActiveIQ Unified Manager data source due to foreign key constraint in WFA 5.1

Applies to

• OnCommand Workflow Automation 5.1 (WFA)
• OnCommand Workflow Automation 5.0 (WFA)
• ActiveIQ Unified Manager 9.6+
• OnCommand Unified Manager 9.4

Issue

The ActiveIQ Unified Manager data sources in WFA are in a failed status with a similar message:

Cannot delete or update a parent row: a foreign key constraint fails (`cm_storage`.`qtree`, CONSTRAINT `fk_cm_storage_qtree_volume_id` FOREIGN KEY (`volume_id`) REFERENCES `volume` (`id`) ON DELETE CASCADE) Query is: INSERT INTO cm_storage.volume SELECT t.guid,t.vserver_id,null,null,t.name,t.size_mb,t.used_size_mb,t.available_size_mb,t.type,t.state,t.junction_path,t.space_guarantee,t.snapshot_used_mb,t.snapshot_reserved_percent,t.snapshot_enabled,t.style,t.max_autosize_mb,t.block_type,t.security_style,t.dedupe_enabled,t.auto_increment_size_mb,null,null,t.autosize_enabled,t.compression,t.deduplication_space_saved_mb,t.compression_space_saved_mb,t.percent_deduplication_space_saved,t.percent_compression_space_saved,t.hybrid_cache_eligibility,t.inode_files_total,t.inode_files_used,t.auto_size_mode,t.sis_last_op_begin_timestamp,t.sis_last_op_end_timestamp,null,t.flexcache_min_reserve_mb,t.constituent_role,t.is_managed_by_service,t.storage_class,t.snap_diff_enabled,t.max_namespace_constituent_size_mb,t.max_data_constituent_size_mb,null,null,t.language,t.data_daily_growth_rate_mb,t.data_days_until_full,t.auto_delete_enabled,t.auto_delete_commitment,t.auto_delete_delete_order,t.auto_delete_defer_delete,t.auto_delete_target_fre...