Reports failing with error "net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number" in RSA Identity Governance & Lifecycle
3 years ago
Originally Published: 2019-01-17
Article Number
000042033
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.

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

Related Articles

Trending Articles

Don't see what you're looking for?