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:?]
Aria Operations 8.x
This error is due to missing data in the Postgres database.
Please contact Broadcom support for further troubleshooting and resolution.
Environments and data will differ so we cannot provide steps to resolve.