000037614 - Unable to get value for field SRCID when running custom report in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 11, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037614
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.x

 
IssueRunning 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)
CauseThis 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. 
ResolutionThe 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.
WorkaroundRemove the reference to column SRCID.
 

Attachments

    Outcomes