When attempting to schedule CABI reports in UIM 20.3.x, the last run field never updates.
Release : 20.3 or higher
Component : UIM - CABI
Defects in database tables have been identified and the below resolution addresses these problems.
To fix the "last run" problem, take the following steps:
ALTER TABLE QRTZ_FIRED_TRIGGERS ADD SCHED_TIME BIGINT;
UPDATE QRTZ_FIRED_TRIGGERS SET SCHED_TIME = FIRED_TIME;
ALTER TABLE QRTZ_FIRED_TRIGGERS ALTER COLUMN SCHED_TIME BIGINT NOT NULL;
Note: you must run these one at a time, if you run them all at once you get this error
Getting "Invalid column name 'SCHED_TIME'" Error After Upgrading TIBCO JasperReports® Server from version 7.1 to 7.5
It is also highly recommended that customers deactivate any existing report jobs that were migrated from the previous version of CABI and re-create them in the newer version of CABI.
After deactivating the previous schedules, you should see that any Reports loading delays/issues or the initial view of reports from the "Reports" tab load in a reasonable amount of time.