Issue | - The collector fails during the first task of data collection.
- The raw data and database logs of the run are empty.
- The aveksaServer.log shows the following error at the time of the failure:
05/30/2018 14:32:31.820 ERROR (Exec Task Consumer#1) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=50 RunID=28 Source=3 Type=DataObjectProcessing Status=InProgress] com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number ORA-06512: at "AVUSER.IDC_NORMALIZE", line 203 ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 105 ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 195 ORA-06512: at line 1
at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeFullTask(DataObjectProcessingExecutor.java:121) at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeTask(DataObjectProcessingExecutor.java:58) 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:748) Caused by: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number ORA-06512: at "AVUSER.IDC_NORMALIZE", line 203 ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 105 ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 195 ORA-06512: at line 1
at com.aveksa.server.xfw.DefaultIdentityObjectDataFilter.loadData(DefaultIdentityObjectDataFilter.java:134) at com.aveksa.server.xfw.DefaultIdentityObjectDataFilter.process(DefaultIdentityObjectDataFilter.java:71) at com.aveksa.server.xfw.DefaultIdentityObjectDataFilter.process(DefaultIdentityObjectDataFilter.java:144) at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:85) at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:64) at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeFullTask(DataObjectProcessingExecutor.java:116) ... 4 more Caused by: com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number ORA-06512: at "AVUSER.IDC_NORMALIZE", line 203 ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 105 ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 195 ORA-06512: at line 1
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:267) at com.aveksa.server.xfw.DefaultIdentityObjectDataFilter.loadData(DefaultIdentityObjectDataFilter.java:116) ... 11 more Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number ORA-06512: at "AVUSER.IDC_NORMALIZE", line 203 ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 105 ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 195 ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ... 15 more
Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the log files for your specific deployment. |