Environment

Server Automation (SA) 2022.11, no rollup has been installed on yet.
Database version in use is Oracle 19c.

Situation

After the last step of secondary core installation is done, a large number of transactions built up and unable to send from primary core to secondary core. View from mesh state will look like this:

Excerpt in secondary core's /var/log/opsware/vault.0.log:

2024-05-01 07:05:35,150 INFO Thread-40 [com.loudcloud.vault.Transaction] [processTransaction] Transaction 78022570001 caused 'ORA-08102: index key not found, obj# 71702, file 7, block 36515 (2)
'.
2024-05-01 07:05:35,152 WARNING Thread-40 [com.loudcloud.vault.Util] [sendMessage] Cannot send message. Missing value for config parameter sendMMErrorsFrom
2024-05-01 07:05:35,153 WARNING Thread-40 [com.loudcloud.vault.Transaction] [processTransaction] Transaction 78022570001 caused 'ORA-08102: index key not found, obj# 71702, file 7, block 36515 (2)
'. Sleeping 60000ms and retrying...
2024-05-01 07:05:50,736 INFO Thread-30 [com.loudcloud.vault.Sender] [getTransactions] QUERIED THE DATABASE rows_count:0
2024-05-01 07:06:10,739 INFO Thread-30 [com.loudcloud.vault.Sender] [getTransactions] QUERIED THE DATABASE rows_count:0

Read the knowledge article for cause and resolution