unable to send Scheduled reports from CABI

book

Article ID: 205768

calendar_today

Updated On:

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;