Active IQ Unified Manager Discussions

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Active IQ Unified Manager Discussions

Ask a Question

Warnings from WFA about DFM/OnCommand data.

bachman
NetApp
‎2012-05-14 01:31 PM
2,482 Views

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)

0 Kudos
View By:
1 REPLY 1

yakobi
NetApp
‎2012-05-15 06:20 AM
2,482 Views

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

0 Kudos
Announcements
All Community Forums
Public