AnsweredAssumed Answered

RSA Via L&G 7.0 ORA-01722: invalid number error when running account collector

Question asked by Ryan Godfrey on May 11, 2016
Latest reply on May 11, 2016 by Ryan Godfrey

I am trying to run an Oracle Account collector but I am receiving the following error after collecting Account Data. It looks like it occurs during the normalization step. I can view the account data and everything looks good in there. All accounts, mappings, groups, and account-groups mappings look good. I verified that all number fields in our source DB are in fact numbers.

 

com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-01722: invalid number

ORA-06512: at "AVUSER.ADC_NORMALIZE", line 148

ORA-06512: at "AVUSER.ADC_NORMALIZE", line 1275

ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 214

ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 447

ORA-06512: at line 1

at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1473)

at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1331)

at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:235)

at com.aveksa.server.xfw.DefaultAccountObjectDataFilter.loadData(DefaultAccountObjectDataFilter.java:104)

at com.aveksa.server.xfw.DefaultAccountObjectDataFilter.reProcess(DefaultAccountObjectDataFilter.java:88)

at com.aveksa.server.xfw.DataProcessor.reProcess(DataProcessor.java:121)

at com.aveksa.server.xfw.DataProcessor.reProcess(DataProcessor.java:107)

at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeReProcessTask(DataObjectProcessingExecutor.java:177)

at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeTask(DataObjectProcessingExecutor.java:60)

at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99)

at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.sql.SQLException: ORA-01722: invalid number

ORA-06512: at "AVUSER.ADC_NORMALIZE", line 148

ORA-06512: at "AVUSER.ADC_NORMALIZE", line 1275

ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 214

ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 447

ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)

at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4694)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)

at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1436)

Outcomes