Problem is resolved in vRealize Automation 7.5 version and higher.
Workaround:
- Create a full IaaS database backup using Microsoft SQL Server Management Studio or sqlcmd before updating with the queries below.
- Update VirtualMachineProperties table:
update vmp
set PropertyValue = 'null_value'
from [dbo].[VirtualMachine] vm
join [dbo].[VirtualMachineProperties] vmp
on vmp.EntityID = vm.VirtualMachineID
where vmp.PropertyValue is null
- Test the CloudClient or portal export again.
Revert query provided below:
update vmp
set PropertyValue = null
from [dbo].[VirtualMachine] vm
join [dbo].[VirtualMachineProperties] vmp
on vmp.EntityID = vm.VirtualMachineID
where vmp.PropertyValue = 'null_value'