search cancel

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

book

Article ID: 216624

calendar_today

Updated On:

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

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.