Unable to get value for field SRCID when running custom report in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2019-06-11
Article Number
000044098
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.
 

Related Articles

Trending Articles

Don't see what you're looking for?