Unable to generate CSV file to import virtual machines in vRA 7.x
search cancel

Unable to generate CSV file to import virtual machines in vRA 7.x

book

Article ID: 342575

calendar_today

Updated On:

Products

VMware Aria Suite

Issue/Introduction

This article gives information on how to use CloudUtil.exe to generate CSV file that is used to import virtual machines to a vRealize Automation deployment.

Symptoms:
  • When you click on Generate CSV File navigating to Infrastructure> Bulk Imports, you see an error:

    Error has occurred. For more information, see event logs on the IaaS server or contact your system administrator.
     
  • On the Windows IaaS machine event logs, you see entries similar to :

    System.ArgumentException: An item with the same key has already been added.

Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.


Environment

VMware vRealize Automation 6.2
VMware vRealize Automation 7.4.x
VMware vRealize Automation 6.x
VMware vRealize Automation Desktop 6.2.x
VMware vRealize Automation Desktop 6.2
VMware vRealize Automation 7.0.x
VMware vRealize Automation 7.3.x
VMware vRealize Automation 7.1.x
VMware vRealize Automation 7.5.x
VMware vRealize Automation 7.2.x
VMware vRealize Automation 6.2.x

Cause

This issue occurs when multiple tenants have blueprints in the same vRealize Automation instance or when the query to retrieve blueprints for bulk import returns duplicate entries.

Resolution


This issue is resolved in VMware vRealize Automation 7.4, available at VMware Downloads.
 
To work around this issue, use the cloudutil.exe to generate the CSV file:
  1. Download the cloudutil.exe included in the vRealize Automation Designer which can be obtained from the installer page on the vRealize Automation Appliance:

    https://vrealize-automation-appliance.fqdn:5480/installer

    Note: CloudUtil is the command line interface for the vRealize Automation Designer. You run the commands on the Windows machine on which you are running the designer. The default installation location on the Windows machine is C:\Program Files (x86)\VMware\vCAC\vRealize Automation Designer
     
  2. Generate the CSV file by running the command:

    CloudUtil.exe Machine-BulkRegisterExport

    For more information, see the Machine-BulkRegisterExport section in the vRealize Automation 7.0 Life Cycle Extensibility Guide .

    In the documentation, you can find the details to create a CSV data file that is used to import virtual machines to a vRealize Automation deployment under vRealize Automation 7.0 Information > Life Cycle Extensibility > CloudUtil Command Reference > Import Commands.
 


Additional Information

To be alerted when this document is updated, click the Subscribe to Article link in the Actions box.