on Jan 29, 2019Article Content
| 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.        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. |