Scheduled CABI reports in UIM 20.3.x never report a last run date
Article ID: 204408
Updated On:
Products
Issue/Introduction
When attempting to schedule CABI reports in UIM 20.3.x, the last run field never updates.
Environment
Release : 20.3 or higher
Component : UIM - CABI
Cause
Defects in database tables have been identified and the below resolution addresses these problems.
Resolution
To fix the "last run" problem, take the following steps:
- Login to database using any sql client
- Take a backup of "QRTZ_FIRED_TRIGGERS" table
- And then execute the below SQL commands:
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
Additional Information
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.
Feedback
