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)
I figured out the problem.. When selecting the is_disabled attribute for accounts the output from your query needs to be 1 or 0. I was selecting Y or N.