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
- Login to the vRA IaaS MSSQL database using SQL Management Studio.
- Select the vRealize Automation database.
- Run the below query:
UPDATE dbo.VirtualMachineProperties
SET PropertyValue = ''
WHERE PropertyValue = NULL
- Request the Bulk Export.
Feedback
thumb_up
Yes
thumb_down
No