Not able to send scheduled reports from CABI 7.5.
It is a bug identified by TIBCO in jasper server 7.5.0
and it happens only for some occasions during upgrade.
Release : 20.3
Component : UIM - CABI
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;