Upgrade failing on step 9 of 14 [run master postgres db upgrade]

Products

• VMware Aria Suite

Issue/Introduction

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

In the centralsqldbupgrade.log:

2025-01-15 07:25:45,715 ERROR [main] com.vmware.statsplatform.persistence.global.UserDataService.saveNotificationRules - Notification rule to plugin mapping relationship not found in DB.
2025-01-15 07:25:45,715 ERROR [main] .processJAVA - error:
java.lang.RuntimeException: Notification rule to plugin mapping relationship not found in DB.
        at com.vmware.statsplatform.persistence.global.UserDataService.saveNotificationRules(UserDataService.java:636) ~[persistence-1.0-SNAPSHOT.jar:?]
        at com.vmware.vcops.dbupgrade.postgres.centraldb.upgrade.v815.NotificationRuleTypeUpgrader.upgrade(NotificationRuleTypeUpgrader.java:32) ~[vcops-dbupgrade-1.0-SNAPSHOT.jar:?]
        at com.vmware.vcops.dbupgrade.postgres.centraldb.CentralSqlDbUpgrade.processJAVA(CentralSqlDbUpgrade.java:207) ~[vcops-dbupgrade-1.0-SNAPSHOT.jar:?]
        at com.vmware.vcops.dbupgrade.postgres.centraldb.CentralSqlDbUpgrade.upgradeControllerDB(CentralSqlDbUpgrade.java:263) ~[vcops-dbupgrade-1.0-SNAPSHOT.jar:?]
        at com.vmware.vcops.dbupgrade.postgres.centraldb.CentralSqlDbUpgrade.main(CentralSqlDbUpgrade.java:376) ~[vcops-dbupgrade-1.0-SNAPSHOT.jar:?]
2025-01-15 07:25:45,715 ERROR [main] .main - java.lang.RuntimeException: Notification rule to plugin mapping relationship not found in DB.
java.lang.RuntimeException: java.lang.RuntimeException: Notification rule to plugin mapping relationship not found in DB.
        at com.vmware.vcops.dbupgrade.postgres.centraldb.CentralSqlDbUpgrade.processJAVA(CentralSqlDbUpgrade.java:212) ~[vcops-dbupgrade-1.0-SNAPSHOT.jar:?]
        at com.vmware.vcops.dbupgrade.postgres.centraldb.CentralSqlDbUpgrade.upgradeControllerDB(CentralSqlDbUpgrade.java:263) ~[vcops-dbupgrade-1.0-SNAPSHOT.jar:?]
        at com.vmware.vcops.dbupgrade.postgres.centraldb.CentralSqlDbUpgrade.main(CentralSqlDbUpgrade.java:376) ~[vcops-dbupgrade-1.0-SNAPSHOT.jar:?]
Caused by: java.lang.RuntimeException: Notification rule to plugin mapping relationship not found in DB.
        at com.vmware.statsplatform.persistence.global.UserDataService.saveNotificationRules(UserDataService.java:636) ~[persistence-1.0-SNAPSHOT.jar:?]
        at com.vmware.vcops.dbupgrade.postgres.centraldb.upgrade.v815.NotificationRuleTypeUpgrader.upgrade(NotificationRuleTypeUpgrader.java:32) ~[vcops-dbupgrade-1.0-SNAPSHOT.jar:?]
        at com.vmware.vcops.dbupgrade.postgres.centraldb.CentralSqlDbUpgrade.processJAVA(CentralSqlDbUpgrade.java:207) ~[vcops-dbupgrade-1.0-SNAPSHOT.jar:?]

 

Environment

Aria Operations 8.x

Cause

This error is due to missing data in the Postgres database.

Resolution

Please contact Broadcom support for further troubleshooting and resolution.

Additional Information

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