unable to send Scheduled reports from CABI

Products

• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• NIMSOFT PROBES
• DX Infrastructure Management

Issue/Introduction

Not able to send scheduled reports from CABI  7.5.

 

 

Cause

It is a bug identified by TIBCO in jasper server 7.5.0
and it happens only for some occasions during upgrade.

Environment

Release : 20.3

Component : UIM - CABI

Resolution

Follow below 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;