NetApp Community Update
This site will enter Read Only mode on July 23 as we prepare to move to a new platform. You will still be able to view content, but posting and replying will be temporarily disabled.
We're excited to launch our new Community experience on July 30 and more information will follow soon.
Stay connected during the transition - Join our Discord community today.

Active IQ Unified Manager Discussions

[OC51] Action to acquire information causes the following 8 warnings

mrinal
4,167 Views

Hi all,

After getting the script to setup the WFA user on the OC server I attempted to start the 'Acquire Data' action. The WFA client reports the following 8 warnings. Have highlighted the Vservers. I do not see any errors reported on these Vservers on the OC 5.1 console. All Cluster-Mode clusters are running 8.1.1RC1. Do I need to be concerned about this?

==Warning 1==

A row with broken foreign key was found for cache table 'cm_storage.vserver', columns: (iscsi_allowed,cluster_id,fcp_allowed,type,root_volume_id,id,name_service_switch,cifs_allowed,quota_policy_id,admin_state,name,language,uuid,comment,nfs_allowed,nis_domain) values: (false,751,false,cluster,2150,2149,file,false,Running,dave,POSIX,ab56e1b7-d57f-11e1-b6e6-123478563412,false,-) broken foreign key column: 'root_volume_id'. No row exists in referenced table: 'volume' with value 2150 in column: 'id'

==Warning 2==

A row with broken foreign key was found for cache table 'cm_storage.vserver', columns: (iscsi_allowed,cluster_id,fcp_allowed,type,root_volume_id,id,name_service_switch,cifs_allowed,quota_policy_id,admin_state,name,language,uuid,comment,nfs_allowed,nis_domain) values: (false,751,false,cluster,1744,1743,file,false,Running,andrew,English,1a8597e4-83b9-11e1-87da-123478563412,false,-) broken foreign key column: 'root_volume_id'. No row exists in referenced table: 'volume' with value 1744 in column: 'id'

==Warning 3==

A row with broken foreign key was found for cache table 'cm_storage.vserver', columns: (iscsi_allowed,cluster_id,fcp_allowed,type,root_volume_id,id,name_service_switch,cifs_allowed,quota_policy_id,admin_state,name,language,uuid,comment,nfs_allowed,nis_domain) values: (false,751,false,cluster,1861,1860,ldap,file,false,Running,infrastructure,POSIX,3f11eefe-a0c2-11e1-af35-123478563412,false,-) broken foreign key column: 'root_volume_id'. No row exists in referenced table: 'volume' with value 1861 in column: 'id'

==Warning 4==

A row with broken foreign key was found for cache table 'cm_storage.vserver', columns: (iscsi_allowed,cluster_id,fcp_allowed,type,root_volume_id,id,name_service_switch,cifs_allowed,quota_policy_id,admin_state,name,language,uuid,comment,nfs_allowed,nis_domain) values: (false,751,false,cluster,2154,2148,file,false,Running,mrinal-vs01,POSIX,b407fc97-da4a-11e1-b6e6-123478563412,false,-) broken foreign key column: 'root_volume_id'. No row exists in referenced table: 'volume' with value 2154 in column: 'id'

==Warning 5==

A row with broken foreign key was found for cache table 'cm_storage.vserver', columns: (iscsi_allowed,cluster_id,fcp_allowed,type,root_volume_id,id,name_service_switch,cifs_allowed,quota_policy_id,admin_state,name,language,uuid,comment,nfs_allowed,nis_domain) values: (false,751,false,cluster,2150,2149,file,false,Running,dave,POSIX,ab56e1b7-d57f-11e1-b6e6-123478563412,false,-) broken foreign key column: 'root_volume_id'. No row exists in referenced table: 'volume' with value 2150 in column: 'id'

==Warning 6==

A row with broken foreign key was found for cache table 'cm_storage.vserver', columns: (iscsi_allowed,cluster_id,fcp_allowed,type,root_volume_id,id,name_service_switch,cifs_allowed,quota_policy_id,admin_state,name,language,uuid,comment,nfs_allowed,nis_domain) values: (false,137,false,cluster,2166,2158,file,false,Running,pVSSAN01,POSIX,3736154a-d052-11e1-be56-123478563412,false,-) broken foreign key column: 'root_volume_id'. No row exists in referenced table: 'volume' with value 2166 in column: 'id'

==Warning 7==

A row with broken foreign key was found for cache table 'cm_storage.vserver', columns: (iscsi_allowed,cluster_id,fcp_allowed,type,root_volume_id,id,name_service_switch,cifs_allowed,quota_policy_id,admin_state,name,language,uuid,comment,nfs_allowed,nis_domain) values: (false,137,false,cluster,2160,2159,file,false,Running,pVSESX01,POSIX,54e3680d-d0ef-11e1-af68-123478563412,false,-) broken foreign key column: 'root_volume_id'. No row exists in referenced table: 'volume' with value 2160 in column: 'id'

==Warning 8==

A row with broken foreign key was found for cache table 'cm_storage.vserver', columns: (iscsi_allowed,cluster_id,fcp_allowed,type,root_volume_id,id,name_service_switch,cifs_allowed,quota_policy_id,admin_state,name,language,uuid,comment,nfs_allowed,nis_domain) values: (false,751,false,cluster,8293,8285,file,false,Running,oracle_nfs,POSIX,09cb10cd-e614-11e1-b6e6-123478563412,false,-) broken foreign key column: 'root_volume_id'. No row exists in referenced table: 'volume' with value 8293 in column: 'id'

1 ACCEPTED SOLUTION

hland
4,167 Views

Hi Mrinal,

you can safely ignore these warnings. OnCommand tends to have a rather unclean database. WFA correctly handles all of this...

Regards

Hendrik

View solution in original post

2 REPLIES 2

hland
4,168 Views

Hi Mrinal,

you can safely ignore these warnings. OnCommand tends to have a rather unclean database. WFA correctly handles all of this...

Regards

Hendrik

mrinal
4,168 Views

Thank you. This thread can be closed.

Public