API calls being made to retrieve ITEMS in vRA failing with Data Serialization error Unknown name value for enum class com.vmware.vcac.catalog.domain.enumeration.ResourceStatus

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• Trying to access vRO's vRA Plugin Inventory and expand ITEMS object this get's stuck does not return any values back.
• If this code to query vRa items is included in a workflow that fails with a data serialization error:

InternalError: Data serialization error

• /var/log/vmware/vcac/catalina.out logfile on vRA appliance has an InvalidDataAccessApiUsageException error similar to:
  
  [ERROR]: org.springframework.dao.InvalidDataAccessApiUsageException: Unknown name value [DELETE] for enum class [com.vmware.vcac.catalog.domain.enumeration.ResourceStatus]; nested exception is java.lang.IllegalArgumentException: Unknown name value [DELETE] for enum class [com.vmware.vcac.catalog.domain.enumeration.ResourceStatus]

Environment

vRealize Automation 7.x

Cause

The issue can occurr when a deployment or Virtual machine has its status column in the cat_resource table of the postgres database set to an invalid value.

For instance in the example error message above the value 'DELETE' was in the status column instead of the correct value 'DELETED'.

Typically this issue occurrs after manual manipulation of the database so please advise caution and review any procedures or processes in place that may be responsible.

Resolution

A database review is necessary to resolve this matter. Please reach out to Broadcom Support for further assistance.