CABI reports not emailed due to jaspersoft error - Invalid column name 'SCHED_TIME'

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• Unified Infrastructure Management for Mainframe
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

I am scheduling the CABI reports and email to the recipients. But I don't see the emails are triggering. Followed the below KB article. From the cabi server I am able to telnet the SMTP server port successfully. 

https://knowledge.broadcom.com/external/article/203516/where-is-the-smtp-email-setting-for-sche.html 

Environment

• Release: 20.3 or higher
• Component: UIM - CABI

Cause

• jaspersoft issue/error

Resolution

Based on the error, which you can find in the jaspersoft community (CABI) via google search,

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

java.sql.SQLSyntaxErrorException: [TibcoSoftware][SQLServer JDBC Driver][SQLServer]Invalid column name 'SCHED_TIME'.

Please run this statement on your CA UIM database.

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;

Then try scheduling and emailing the report again.