Unable to get value for field SRCID when running custom report in RSA Identity Governance & Lifecycle
Originally Published: 2019-06-11
Article Number
Applies To
RSA Version/Condition: 7.x
Issue
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
Resolution
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
Related Articles
AAOP in tomcat 6 'Unable to connect to the DB connection for the image service'<DATASTORE_ERROR ' Unable to get DB connect… 93Number of Views How to set PINs and navigate Next Tokencode Mode for RSA SecurID Tokens using NTRadPing on SecurID Authentication Manager … 167Number of Views Unification fails with ORA-30926: unable to get a stable set of rows in the source tables, ORA-06512: at "AVUSER.UNFC_PROC… 150Number of Views Unification fails with ORA-30926: unable to get a stable set of rows in the source tables at 'AVUSER.UNFC_PROCESSOR', line… 543Number of Views ORA-30926: 'Unable to get a stable set of rows in the source tables' at AVUSER.ARCHIVEPURGE_PKG line 839 creating an arch… 190Number of Views
Trending Articles
Using Vault instead of cleartext password in WildFly configuration file in RSA Identity Governance & Lifecycle Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Unable to login to RSA Authentication Manager Security Console as super admin Quick Setup of a Replica Instance fails the attach to the Primary Instance
Don't see what you're looking for?