The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

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.

NetApp Insights to Action
I2A Banner
Public