Requesting a bulk export fails with the error "An error occurred while creating export: Value cannot be null. Parameter name: stringToEscape"
search cancel

Requesting a bulk export fails with the error "An error occurred while creating export: Value cannot be null. Parameter name: stringToEscape"

book

Article ID: 325928

calendar_today

Updated On:

Products

VMware Aria Suite

Issue/Introduction

Symptoms:
  • Requesting a Bulk Export fails with an error of  "An error occurred while creating export: Value cannot be null. Parameter name: stringToEscape"
  • The CSV file is not generated


Environment

VMware vRealize Automation 7.4.x

Cause

A NULL value exists within the table "VirtualMachineProperties" in the IaaS MSSQL database

Resolution

  1. Login to the vRA IaaS MSSQL database using SQL Management Studio.
  2. Select the vRealize Automation database.
  3. Run the below query:

UPDATE dbo.VirtualMachineProperties
SET PropertyValue = ''
WHERE PropertyValue = NULL

  1. Request the Bulk Export.