Unable to Bulk Add Data Sources in VCF Operations for Networks

Products

VCF Operations for Networks

Issue/Introduction

You are trying to bulk add data sources in VCF Operations for Networks and you are getting a generic error that "Something went wrong...".

However, you are able to add a single device manually with the same information.

Collector logs show authentication issue

2025-02-13T17:09:57.673Z ERROR dataprovider.utils.ResultCodeUtils collector-process-msg-exec-910 getDPResultCode:734 Could not determine exact error code for: ARISTASWITCH, com.jcraft.jsch.JSchException: Auth cancel for methods 'publickey,keyboard-interactive'

2025-02-13T17:09:57.674Z ERROR core.common.DataProviderFactory collector-process-msg-exec-910 validateCredentials:1025 Validation failed with: Error in connecting to: ###.###.###.### for: ARISTASWITCH Root Cause: com.jcraft.jsch.JSchException: Auth cancel for methods 'publickey,keyboard-interactive' retErrorCode: FAILED com.vnera.dataproviders.dsconnectionmanagement.exceptions.ConnectionStartException: Error in connecting to: ###.###.###.###

2025-02-13T17:09:57.674Z WARN core.common.DataProviderFactory collector-process-msg-exec-910 validateCredentials:1041 Total time for validation in millis: 182 for: ARISTASWITCH

If you are attempting to bulk upload physical switches as data sources, you may see this error in TACACs.

NOTE: VCF Operations for Networks was formerly named Aria Operations for Networks (AON), and prior to that was named vRealize Network Insight (vRNI).

Environment

vRealize Network Insight 6.9
vRealize Network Insight 6.10.0
Aria Operations for Networks 6.11.0
Aria Operations for Networks 6.12.0
Aria Operations for Networks 6.12.1
Aria Operations for Networks 6.13.0
Aria Operations for Networks 6.14.0
Aria Operations for Networks 6.14.1

Cause

The most common cause of these symptoms is that one or more of the password strings contain(s) special characters which causes issues when authenticating to the device

Resolution

To edit the CSV file for bulk upload, use a plain text editor such as Notepad++ (Windows), Visual Studio Code, Sublime Text, Vim, or standard Notepad/TextEdit.

Avoid using rich spreadsheet applications like Microsoft Excel or Apple Numbers to edit or save the file.

These programs often automatically reformat data, drop leading zeros from IP addresses, or convert standard straight double quotes (") into smart or curly quotes (“ ”).
This automatic formatting modification will cause the VCF Operations for Networks CSV parser to fail validation.

In the password column of your CSV file, add double quotes around the password.

When saving the file:

Ensure the file extension remains strictly .csv.
Verify the character encoding is set to UTF-8.
Confirm that the passwords containing special characters remain enclosed within standard straight double quotes (e.g., "###########") where ########### is the entire password including all special characters that you have in the password.