Article Number
000037614
Applies To
RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.x
Issue
Running a custom report in RSA Identity Governance & Lifecycle fails with the following error:
net.sf.jasperreports.engine.JRException: Unable to get value for field 'SRCID' of class 'java.lang.Integer'
at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:328)
at com.aveksa.server.report.DataSource.getFieldValue(DataSource.java:241)
at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:1358)
at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1259)
at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1235)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1614)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:150)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:963)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:892)
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:114)
at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:668)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:984)
at com.aveksa.server.report.Report.fillReport(Report.java:2056)
at com.aveksa.server.report.Report.fillReportWCleanup(Report.java:1963)
at com.aveksa.server.report.Report.fillReport(Report.java:1694)
at com.aveksa.server.report.Report.fillReport(Report.java:1680)
at com.aveksa.server.report.ReportRunnerTask.process(ReportRunnerTask.java:113)
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: java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4170)
Cause
This error occurs when a report references table T_DC_SOURCEDATA_USER and the column value in SRCID is greater than a certain size. In this case the value 012345678901 caused this failure.
Resolution
The resolution is to remove the reference to table T_DC_SOURCEDATA_USER from the report as that is one of our internal tables and should not be accessed. Use only tables defined in the
Public Database Schema Reference Guide for your version of RSA Identity Governance & Lifecycle.
If there is no table in the Public Database Schema Reference Guide that will give you the report that you require, please go to
RSA Link RSA Ideas for RSA Identity Governance & Lifecycle to submit an enhancement request. For more information, please see
How to log a request for enhancement (RFE) for RSA Identity Governance & Lifecycle.
Workaround
Remove the reference to column SRCID.
