UPS nodes are not retrieving data to the GUI causing alerts not to fire and widgets are unable to show metrics, post 2023.2.0 upgrade.

lloyd267

We noticed the majority of our UPS devices were not displaying any data in the widgets, instead we were seeing 'Data Not available'. When checking the SWQL table Cortex.Orion.PowerControlUnit we seen there was recent polled data in there. Then eventually we discovered that the OrionNodeID value was NULL for each UPS device that was not displaying any data. We are fairly certain this was caused by the upgrade to v2023.2.0.

Solution

 In database manager you can run the following SQL command to align the UPS node back to its related OrionNodeID 

UPDATE Ctx_C_Orion_PowerControlUnitData_man_1
SET OrionNodeID=(SELECT Ctx_C_Orion_PowerControlUnitData_poll_1.[Node.ID] FROM Ctx_C_Orion_PowerControlUnitData_poll_1 WHERE Ctx_C_Orion_PowerControlUnitData_man_1.ID=Ctx_C_Orion_PowerControlUnitData_poll_1.ID)

Thanks

lloyd267

We have come to realise this is also happening when a failover event occurs on the MPE's, ever since we upgraded to 2023.2.0

Support Case: #01444949