Scheduled custom reports are intermittently failing and generating blank reports in RSA Identity Governance & Lifecycle
Originally Published: 2017-11-20
Last Modified: 2023-11-30
Article Number
Applies To
RSA Version/Condition: All versions
Issue
Sometimes, all of these scheduled custom reports run and complete successfully. However, one or two of these scheduled custom reports occasionally fail with ORA-00942: table or view does not exist, hence generating blank reports for download in the UI or sent out to its recipients.
You do not encounter this issue if you manually run these custom reports in the RSA Identity Governance & Lifecycle UI (Reports > Tabular).
---------------------------
aveksaServer.log
---------------------------
Search for "Failed to generate the report." errors, and you will notice the intermittent failures which occurred due to exception ORA-00942: table or view does not exist :
10/01/2017 08:00:15.470 ERROR (ThreadPool-4) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="342" name="Leavers - FTE"], ReportResult[id="2742", report-id="342", save-date="null", fill-start-date="Sun Oct 01 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/01/2017 08:00:15.485 ERROR (ThreadPool-2) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="359" name="Movers - FTE"], ReportResult[id="2744", report-id="359", save-date="null", fill-start-date="Sun Oct 01 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/01/2017 08:00:15.548 ERROR (ThreadPool-6) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="341" name="Leavers- Contractor"], ReportResult[id="2747", report-id="341", save-date="null", fill-start-date="Sun Oct 01 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/14/2017 08:00:09.497 ERROR (ThreadPool-8) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="341" name="Leavers- Contractor"], ReportResult[id="2941", report-id="341", save-date="Sat Oct 14 08:00:08 HKT 2017", fill-start-date="Sat Oct 14 08:00:00 HKT 2017", status="Completed", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/14/2017 08:00:09.497 ERROR (ThreadPool-7) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="359" name="Movers - FTE"], ReportResult[id="2937", report-id="359", save-date="Sat Oct 14 08:00:08 HKT 2017", fill-start-date="Sat Oct 14 08:00:00 HKT 2017", status="Completed", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/14/2017 08:00:09.497 ERROR (ThreadPool-0) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="459" name="Rehire - FTE"], ReportResult[id="2940", report-id="459", save-date="Sat Oct 14 08:00:08 HKT 2017", fill-start-date="Sat Oct 14 08:00:00 HKT 2017", status="Completed", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/17/2017 08:00:06.632 ERROR (ThreadPool-2) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="379" name="Joiners - FTE"], ReportResult[id="2982", report-id="379", save-date="null", fill-start-date="Tue Oct 17 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/17/2017 08:00:06.662 ERROR (ThreadPool-6) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="359" name="Movers - FTE"], ReportResult[id="2983", report-id="359", save-date="null", fill-start-date="Tue Oct 17 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/17/2017 08:00:06.731 ERROR (ThreadPool-0) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="339" name="Joiners- Contractor"], ReportResult[id="2980", report-id="339", save-date="null", fill-start-date="Tue Oct 17 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/19/2017 08:00:05.994 ERROR (ThreadPool-9) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="341" name="Leavers- Contractor"], ReportResult[id="3021", report-id="341", save-date="null", fill-start-date="Thu Oct 19 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ... 10/22/2017 08:00:06.377 ERROR (ThreadPool-2) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="341" name="Leavers- Contractor"], ReportResult[id="3060", report-id="341", save-date="null", fill-start-date="Sun Oct 22 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ...
For more information about the exception, see the error stack trace below:
10/01/2017 08:00:15.470 ERROR (ThreadPool-4) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="342" name="Leavers - FTE"], ReportResult[id="2742", report-id="342", save-date="null", fill-start-date="Sun Oct 01 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at com.aveksa.server.report.Report.fillReport(Report.java:1677) at com.aveksa.server.report.Report.fillReport(Report.java:1654) at com.aveksa.server.report.ReportRunnerTask.process(ReportRunnerTask.java:119) at com.aveksa.server.scheduler.ScheduledTask$Executor.execute(ScheduledTask.java:159) at com.aveksa.common.ThreadPool$Executor.run(ThreadPool.java:141) at java.lang.Thread.run(Thread.java:748) 10/01/2017 08:00:15.483 ERROR (ThreadPool-2) [com.aveksa.server.report.Report] SQL: SELECT * FROM (select DISTINCT ... from avuser.PV_USERS tMEU WHERE tMEU.IDENTITY_SOURCE = 'HR' ... 10/01/2017 08:00:15.483 ERROR (ThreadPool-2) [com.aveksa.server.report.Report] Error in fillReport com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at com.aveksa.server.report.Report.fillReport(Report.java:2018) at com.aveksa.server.report.Report.fillReport(Report.java:1665) at com.aveksa.server.report.Report.fillReport(Report.java:1654) at com.aveksa.server.report.ReportRunnerTask.process(ReportRunnerTask.java:119) at com.aveksa.server.scheduler.ScheduledTask$Executor.execute(ScheduledTask.java:159) at com.aveksa.common.ThreadPool$Executor.run(ThreadPool.java:141) at java.lang.Thread.run(Thread.java:748) Caused by: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at com.aveksa.server.report.ReportResultTableExporter.getFieldValue(ReportResultTableExporter.java:80) ... 10/01/2017 08:00:15.485 ERROR (ThreadPool-2) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="359" name="Movers - FTE"], ReportResult[id="2744", report-id="359", save-date="null", fill-start-date="Sun Oct 01 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at com.aveksa.server.report.Report.fillReport(Report.java:1677) at com.aveksa.server.report.Report.fillReport(Report.java:1654) at com.aveksa.server.report.ReportRunnerTask.process(ReportRunnerTask.java:119) at com.aveksa.server.scheduler.ScheduledTask$Executor.execute(ScheduledTask.java:159) at com.aveksa.common.ThreadPool$Executor.run(ThreadPool.java:141) at java.lang.Thread.run(Thread.java:748) 10/01/2017 08:00:15.545 ERROR (ThreadPool-6) [com.aveksa.server.report.Report] SQL: SELECT * FROM (select DISTINCT tMEU.FIRST_NAME as firstName ... from avuser.PV_USERS tMEU WHERE tMEU.IS_TERMINATED = 'True' ... 10/01/2017 08:00:15.545 ERROR (ThreadPool-6) [com.aveksa.server.report.Report] Error in fillReport com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at com.aveksa.server.report.Report.fillReport(Report.java:2018) at com.aveksa.server.report.Report.fillReport(Report.java:1665) at com.aveksa.server.report.Report.fillReport(Report.java:1654) at com.aveksa.server.report.ReportRunnerTask.process(ReportRunnerTask.java:119) at com.aveksa.server.scheduler.ScheduledTask$Executor.execute(ScheduledTask.java:159) at com.aveksa.common.ThreadPool$Executor.run(ThreadPool.java:141) at java.lang.Thread.run(Thread.java:748) Caused by: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at com.aveksa.server.report.ReportResultTableExporter.getFieldValue(ReportResultTableExporter.java:80) ... 10/01/2017 08:00:15.548 ERROR (ThreadPool-6) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="341" name="Leavers- Contractor"], ReportResult[id="2747", report-id="341", save-date="null", fill-start-date="Sun Oct 01 08:00:00 HKT 2017", status="InProgress", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"] com.aveksa.server.runtime.ServerException: net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at com.aveksa.server.report.Report.fillReport(Report.java:1677) at com.aveksa.server.report.Report.fillReport(Report.java:1654) at com.aveksa.server.report.ReportRunnerTask.process(ReportRunnerTask.java:119) at com.aveksa.server.scheduler.ScheduledTask$Executor.execute(ScheduledTask.java:159) at com.aveksa.common.ThreadPool$Executor.run(ThreadPool.java:141) at java.lang.Thread.run(Thread.java:748)
Cause
Resolution
To resolve this issue, modify the scheduled start time of these custom reports to have at least 5-10 minute intervals before the next one starts running.
Related Articles
Cannot avoid circuit breaker abort for scheduled Identity Data Collector (IDC) collections in RSA Identity Governance & Li… Number of Views Cancel all Scheduled Occurrences of a Log Archive Job Number of Views Web Services updateReviewItems 'Entitlement XXX already in the same state' message does not display account name in RSA Id… Number of Views Schedule a Recurring Report Job Number of Views Scheduled backups fail and Backup Now fails with 'A replication or backup task is in progress' in RSA Authentication Manag… Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
