"Something went wrong" error adding devices to maintenance schedule after CU rollback in DXUIM

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are unable to add devices to the maintenance schedule in the Operator Console. When we attempt to add a device, a "something went wrong" message appears.
We recently attempted an upgrade to CU6 which was rolled back to CU4 due to technical issues. 

In the operatorconsole.log, the following error is captured:

ERROR com.firehunter.operatorconsole.controller.MaintenanceScheduleController:addMaintenanceSystems:236 controller.MaintenanceScheduleController - Exception caught while adding Maintenance System Received status (120) on response (for sendRcv) for cmd = 'add_computer_systems_to_schedule'

Also, UIMAPI maintenance schedules calls fail after rollback from CU6.  500 server errors when using the UIM API or the Operator Console (OC) to add devices to maintenance schedules.

Environment

• DX UIM Version : 23.4 CU4 (reverted from CU6)
• Operator Console (OC): 23.4 CU4
• UIM API: 23.4.4
• maintenance_mode probe: CU4 compatible version

Cause

A schema mismatch or data inconsistency in the database, potentially caused by a database rollback to an earlier version where the application expected a different schema structure.

The issue is caused by a database schema mismatch. The upgrade to CU6 introduced DDL changes (new columns) to the maintenance_schedule and maintenance_window tables. Because the rollback was performed at the application/VM snapshot level but not at the database level, the CU4 code is encountering unexpected schema structures, leading to internal server errors during SQL operations.

Resolution

Rollbacks aren't supported or tested. In case of a similar schema mismatch, open a support case with Broadcom to have the environment/schema and MAINTENANCE RELATED TABLES checked and schema merged manually with the supervision of Broadcom.