Hi,
When i run DBUM Targer User Reconciliation ( Filtered recon) i am getting the below error in the log file.
We have created a target account with below privileges. are there any more permisssions required to run the target recon.
[2015-10-09T10:47:45.717-07:00] [oimext_server1] [NOTIFICATION] [] [oracle.iam.scheduler.vo] [tid: OIMQuartzScheduler_Worker-4] [userId: oiminternal] [ecid: 77744a889dde03de:-265ee4b8:15049ac7206:-8000-0000000000000004,1:18393] [APP: oim#11.1.2.0.0] Method details executeJob DBUM Oracle User Target Reconciliation
[2015-10-09T10:47:45.842-07:00] [oimext_server1] [WARNING] [] [ORG.IDENTITYCONNECTORS.DBUM.DBUMCONNECTOR] [tid: Thread-276] [userId: oiminternal] [ecid: 77744a889dde03de:-265ee4b8:15049ac7206:-8000-0000000000000004,1:18558] [APP: oim#11.1.2.0.0] org.identityconnectors.dbum.DBUMConnector : parseConnectionProperties : No connection proeprties present
[2015-10-09T10:47:45.878-07:00] [oimext_server1] [WARNING] [] [ORG.IDENTITYCONNECTORS.DBUM.DBUMCONNECTOR] [tid: Thread-276] [userId: oiminternal] [ecid: 77744a889dde03de:-265ee4b8:15049ac7206:-8000-0000000000000004,1:18558] [APP: oim#11.1.2.0.0] org.identityconnectors.dbum.DBUMConnector : dropUnusedSearchAttributes : Dropping tmpQuota
[2015-10-09T10:47:45.879-07:00] [oimext_server1] [WARNING] [] [ORG.IDENTITYCONNECTORS.DBUM.DBUMCONNECTOR] [tid: Thread-276] [userId: oiminternal] [ecid: 77744a889dde03de:-265ee4b8:15049ac7206:-8000-0000000000000004,1:18558] [APP: oim#11.1.2.0.0] org.identityconnectors.dbum.DBUMConnector : dropUnusedSearchAttributes : Dropping tmpQuota
[2015-10-09T10:47:45.881-07:00] [oimext_server1] [ERROR] [] [ORG.IDENTITYCONNECTORS.DBUM.SQLEXECUTIONHANDLER] [tid: Thread-276] [userId: oiminternal] [ecid: 77744a889dde03de:-265ee4b8:15049ac7206:-8000-0000000000000004,1:18558] [APP: oim#11.1.2.0.0] org.identityconnectors.dbum.SQLExecutionHandler : executeAccountSearch : Error while searching user records[[
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at org.identityconnectors.dbum.SQLExecutionHandler.searchAccounts(SQLExecutionHandler.java:287)
at org.identityconnectors.dbum.SQLExecutionHandler.executeAccountSearch(SQLExecutionHandler.java:95)
at org.identityconnectors.dbum.DBUMConnector.executeQuery(DBUMConnector.java:199)
at org.identityconnectors.dbum.DBUMConnector.executeQuery(DBUMConnector.java:74)
at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:118)
at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:82)
at sun.reflect.GeneratedMethodAccessor5776.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:93)
at com.sun.proxy.$Proxy575.search(Unknown Source)
at sun.reflect.GeneratedMethodAccessor5776.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:107)
at com.sun.proxy.$Proxy575.search(Unknown Source)
at sun.reflect.GeneratedMethodAccessor5776.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:162)
]]
[2015-10-09T10:47:45.892-07:00] [oimext_server1] [NOTIFICATION] [] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-4] [userId: oiminternal] [ecid: 77744a889dde03de:-265ee4b8:15049ac7206:-8000-0000000000000004,1:18393] [APP: oim#11.1.2.0.0] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.DBUM Oracle User Target Reconciliation Name DBUM Oracle User Target Reconciliation
[2015-10-09T10:47:46.116-07:00] [oimext_server1] [ERROR] [] [] [tid: [ACTIVE].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 77744a889dde03de:-265ee4b8:15049ac7206:-8000-0000000000010c79,0] [APP: oim#11.1.2.0.0] [DSID: 0000L1Dd4upEoIs6wjyWMG1M5jJP00000S] Failed to communicate with any of configured Access Server, ensure that it is up and running.
[2015-10-09T10:47:46.517-07:00] [oimext_server1] [ERROR] [] [] [tid: PoolWatcher] [userId: <anonymous>] [ecid: 0000L19f77uEoIs6wjyWMG1M5jJP000000,1:18404] Error in receiving hashed server challenge
[2015-10-09T10:47:49.271-07:00] [oimext_server1] [ERROR] [] [] [tid: [ACTIVE].ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 77744a889dde03de:-265ee4b8:15049ac7206:-8000-0000000000010c7c,0] [APP: oim#11.1.2.0.0] [DSID: 0000L1Dd4upEoIs6wjyWMG1M5jJP00000S] Failed to communicate with any of configured Access Server, ensure that it is up and running.
[2015-10-09T10:47:49.718-07:00] [oimext_server1] [ERROR] [] [] [tid: [ACTIVE].ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 77744a889dde03de:-265ee4b8:15049ac7206:-8000-0000000000010c7e,0] [APP: oim#11.1.2.0.0] [DSID: 0000L1Dd4upEoIs6wjyWMG1M5jJP00000S] Failed to communicate with any of configured Access Server, ensure that it is up and running.
Thank you