Upgrade failing on step 9 of 14 [run master postgres db upgrade] due to "index row size # exceeds btree version 4 maximum"

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

Upgrade of Aria Operations failing on step 9 of 14 with "run master postgres db upgrade".

In the /storage/vcops/log/centralsqldbupgrade.log:

Caused by: java.sql.BatchUpdateException: Batch entry 204 INSERT INTO dynamic_attributes (adapter_kind, resource_kind, attribute_key, data_type, is_property) VALUES (('VMWARE'), ('VirtualMachine'), ('relation|connectedTo|APPCOMP|ApplicationComponent:IIS/, .........was aborted: ERROR: index row size 2760 exceeds btree version 4 maximum 2704 for index "dynamic_attributes_pkey"

Environment

VMware Aria Operations 8.x

Cause

This error is due to legacy data that is too large to fit within the internal Postgres database schema.

Resolution

Please contact Broadcom support for further troubleshooting and resolution.

Additional Information

Environments and data will differ so we cannot provide steps to resolve.