Cost calculation failure due to vRA VM tags

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:
vRBC cost calculation is failing due to this error in the itfm-server.log:

2018-02-07 16:50:38.829 ERROR [SystemSync-Persist Mappers] o.h.e.j.s.SqlExceptionHelper - ERROR: value too long for type character varying(4000)
2018-02-07 16:50:38.829 ERROR [SystemSync-Persist Mappers] o.h.e.j.b.i.BatchingBatch - HHH000315: Exception executing batch [could not execute batch]
2018-02-07 16:50:38.829 ERROR [SystemSync-Persist Mappers] c.v.i.c.c.s.j.SystemSynchronizationManager - could not execute batch; SQL [insert into itfm_cloud_admin.vra_vm_details_tags (category, value, uuid, month, tag_id) values (xxxxxxxxxxxxxx)...

Environment

VMware vRealize Business for Cloud Advanced 7.x

Cause

The Postgres database of vRealize Business fails to import the details for vRealize Automation virtual machine. This is due to the details of the virtual machine exceeding 4000 characters. Only after a cost calculation, the vRealize Business attempts to enter it into the Postgres DB, and it will repeatedly fail until you implement the fix.

Resolution

This is a known issue affecting vRealize Business for Cloud Advanced 7.x.

Currently, there is no resolution or workaround.

Additional Information

To be alerted when this article is updated, click the subscribe button [cid:[email protected]] . For more information on KB subscription features, see the Knowledge Base Article FAQs: How to Subscribe to VMware Knowledge Base Articles (76417).