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