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

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

book

Article ID: 386677

calendar_today

Updated On:

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.