Not Seeing Maintenance Schedules in Operator Console

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are not seeing the maintenance schedules in the Operator Console and seeing the error "No Schedules are defined".

Also seeing the issue even after upgrading to latest UIM version 23.4 CU 2

Environment

UIM 23.4.x

Resolution

Using uimapi to add maintenance schedules 

During analysis noticed data inconsistency in recurrence_days_of_the_week column where it started with , or 1,

Valid values for the column RECURRENCE_DAYS_OF_THE_WEEK are:

- Comma-separated list of integers 1 to 7 representing the days of the week (1 is Sunday, 7 is Saturday)

To fix this 

Find the incorrect entries 

select RECURRENCE_DAYS_OF_THE_WEEK from maintenance_schedule where recurrence_days_of_the_week like '%1%'

 

Update/Correct the incorrect entries from the list 

example

update MAINTENANCE_SCHEDULE set RECURRENCE_DAYS_OF_THE_WEEK = 1 where SCHEDULE_ID in (<repace with the incorrect schedule_id's returned from the maintenance_schedule>)

To prevent this issue from recurring 

While creating the maintenance schedules, if the schedule is for saturday and sunday, suggestion is to set the duration to 48 hours with recurrence day of the week as saturday instead of saturday,sunday.

Additional Information

Schedules not shown in OC: Exception caught while maintenance schedules