DB Maintenance: Rebuild Index Task always fails on OperationsManagerDW [SCOM database]

Problem Description ======================================= We encountered a situation where we were trying to execute a maintenance plan to rebuild the index of OperationsManagerDW database. However, the maintenance plan fails to complete.   In the Maintenance Plan log, the following paragraph was found: Rebuild Index Task (<instance_name>) Rebuild index on Local server connection Databases that have a…