跳转到主内容

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

Views:
17
Visibility:
Public
Votes:
0
Category:
not set
Specialty:
not set
Last Updated:

1

Applies to

  • OnCommand Workflow Automation 5.1 (WFA)

Issue

When attempting to acquire one or more ActiveIQ Unified Manager data sources in WFA (within the Data Sources view under Settings), the data source(s) continue remain 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...

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support