Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

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

mrinal

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

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

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

mrinal

Thank you. This thread can be closed.

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public