vRealize Business cost calculation is in red due to a snapshot creation failure

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• When vRealize Business for Cloud Standard (vRB) 7.0.1 setup is registered with vRealize Automation (vRA) 7.x, vRA data collection happens in vRB.
• Next cost calculation after vRA data collection fails.
• Cost calculation goes to red.
• In the itfm_sever.log file entries, you see that snapshot creation has failed.

Environment

VMware vRealize Business for Cloud Advanced 7.x
VMware vRealize Business for Cloud Standard 7.x

Cause

This issue ocurs because vRA data collector add rogue updates for certain entities in the facts_repo journal, where the entityId field is null.

Resolution

To resolve this issue:

1. Log in to the vRB VA.
2. Stop all the services by running this command:
   
   monit stop all
    
3. Take a backup of the journal and markers by running these commands:
   
   cd /
   mv journal journal_old
   mv VCENTER_TAGGING_MARKER VCENTER_TAGGING_MARKER_OLD
   mv VC_STATS_MARKERS VC_STATS_MARKERS_OLD
    
4. Start the services by running this command:
   
   monit start all
   
   VC and vRA collection happens again and the subsequent cost calculation succeeds.
   
   Note: On certain vRA setups it is observed that the rogue updates are sent everytime the vRA collection happens resulting in cost calculation failing everytime.

To delete the journal:

1. Run the monit stop all command to stop all the services.
2. Run these commands to rename the journal folders and markers folders:
   
   cd /
   mv journal journal_old
   mv VCENTER_TAGGING_MARKER VCENTER_TAGGING_MARKER_OLD
   mv VC_STATS_MARKERS VC_STATS_MARKERS_OLD
    
3. Run the monit start all command to start all the services.