Active IQ Unified Manager Discussions

WFA 4.2: Create datasource fails

skellner
4,032 Views

I'm trying to create a datasource in WFA 4.2 and it is not possible. When I try to create the dictionary entry I'm getting an unexpected error and have to refresh my browser so that I can't save the entry. In the datasource section I'm getting an empty error message window. I attach both screenshots. Any help is appreciated. Thanks in advance.

1 REPLY 1

skellner
3,868 Views

It seems to be an error in my database related to ocum data. In wfa.log I see tons of these error messages for a lot of entries. Does someone have an idea how to eliminate the duplicate entries?

 

    SQLWarning: reason(Duplicate entry 'array-17.249.25.35' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'array-17.249.26.17' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'array-17.249.26.18' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)

...

 

    SQLWarning: reason(Duplicate entry 'disk_aggregate-95407_99136' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95407_99163' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95408_99405' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95408_99407' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95408_99679' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95408_99715' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95409_99351' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95409_99433' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95409_99511' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95409_99533' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95410_99801' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95410_99838' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95410_100062' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'disk_aggregate-95410_100096' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
2018-06-18 13:21:35,661 WARN  [com.netapp.wfa.util.SqlShell] (Thread-2314 (HornetQ-client-global-threads-2051617050)) <localhost> Executed: INSERT IGNORE INTO wfa_staging.object_global_cm_storage SELECT null, 'cluster_peer', CONVERT(CONCAT_WS('_', UPPER(t.peer_cluster_id),UPPER(t.primary_cluster_id)), CHAR), 19 FROM wfa_staging.cm_storage_cluster_peer t
    SQLWarning: reason(Duplicate entry 'cluster_peer-4_5' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-4_17' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-5_4' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-5_16' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-6_7' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-6_16' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-6_17' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-7_6' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-7_16' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-7_17' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-8_9' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-8_19' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-9_8' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-9_18' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-10_11' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-10_19' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)
    SQLWarning: reason(Duplicate entry 'cluster_peer-11_10' for key 'uk_type_natural_key') SQLstate(23000) vendor code(1062)

Public