000037106 - Reports failing with error "net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number" in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jan 29, 2019Last modified by RSA Customer Support Employee on Jan 29, 2019
Version 6Show Document
  • View in full screen mode

Article Content

Article Number000037106
Applies ToRSA Product Set:  Identity Governance & Lifecycle
RSA Version/Condition: 7.0.0,7.0.1,7.0.2,7.1.0
 
IssueAll reports using the view PV_USER_ALL_ACCESS fail with the following error:
net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number"
 

This error occurs only when we have two custom value attributes of type Integer and String associated to the Business Source and Account attributes.

User-added image

User-added image

User-added image

User-added image

User-added image

User-added image

User-added image


The following error is in the aveksaServer.log:

at com.aveksa.server.report.DataSource.loadData(DataSource.java:155)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
10/15/2018 12:32:21.822 ERROR (default task-6) [com.aveksa.server.report.DataSource] Could not create DataSource java.sql.SQLSyntaxErrorException: ORA-01722: invalid number


at com.aveksa.server.report.DataSource.next(DataSource.java:253)
CauseThis is a defect. When PV_USER_ALL_ACCESS view used in reports, the comparison of a custom value number attribute with varchar value is failing and subsequently, the system throws a java.sql.SQLSyntaxErrorException: ORA-01722: invalid number.
ResolutionDeploy patch 7.0.2 P11 or 7.1.0 P05 to have this issue fixed.

Attachments

    Outcomes