12/22/2017 07:28:25.097 ERROR (Exec Task Consumer#4) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=69651 RunID=60155 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-00918: column ambiguously defined ORA-06512: at "AVUSER.IDC_NORMALIZE", line 220 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:119) 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:745) Caused by: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined ORA-06512: at "AVUSER.IDC_NORMALIZE", line 220 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-00918: column ambiguously defined ORA-06512: at "AVUSER.IDC_NORMALIZE", line 220 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.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1601) at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1459) at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:267) at com.aveksa.server.xfw.DefaultIdentityObjectDataFilter.loadData(DefaultIdentityObjectDataFilter.java:116) ... 9 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined ORA-06512: at "AVUSER.IDC_NORMALIZE", line 220 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) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404) at com.aveksa.server.db.persistence.PersistenceServiceProvider.executeCallableStatement(PersistenceServiceProvider.java:1636) at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1564) ... 12 more 12/22/2017 07:28:25.113 INFO (Exec Task Consumer#4) [com.aveksa.server.xfw.TaskExecutor] UNSetting thread on 1039369892 method=Execute |
The symptoms seem to match with the following KB article, see if it applies to your issue:
000035105 - Identity Data Collector (IDC) collection fails with the error: "ORA-00918: column ambiguously defined" during the Identity Data Collection/Identity Data Unification step in RSA Identity Governance & Lifecycle