search cancel

Scheduled CABI reports in UIM 20.3.x never report a last run date

book

Article ID: 204408

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

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

https://community.jaspersoft.com/wiki/getting-invalid-column-name-schedtime-error-after-upgrading-tibco-jasperreports-server-version

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.

Attachments