Subscribe
Accepted Solution

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

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'

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

Hi Mrinal,

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

Regards

Hendrik

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

Thank you. This thread can be closed.