Active IQ Unified Manager Discussions

WFA 4.2: Create datasource fails

skellner

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

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)

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.

Public