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

[#1]

Article Number

000037106

Applies To

RSA Product Set:  Identity Governance & Lifecycle
RSA Version/Condition: 7.0.0,7.0.1,7.0.2,7.1.0
 

Issue

All 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.

Image description

Image description

Image description

Image description

Image description

Image description

Image description


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)

Cause

This 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.

Resolution

Deploy patch 7.0.2 P11 or 7.1.0 P05 to have this issue fixed.