Subscribe

Warnings from WFA about DFM/OnCommand data.

I'm setting up a WFA server in my lab and connected it to my OC 5.0.1 server on Friday.

It's telling me that I have one warning (duplicate data) in the 7-mode tables (profile 'storage') and seven warnings in the c-mode tables (profile 'cm-storage'). I've attached the error messages so you can look them over but the seem pretty straightforward. My questions are:

  1. Does this actually mean duplicate entries in the table(s)?
  2. Does this violate table constraints?
  3. How do I clean up these duplicate entries in the database?

Phil

Warning Messages

Detail of one message

Full text of warnings:


Warning for 7-mode tables (profile 'storage'):

Duplicate rows found for cache table storage.dataset,

columns: (id,volume_id,uuid,qtree_id,dfm_name,name)

rows:

(5,null,NJ_VM_OCC/OSSV Backup/0/0,null,NJ-VM-OCC,OSSV Backup)

(6,null,NJ_VM_OCC/OSSV Backup/0/0,null,NJ-VM-OCC,OSSV Backup)

(7,null,NJ_VM_OCC/OSSV Backup/0/0,null,NJ-VM-OCC,OSSV Backup)

(8,null,NJ_VM_OCC/OSSV Backup/0/0,null,NJ-VM-OCC,OSSV Backup)

(9,null,NJ_VM_OCC/OSSV Backup/0/0,null,NJ-VM-OCC,OSSV Backup)

Warning for c-mode tables (profile 'cm-storage'):

Duplicate rows found for cache table cm_storage_logical_interface,

columns: (id,home_port,routing_group_name,address,status,vserver_id,name,home_node_id,current_port,role,current_node_id,netmask)

rows:

(21891,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37263,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37284,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37303,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37316,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37323,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37330,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37349,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37356,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37373,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37386,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37399,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37406,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37419,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37443,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37450,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37463,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37484,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37503,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37510,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37523,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37530,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37537,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37550,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37557,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37570,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37594,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37607,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37624,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37632,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37645,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37672,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37694,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37701,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37714,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37727,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37763,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37785,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37800,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37813,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37820,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37833,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37840,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37855,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37868,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37887,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37900,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37913,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37920,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37927,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37951,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37964,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37971,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(37978,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(38008,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(38021,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(38028,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(38061,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(38074,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(38081,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

(38094,e0a,null,172.16.24.75,Up,14782,clus1,14782,e0a,cluster,14782,255.255.0.0)

Re: Warnings from WFA about DFM/OnCommand data.

Hi Phil,

These warnings are issued when redundant historical data has been pulled from DFM.

They report on data being rejected by WFA and do not have any negative impact on WFA and OC databases.

Actually, such warnings will be removed from the next version.

I'll reach to you offline so I can see if we can prevent from this redundant historical data to be pulled out of DFM.

Thanks,

Michael