14 Replies Latest reply: Mar 19, 2013 4:02 AM by 989189 RSS

    Trusted Source Recon from OID

    989189
      Hi All,

      We are running a Trusted Source recon from OID into OIM. The users are getting created into OIM without any issues and their attributes are getting populated.

      Now we want the password provided in OID to also get propagated/reflected in OIM, when the Trusted Source Recon is run so that the user has the same password on OIM.

      Can you please let me know how can I include the user's password also in the attributes that need to come into OIM from OID.

      Thanks in advance.
        • 1. Re: Trusted Source Recon from OID
          Vamsi Krishna
          Follow the document from here:
          http://docs.oracle.com/cd/E22999_01/doc.111/e28603/extnd_func.htm#BCGDCHAC
          Section: 9.5 Adding New Fields for Trusted Source Reconciliation

          In the example, it was defined for Employee number, you can try using password field.

          Cheers,
          Vamsi.
          • 2. Re: Trusted Source Recon from OID
            989189
            Hi,

            Thanks for sharing the link. Following the steps in the link, Under User Defined Field Definition I do not find any User Form.

            Under this I see only the following forms:

            Form Designer Form
            Roles Form
            Organization Form
            Resource Objects Form

            Please let me know how to proceed.

            Thanks,
            Partha
            • 3. Re: Trusted Source Recon from OID
              Vamsi Krishna
              Partha,

              The document asks you to open User Defined Field Definitions form - that is not right.
              Expand Process Management > Process Definition
              Enter the Name field as: LDAP User

              Then, search for the process - It should appear as shown in the document.

              Cheers,
              Vamsi.
              • 4. Re: Trusted Source Recon from OID
                989189
                Hi Vamsi,

                I have followed the steps in the document.

                1. In the Resource Objects for OID Trusted Recon User adding the Password field under Object Reconciliation> Reconciliation Fields.
                2. Create the Reconciliation Profile.
                3. Under Process Definition for OID Trusted Recon User>Reconciliation Field Mappings tab added Field Map Password = Password.
                4. Under Lookup Definition for AttrName.Recon.Map.OID(Look Up Type) added Code Key as Password and Decode value as userPassword.

                After making the changes when I run the task for Trusted Source Recon for OID, the new users are not at all getting created on OIM. Can you please let me know if I am doing anything wrong or point out anything else that I should try.

                Thanks
                • 5. Re: Trusted Source Recon from OID
                  989189
                  [2013-03-15T04:19:43.446-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Scheduled Provisioning Task Name Scheduled Provisioning Task] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Scheduled Provisioning Task Name Scheduled Provisioning Task
                  [2013-03-15T04:19:43.467-07:00] [oim_server1] [ERROR] [] [XELLERATE.SCHEDULER.TASK] [tid: OIMQuartzScheduler_Worker-8] [userId: xelsysadm] [ecid: 0000Jp9J7xpBx0G6yzicMG1HEQdK00000Z,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002a] Error while sending the Warning email for attestation[[
                  com.thortech.xl.dataaccess.tcDataSetException: Data Access Error
                       at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:956)
                       at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1523)
                       at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:903)
                       at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1490)
                       at com.thortech.xl.schedule.tasks.tcTskSubmitAttestationRequets.sendWarningEmail(tcTskSubmitAttestationRequets.java:184)
                       at com.thortech.xl.schedule.tasks.tcTskSubmitAttestationRequets.execute(tcTskSubmitAttestationRequets.java:159)
                       at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:385)
                       at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                       at java.lang.reflect.Method.invoke(Method.java:597)
                       at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                       at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                       at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
                  Data AccessException:
                  com.thortech.xl.dataaccess.tcClientDataAccessException
                       at com.thortech.xl.client.dataobj.tcDataBaseClient.readPartialStatement(tcDataBaseClient.java:116)
                       at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:935)
                       at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1523)
                       at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:903)
                       at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1490)
                       at com.thortech.xl.schedule.tasks.tcTskSubmitAttestationRequets.sendWarningEmail(tcTskSubmitAttestationRequets.java:186)
                       at com.thortech.xl.schedule.tasks.tcTskSubmitAttestationRequets.execute(tcTskSubmitAttestationRequets.java:159)
                       at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:385)
                       at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                       at java.lang.reflect.Method.invoke(Method.java:597)
                       at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                       at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                       at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
                  com.thortech.xl.dataaccess.tcClientDataAccessException: Unknown exception code: 0
                  Detail: null
                  Description: null
                  SQL State: null
                  Vendor Code: 0
                  Server-side Debug Info:
                  null


                  ]]
                  [2013-03-15T04:19:43.501-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-8] [userId: xelsysadm] [ecid: 0000Jp9J7xpBx0G6yzicMG1HEQdK00000Z,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002a] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Attestation Grace Period Expiry Checker Name Attestation Grace Period Expiry Checker] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Attestation Grace Period Expiry Checker Name Attestation Grace Period Expiry Checker
                  [2013-03-15T04:19:43.501-07:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: OIMQuartzScheduler_Worker-3] [userId: xelsysadm] [ecid: 0000Jp9J7pRBx0G6yzicMG1HEQdK00000U,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000025] Class/Method: DBPoolManager/getConnection/Exception encounter some problems: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource[[
                  java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
                       at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:541)
                       at oracle.ucp.jdbc.PoolDataSourceImpl.throwSQLException(PoolDataSourceImpl.java:587)
                       at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:668)
                       at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:613)
                       at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:607)
                       at com.thortech.xl.util.DirectDB$DBPoolManager.getConnection(DirectDB.java:429)
                       at com.thortech.xl.util.DirectDB.getConnection(DirectDB.java:176)
                       at com.thortech.xl.dataaccess.tcDataBase.getConnection(tcDataBase.java:3217)
                       at com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(tcDataBase.java:1229)
                       at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1158)
                       at com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.readPreparedStatement(tcDataBaseBean.java:426)
                       at com.thortech.xl.ejb.interfaces.tcDataBaseEJB.readPreparedStatementx(Unknown Source)
                       at sun.reflect.GeneratedMethodAccessor580.invoke(Unknown Source)
                       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                       at java.lang.reflect.Method.invoke(Method.java:597)
                       at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                       at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                       at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                       at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                       at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                       at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                       at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
                       at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
                       at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
                       at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                       at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                       at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                       at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                       at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                       at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                       at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                       at $Proxy302.readPreparedStatementx(Unknown Source)
                       at com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.readPreparedStatementx(tcDataBase_dco355_tcDataBaseRemoteImpl.java:3018)
                       at sun.reflect.GeneratedMethodAccessor5506.invoke(Unknown Source)
                       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                       at java.lang.reflect.Method.invoke(Method.java:597)
                       at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:84)
                       at $Proxy303.readPreparedStatementx(Unknown Source)
                       at com.thortech.xl.ejb.interfaces.tcDataBaseDelegate.readPreparedStatement(Unknown Source)
                       at sun.reflect.GeneratedMethodAccessor579.invoke(Unknown Source)
                       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                       at java.lang.reflect.Method.invoke(Method.java:597)
                       at Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68)
                       at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                       at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
                       at weblogic.security.Security.runAs(Security.java:41)
                       at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
                       at Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:79)
                       at $Proxy304.readPreparedStatement(Unknown Source)
                       at com.thortech.xl.dataaccess.tcDataBaseClient.readPreparedStatement(tcDataBaseClient.java:621)
                       at com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:60)
                       at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:98)
                       at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:78)
                       at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
                       at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                       at java.lang.reflect.Method.invoke(Method.java:597)
                       at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                       at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
                       at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
                  Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
                       at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:421)
                       at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:389)
                       at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:105)
                       at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1570)
                       at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$600(UniversalConnectionPoolImpl.java:1378)
                       at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(UniversalConnectionPoolImpl.java:445)
                       at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:302)
                       at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:129)
                       at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:119)
                       at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:655)
                       ... 59 more
                  Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
                  • 6. Re: Trusted Source Recon from OID
                    989189
                    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
                         at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
                         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
                         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
                         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:415)
                         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
                         at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:863)
                         at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:379)
                         at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:640)
                         at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:205)
                         at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
                         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:554)
                         at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:388)
                         at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:278)
                         at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:99)
                         ... 66 more

                    ]]
                    [2013-03-15T04:19:43.505-07:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: OIMQuartzScheduler_Worker-3] [userId: xelsysadm] [ecid: 0000Jp9J7pRBx0G6yzicMG1HEQdK00000U,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000025] Class/Method: DBPoolManager/getConnection/Exception encounter some problems: Error while retrieving database connection.Please check for the following[[
                    Database srever is up.
                    DirectDB settings in configuration file are correct.
                    ]]
                    [2013-03-15T04:19:43.505-07:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: OIMQuartzScheduler_Worker-3] [userId: xelsysadm] [ecid: 0000Jp9J7pRBx0G6yzicMG1HEQdK00000U,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000025] Class/Method: DirectDB/getConnection encounter some problems: Error while retrieving database connection.Please check for the follwoing[[
                    Database srever is running.
                    Datasource configuration settings are correct. java.sql.SQLException: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
                         at com.thortech.xl.util.DirectDB$DBPoolManager.getConnection(DirectDB.java:441)
                         at com.thortech.xl.util.DirectDB.getConnection(DirectDB.java:176)
                         at com.thortech.xl.dataaccess.tcDataBase.getConnection(tcDataBase.java:3217)
                         at com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(tcDataBase.java:1229)
                         at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1158)
                         at com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.readPreparedStatement(tcDataBaseBean.java:426)
                         at com.thortech.xl.ejb.interfaces.tcDataBaseEJB.readPreparedStatementx(Unknown Source)
                         at sun.reflect.GeneratedMethodAccessor580.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                         at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                         at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                         at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
                         at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
                         at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                         at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                         at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                         at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                         at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                         at $Proxy302.readPreparedStatementx(Unknown Source)
                         at com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.readPreparedStatementx(tcDataBase_dco355_tcDataBaseRemoteImpl.java:3018)
                         at sun.reflect.GeneratedMethodAccessor5506.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:84)
                         at $Proxy303.readPreparedStatementx(Unknown Source)
                         at com.thortech.xl.ejb.interfaces.tcDataBaseDelegate.readPreparedStatement(Unknown Source)
                         at sun.reflect.GeneratedMethodAccessor579.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68)
                         at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
                         at weblogic.security.Security.runAs(Security.java:41)
                         at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
                         at Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:100)
                         at $Proxy304.readPreparedStatement(Unknown Source)
                         at com.thortech.xl.dataaccess.tcDataBaseClient.readPreparedStatement(tcDataBaseClient.java:621)
                         at com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:60)
                         at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:99)
                         at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:79)
                         at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:385)
                         at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                         at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                         at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

                    ]]
                    [2013-03-15T04:19:43.512-07:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: OIMQuartzScheduler_Worker-3] [userId: xelsysadm] [ecid: 0000Jp9J7pRBx0G6yzicMG1HEQdK00000U,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000025] Class/Method: tcDataBase/readPartialPreparedStatement encounter some problems: {1}[[
                    java.lang.NullPointerException
                         at com.thortech.xl.util.JDBCUtils.prepareStatement(JDBCUtils.java:212)
                         at com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(tcDataBase.java:1231)
                         at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1158)
                         at com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.readPreparedStatement(tcDataBaseBean.java:426)
                         at com.thortech.xl.ejb.interfaces.tcDataBaseEJB.readPreparedStatementx(Unknown Source)
                         at sun.reflect.GeneratedMethodAccessor580.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                         at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                         at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                         at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
                         at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
                         at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                         at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                         at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                         at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                         at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                         at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                         at $Proxy302.readPreparedStatementx(Unknown Source)
                         at com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.readPreparedStatementx(tcDataBase_dco355_tcDataBaseRemoteImpl.java:3018)
                         at sun.reflect.GeneratedMethodAccessor5506.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:84)
                         at $Proxy303.readPreparedStatementx(Unknown Source)
                         at com.thortech.xl.ejb.interfaces.tcDataBaseDelegate.readPreparedStatement(Unknown Source)
                         at sun.reflect.GeneratedMethodAccessor579.invoke(Unknown Source)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68)
                         at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
                         at weblogic.security.Security.runAs(Security.java:41)
                         at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
                         at Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:79)
                         at $Proxy304.readPreparedStatement(Unknown Source)
                         at com.thortech.xl.dataaccess.tcDataBaseClient.readPreparedStatement(tcDataBaseClient.java:621)
                         at com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:60)
                         at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:98)
                         at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:78)
                         at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
                         at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                         at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
                         at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

                    ]]
                    [2013-03-15T04:19:43.514-07:00] [oim_server1] [ERROR] [] [XELLERATE.SERVER] [tid: OIMQuartzScheduler_Worker-3] [userId: xelsysadm] [ecid: 0000Jp9J7pRBx0G6yzicMG1HEQdK00000U,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000025] Class/Method: StatementUtil/setStatement encounter some problems: Dataset is not open[[
                    com.thortech.xl.dataaccess.tcDataSetException: Dataset is not open
                         at com.thortech.xl.dataaccess.tcDataSet.checkOpen(tcDataSet.java:4347)
                         at com.thortech.xl.dataaccess.tcDataSet.getRowCount(tcDataSet.java:467)
                         at com.thortech.xl.dataobj.StatementUtil.getDataSet(StatementUtil.java:69)
                         at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:103)
                         at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:79)
                         at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:385)
                         at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                         at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                         at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

                    ]]
                    [2013-03-15T04:19:43.515-07:00] [oim_server1] [ERROR] [] [XELLERATE.SCHEDULER.TASK] [tid: OIMQuartzScheduler_Worker-3] [userId: xelsysadm] [ecid: 0000Jp9J7pRBx0G6yzicMG1HEQdK00000U,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000025] Error while selecting messages in AUD_JMS[[
                    com.thortech.xl.dataaccess.tcDataSetException: Dataset is not open
                         at com.thortech.xl.dataaccess.tcDataSet.checkOpen(tcDataSet.java:4347)
                         at com.thortech.xl.dataaccess.tcDataSet.getRowCount(tcDataSet.java:467)
                         at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:108)
                         at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:79)
                         at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:385)
                         at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:597)
                         at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                         at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                         at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
                    • 7. Re: Trusted Source Recon from OID
                      989189
                      [2013-03-15T04:19:43.525-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-3] [userId: xelsysadm] [ecid: 0000Jp9J7pRBx0G6yzicMG1HEQdK00000U,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000025] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Issue Audit Messages Task Name Issue Audit Messages Task] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Issue Audit Messages Task Name Issue Audit Messages Task
                      [2013-03-15T04:19:43.554-07:00] [oim_server1] [NOTIFICATION] [IAM-1020004] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-6] [userId: xelsysadm] [ecid: 0000Jp9J7vvBx0G6yzicMG1HEQdK00000X,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000028] [arg: Description null FullName DEFAULT.Automated Retry of Failed Async Task Name Automated Retry of Failed Async Task] Job Listener, Job to be executed Description null FullName DEFAULT.Automated Retry of Failed Async Task Name Automated Retry of Failed Async Task
                      [2013-03-15T04:19:43.556-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-6] [userId: xelsysadm] [ecid: 0000Jp9J7vvBx0G6yzicMG1HEQdK00000X,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000028] [arg:  Method details: executeJob] Method details Method details: executeJob
                      [2013-03-15T04:19:43.557-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.vo] [tid: OIMQuartzScheduler_Worker-6] [userId: xelsysadm] [ecid: 0000Jp9J7vvBx0G6yzicMG1HEQdK00000X,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000028] [arg: executeJob Automated Retry of Failed Async Task] Method details executeJob Automated Retry of Failed Async Task
                      [2013-03-15T04:19:43.573-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-6] [userId: xelsysadm] [ecid: 0000Jp9J7vvBx0G6yzicMG1HEQdK00000X,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000028] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Automated Retry of Failed Async Task Name Automated Retry of Failed Async Task] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Automated Retry of Failed Async Task Name Automated Retry of Failed Async Task
                      [2013-03-15T04:19:43.660-07:00] [oim_server1] [NOTIFICATION] [IAM-1020004] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-4] [userId: xelsysadm] [ecid: 0000Jp9J7tkBx0G6yzicMG1HEQdK00000V,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000026] [arg: Description null FullName DEFAULT.Evaluate User Policies Name Evaluate User Policies] Job Listener, Job to be executed Description null FullName DEFAULT.Evaluate User Policies Name Evaluate User Policies
                      [2013-03-15T04:19:43.661-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-4] [userId: xelsysadm] [ecid: 0000Jp9J7tkBx0G6yzicMG1HEQdK00000V,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000026] [arg:  Method details: executeJob] Method details Method details: executeJob
                      [2013-03-15T04:19:43.664-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-4] [userId: xelsysadm] [ecid: 0000Jp9J7tkBx0G6yzicMG1HEQdK00000V,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000026] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Evaluate User Policies Name Evaluate User Policies] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Evaluate User Policies Name Evaluate User Policies
                      [2013-03-15T04:19:44.204-07:00] [oim_server1] [NOTIFICATION] [IAM-1020004] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-10] [userId: xelsysadm] [ecid: 0000Jp9J88QBx0G6yzicMG1HEQdK00000_,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002c] [arg: Description null FullName DEFAULT.Retry Failed Reconciliation Events Name Retry Failed Reconciliation Events] Job Listener, Job to be executed Description null FullName DEFAULT.Retry Failed Reconciliation Events Name Retry Failed Reconciliation Events
                      [2013-03-15T04:19:44.206-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-10] [userId: xelsysadm] [ecid: 0000Jp9J88QBx0G6yzicMG1HEQdK00000_,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002c] [arg:  Method details: executeJob] Method details Method details: executeJob
                      [2013-03-15T04:19:44.206-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.vo] [tid: OIMQuartzScheduler_Worker-10] [userId: xelsysadm] [ecid: 0000Jp9J88QBx0G6yzicMG1HEQdK00000_,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002c] [arg: executeJob Retry Failed Reconciliation Events] Method details executeJob Retry Failed Reconciliation Events
                      [2013-03-15T04:19:44.240-07:00] [oim_server1] [NOTIFICATION] [IAM-5010000] [oracle.iam.reconciliation.dao.event] [tid: OIMQuartzScheduler_Worker-10] [userId: xelsysadm] [ecid: 0000Jp9J88QBx0G6yzicMG1HEQdK00000_,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002c] [arg: db query:select RECON_EVENTS.RE_KEY, RECON_BATCHES.RB_PROFILE_NAME, RECON_EVENTS.RE_MODIFY from RECON_EVENTS, RECON_BATCHES where RECON_EVENTS.RB_KEY = RECON_BATCHES.RB_KEY and RECON_EVENTS.RE_CURR_RETRY_CNT > 0 and RECON_EVENTS.RE_CHANGE_TYPE != 'DELETE' and (RECON_EVENTS.RE_STATUS IN ('Creation Failed', 'Update Failed') or (RECON_EVENTS.RE_ENTITY_TYPE = 'Account' and RECON_EVENTS.RE_STATUS IN ('No User Match Found', 'No Org Match Found')) or (RECON_EVENTS.RE_ENTITY_TYPE = 'User' and RECON_EVENTS.RE_STATUS IN 'Data Validation Failed') or (RECON_EVENTS.RE_ENTITY_TYPE = 'Role' and RECON_EVENTS.RE_STATUS = 'Data Validation Failed' and RECON_EVENTS.RE_NOTE like 'Invalid Role Category%') or (RECON_EVENTS.RE_ENTITY_TYPE = 'RoleRole' and RECON_EVENTS.RE_STATUS IN ('No Role Parent Found', 'No User Match Found')) or (recon_events.RE_ENTITY_TYPE = 'RoleUser' and recon_events.RE_STATUS IN ('No Role Members Found', 'No Role Match Found'))) order by re_key] Generic Error/Information: db query:select RECON_EVENTS.RE_KEY, RECON_BATCHES.RB_PROFILE_NAME, RECON_EVENTS.RE_MODIFY from RECON_EVENTS, RECON_BATCHES where RECON_EVENTS.RB_KEY = RECON_BATCHES.RB_KEY and RECON_EVENTS.RE_CURR_RETRY_CNT > 0 and RECON_EVENTS.RE_CHANGE_TYPE != 'DELETE' and (RECON_EVENTS.RE_STATUS IN ('Creation Failed', 'Update Failed') or (RECON_EVENTS.RE_ENTITY_TYPE = 'Account' and RECON_EVENTS.RE_STATUS IN ('No User Match Found', 'No Org Match Found')) or (RECON_EVENTS.RE_ENTITY_TYPE = 'User' and RECON_EVENTS.RE_STATUS IN 'Data Validation Failed') or (RECON_EVENTS.RE_ENTITY_TYPE = 'Role' and RECON_EVENTS.RE_STATUS = 'Data Validation Failed' and RECON_EVENTS.RE_NOTE like 'Invalid Role Category%') or (RECON_EVENTS.RE_ENTITY_TYPE = 'RoleRole' and RECON_EVENTS.RE_STATUS IN ('No Role Parent Found', 'No User Match Found')) or (recon_events.RE_ENTITY_TYPE = 'RoleUser' and recon_events.RE_STATUS IN ('No Role Members Found', 'No Role Match Found'))) order by re_key
                      [2013-03-15T04:19:44.242-07:00] [oim_server1] [NOTIFICATION] [IAM-5012042] [oracle.iam.reconciliation.impl] [tid: OIMQuartzScheduler_Worker-10] [userId: xelsysadm] [ecid: 0000Jp9J88QBx0G6yzicMG1HEQdK00000_,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002c] No events for retry
                      [2013-03-15T04:19:44.248-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-10] [userId: xelsysadm] [ecid: 0000Jp9J88QBx0G6yzicMG1HEQdK00000_,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002c] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Retry Failed Reconciliation Events Name Retry Failed Reconciliation Events] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Retry Failed Reconciliation Events Name Retry Failed Reconciliation Events
                      [2013-03-15T04:19:44.647-07:00] [oim_server1] [NOTIFICATION] [IAM-1020004] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-2] [userId: xelsysadm] [ecid: 0000Jp9J7nfBx0G6yzicMG1HEQdK00000T,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000024] [arg: Description null FullName DEFAULT.Get SOD Check Results Approval Name Get SOD Check Results Approval] Job Listener, Job to be executed Description null FullName DEFAULT.Get SOD Check Results Approval Name Get SOD Check Results Approval
                      [2013-03-15T04:19:44.649-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-2] [userId: xelsysadm] [ecid: 0000Jp9J7nfBx0G6yzicMG1HEQdK00000T,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000024] [arg:  Method details: executeJob] Method details Method details: executeJob
                      [2013-03-15T04:19:44.653-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-2] [userId: xelsysadm] [ecid: 0000Jp9J7nfBx0G6yzicMG1HEQdK00000T,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000024] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Get SOD Check Results Approval Name Get SOD Check Results Approval] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Get SOD Check Results Approval Name Get SOD Check Results Approval
                      [2013-03-15T04:19:44.749-07:00] [oim_server1] [NOTIFICATION] [IAM-1020004] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-9] [userId: xelsysadm] [ecid: 0000Jp9J7zcBx0G6yzicMG1HEQdK00000^,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002b] [arg: Description null FullName DEFAULT.Get SOD Check Results Provisioning Name Get SOD Check Results Provisioning] Job Listener, Job to be executed Description null FullName DEFAULT.Get SOD Check Results Provisioning Name Get SOD Check Results Provisioning
                      [2013-03-15T04:19:44.751-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-9] [userId: xelsysadm] [ecid: 0000Jp9J7zcBx0G6yzicMG1HEQdK00000^,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002b] [arg:  Method details: executeJob] Method details Method details: executeJob
                      [2013-03-15T04:19:44.753-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-9] [userId: xelsysadm] [ecid: 0000Jp9J7zcBx0G6yzicMG1HEQdK00000^,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000002b] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Get SOD Check Results Provisioning Name Get SOD Check Results Provisioning] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Get SOD Check Results Provisioning Name Get SOD Check Results Provisioning
                      [2013-03-15T04:19:45.087-07:00] [oim_server1] [NOTIFICATION] [IAM-1020004] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-5] [userId: xelsysadm] [ecid: 0000Jp9J7viBx0G6yzicMG1HEQdK00000W,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000027] [arg: Description null FullName DEFAULT.Resubmit Uninitiated Provisioning SODChecks Name Resubmit Uninitiated Provisioning SODChecks] Job Listener, Job to be executed Description null FullName DEFAULT.Resubmit Uninitiated Provisioning SODChecks Name Resubmit Uninitiated Provisioning SODChecks
                      [2013-03-15T04:19:45.089-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-5] [userId: xelsysadm] [ecid: 0000Jp9J7viBx0G6yzicMG1HEQdK00000W,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000027] [arg:  Method details: executeJob] Method details Method details: executeJob
                      [2013-03-15T04:19:45.091-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-5] [userId: xelsysadm] [ecid: 0000Jp9J7viBx0G6yzicMG1HEQdK00000W,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000027] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Resubmit Uninitiated Provisioning SODChecks Name Resubmit Uninitiated Provisioning SODChecks] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Resubmit Uninitiated Provisioning SODChecks Name Resubmit Uninitiated Provisioning SODChecks
                      [2013-03-15T04:19:45.183-07:00] [oim_server1] [NOTIFICATION] [IAM-1020004] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-1] [userId: xelsysadm] [ecid: 0000Jp9HyjKBx0G6yzicMG1HEQdK00000O,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000001f] [arg: Description null FullName DEFAULT.Resubmit Uninitiated Approval SODChecks Name Resubmit Uninitiated Approval SODChecks] Job Listener, Job to be executed Description null FullName DEFAULT.Resubmit Uninitiated Approval SODChecks Name Resubmit Uninitiated Approval SODChecks
                      [2013-03-15T04:19:45.187-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-1] [userId: xelsysadm] [ecid: 0000Jp9HyjKBx0G6yzicMG1HEQdK00000O,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000001f] [arg:  Method details: executeJob] Method details Method details: executeJob
                      [2013-03-15T04:19:45.190-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-1] [userId: xelsysadm] [ecid: 0000Jp9HyjKBx0G6yzicMG1HEQdK00000O,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-000000000000001f] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Resubmit Uninitiated Approval SODChecks Name Resubmit Uninitiated Approval SODChecks] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Resubmit Uninitiated Approval SODChecks Name Resubmit Uninitiated Approval SODChecks
                      [2013-03-15T04:24:43.023-07:00] [oim_server1] [NOTIFICATION] [IAM-1020004] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] [arg: Description null FullName DEFAULT.Issue Audit Messages Task Name Issue Audit Messages Task] Job Listener, Job to be executed Description null FullName DEFAULT.Issue Audit Messages Task Name Issue Audit Messages Task
                      [2013-03-15T04:24:43.025-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] [arg:  Method details: executeJob] Method details Method details: executeJob
                      [2013-03-15T04:24:43.025-07:00] [oim_server1] [NOTIFICATION] [IAM-1020014] [oracle.iam.scheduler.vo] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] [arg: executeJob Issue Audit Messages Task] Method details executeJob Issue Audit Messages Task
                      [2013-03-15T04:24:43.109-07:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] Class/Method: DBPoolManager/getConnection/Exception encounter some problems: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource[[
                      java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
                           at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:541)
                           at oracle.ucp.jdbc.PoolDataSourceImpl.throwSQLException(PoolDataSourceImpl.java:587)
                           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:668)
                           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:613)
                           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:607)
                           at com.thortech.xl.util.DirectDB$DBPoolManager.getConnection(DirectDB.java:429)
                           at com.thortech.xl.util.DirectDB.getConnection(DirectDB.java:176)
                           at com.thortech.xl.dataaccess.tcDataBase.getConnection(tcDataBase.java:3217)
                           at com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(tcDataBase.java:1229)
                           at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1158)
                           at com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.readPreparedStatement(tcDataBaseBean.java:426)
                           at com.thortech.xl.ejb.interfaces.tcDataBaseEJB.readPreparedStatementx(Unknown Source)
                           at sun.reflect.GeneratedMethodAccessor580.invoke(Unknown Source)
                           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                           at java.lang.reflect.Method.invoke(Method.java:597)
                           at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                           at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
                           at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
                           at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
                           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                           at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                           at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                           at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                           at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                           at $Proxy302.readPreparedStatementx(Unknown Source)
                           at com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.readPreparedStatementx(tcDataBase_dco355_tcDataBaseRemoteImpl.java:3018)
                           at sun.reflect.GeneratedMethodAccessor5506.invoke(Unknown Source)
                           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                           at java.lang.reflect.Method.invoke(Method.java:597)
                           at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:84)
                           at $Proxy303.readPreparedStatementx(Unknown Source)
                           at com.thortech.xl.ejb.interfaces.tcDataBaseDelegate.readPreparedStatement(Unknown Source)
                           at sun.reflect.GeneratedMethodAccessor579.invoke(Unknown Source)
                           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                           at java.lang.reflect.Method.invoke(Method.java:597)
                           at Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68)
                           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
                           at weblogic.security.Security.runAs(Security.java:41)
                           at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
                           at Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:79)
                           at $Proxy304.readPreparedStatement(Unknown Source)
                           at com.thortech.xl.dataaccess.tcDataBaseClient.readPreparedStatement(tcDataBaseClient.java:621)
                           at com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:60)
                           at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:98)
                           at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:78)
                           at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
                           at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                           at java.lang.reflect.Method.invoke(Method.java:597)
                           at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                           at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
                           at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
                      Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
                           at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:421)
                           at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:389)
                           at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:105)
                           at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.createOnePooledConnectionInternal(UniversalConnectionPoolImpl.java:1570)
                           at oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$600(UniversalConnectionPoolImpl.java:1378)
                           at oracle.ucp.common.UniversalConnectionPoolImpl.createOnePooledConnection(UniversalConnectionPoolImpl.java:445)
                           at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:302)
                           at oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnection(UniversalConnectionPoolImpl.java:129)
                           at oracle.ucp.jdbc.JDBCConnectionPool.borrowConnection(JDBCConnectionPool.java:119)
                           at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:655)
                           ... 59 more
                      Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
                      • 8. Re: Trusted Source Recon from OID
                        989189
                        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
                             at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:135)
                             at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:210)
                             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:473)
                             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:415)
                             at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
                             at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:863)
                             at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:379)
                             at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:640)
                             at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:205)
                             at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
                             at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:554)
                             at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:388)
                             at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:278)
                             at oracle.ucp.jdbc.DataSourceConnectionFactoryAdapter.createConnection(DataSourceConnectionFactoryAdapter.java:99)
                             ... 66 more

                        ]]
                        [2013-03-15T04:24:43.113-07:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] Class/Method: DBPoolManager/getConnection/Exception encounter some problems: Error while retrieving database connection.Please check for the following[[
                        Database srever is up.
                        DirectDB settings in configuration file are correct.
                        ]]
                        [2013-03-15T04:24:43.113-07:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] Class/Method: DirectDB/getConnection encounter some problems: Error while retrieving database connection.Please check for the follwoing[[
                        Database srever is running.
                        Datasource configuration settings are correct. java.sql.SQLException: java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
                             at com.thortech.xl.util.DirectDB$DBPoolManager.getConnection(DirectDB.java:441)
                             at com.thortech.xl.util.DirectDB.getConnection(DirectDB.java:176)
                             at com.thortech.xl.dataaccess.tcDataBase.getConnection(tcDataBase.java:3217)
                             at com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(tcDataBase.java:1229)
                             at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1158)
                             at com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.readPreparedStatement(tcDataBaseBean.java:426)
                             at com.thortech.xl.ejb.interfaces.tcDataBaseEJB.readPreparedStatementx(Unknown Source)
                             at sun.reflect.GeneratedMethodAccessor580.invoke(Unknown Source)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                             at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                             at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                             at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
                             at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
                             at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                             at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                             at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                             at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                             at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                             at $Proxy302.readPreparedStatementx(Unknown Source)
                             at com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.readPreparedStatementx(tcDataBase_dco355_tcDataBaseRemoteImpl.java:3018)
                             at sun.reflect.GeneratedMethodAccessor5506.invoke(Unknown Source)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:84)
                             at $Proxy303.readPreparedStatementx(Unknown Source)
                             at com.thortech.xl.ejb.interfaces.tcDataBaseDelegate.readPreparedStatement(Unknown Source)
                             at sun.reflect.GeneratedMethodAccessor579.invoke(Unknown Source)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68)
                             at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                             at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
                             at weblogic.security.Security.runAs(Security.java:41)
                             at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
                             at Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:100)
                             at $Proxy304.readPreparedStatement(Unknown Source)
                             at com.thortech.xl.dataaccess.tcDataBaseClient.readPreparedStatement(tcDataBaseClient.java:621)
                             at com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:60)
                             at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:99)
                             at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:79)
                             at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:385)
                             at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                             at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                             at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

                        ]]
                        [2013-03-15T04:24:43.141-07:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] Class/Method: tcDataBase/readPartialPreparedStatement encounter some problems: {1}[[
                        java.lang.NullPointerException
                             at com.thortech.xl.util.JDBCUtils.prepareStatement(JDBCUtils.java:212)
                             at com.thortech.xl.dataaccess.tcDataBase.readPartialPreparedStatement(tcDataBase.java:1231)
                             at com.thortech.xl.dataaccess.tcDataBase.readPreparedStatement(tcDataBase.java:1158)
                             at com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.readPreparedStatement(tcDataBaseBean.java:426)
                             at com.thortech.xl.ejb.interfaces.tcDataBaseEJB.readPreparedStatementx(Unknown Source)
                             at sun.reflect.GeneratedMethodAccessor580.invoke(Unknown Source)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                             at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                             at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                             at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
                             at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
                             at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                             at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                             at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                             at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                             at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                             at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                             at $Proxy302.readPreparedStatementx(Unknown Source)
                             at com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.readPreparedStatementx(tcDataBase_dco355_tcDataBaseRemoteImpl.java:3018)
                             at sun.reflect.GeneratedMethodAccessor5506.invoke(Unknown Source)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:84)
                             at $Proxy303.readPreparedStatementx(Unknown Source)
                             at com.thortech.xl.ejb.interfaces.tcDataBaseDelegate.readPreparedStatement(Unknown Source)
                             at sun.reflect.GeneratedMethodAccessor579.invoke(Unknown Source)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68)
                             at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                             at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
                             at weblogic.security.Security.runAs(Security.java:41)
                             at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
                             at Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:79)
                             at $Proxy304.readPreparedStatement(Unknown Source)
                             at com.thortech.xl.dataaccess.tcDataBaseClient.readPreparedStatement(tcDataBaseClient.java:621)
                             at com.thortech.xl.dataobj.PreparedStatementUtil.execute(PreparedStatementUtil.java:60)
                             at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:98)
                             at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:78)
                             at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
                             at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                             at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
                             at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

                        ]]
                        [2013-03-15T04:24:43.144-07:00] [oim_server1] [ERROR] [] [XELLERATE.SERVER] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] Class/Method: StatementUtil/setStatement encounter some problems: Dataset is not open[[
                        com.thortech.xl.dataaccess.tcDataSetException: Dataset is not open
                             at com.thortech.xl.dataaccess.tcDataSet.checkOpen(tcDataSet.java:4347)
                             at com.thortech.xl.dataaccess.tcDataSet.getRowCount(tcDataSet.java:467)
                             at com.thortech.xl.dataobj.StatementUtil.getDataSet(StatementUtil.java:69)
                             at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:103)
                             at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:79)
                             at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:385)
                             at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                             at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                             at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

                        ]]
                        [2013-03-15T04:24:43.149-07:00] [oim_server1] [ERROR] [] [XELLERATE.SCHEDULER.TASK] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] Error while selecting messages in AUD_JMS[[
                        com.thortech.xl.dataaccess.tcDataSetException: Dataset is not open
                             at com.thortech.xl.dataaccess.tcDataSet.checkOpen(tcDataSet.java:4347)
                             at com.thortech.xl.dataaccess.tcDataSet.getRowCount(tcDataSet.java:467)
                             at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.processAllByIdentifier(ReIssueAuditMessage.java:108)
                             at com.thortech.xl.schedule.tasks.ReIssueAuditMessage.execute(ReIssueAuditMessage.java:79)
                             at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:385)
                             at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
                             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             at java.lang.reflect.Method.invoke(Method.java:597)
                             at oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:167)
                             at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                             at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

                        ]]
                        [2013-03-15T04:24:43.171-07:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-7] [userId: xelsysadm] [ecid: 0000Jp9J7wVBx0G6yzicMG1HEQdK00000Y,0] [APP: oim#11.1.1.3.0] [dcid: 7dd539cbe5059529:-3d99353:13d49447a5f:-7ffd-0000000000000029] [arg:  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Issue Audit Messages Task Name Issue Audit Messages Task] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.Issue Audit Messages Task Name Issue Audit Messages Task
                        • 9. Re: Trusted Source Recon from OID
                          Vamsi Krishna
                          4. Under Lookup Definition for AttrName.Recon.Map.OID(Look Up Type) added Code Key as Password and Decode value as userPassword.
                          Lookup Definition name should be: "Lookup.LDAP.UM.ReconAttrMap.Trusted or Lookup.OID.UM.ReconAttrMap.Trusted or LookupEDIR.UM.ReconAttrMap.Trusted" as you are reconciling trusted resource.
                          Click Save.
                          Then, The type should be selected as "Field Type".
                          Click Save.

                          Also, May I know how are you running trusted source reconciliation - The schedule job name used for this process?

                          Cheers,
                          Vamsi.
                          • 10. Re: Trusted Source Recon from OID
                            989189
                            Hi,

                            I am running the OID User Trusted Recon job.

                            Thanks,
                            Partha
                            • 11. Re: Trusted Source Recon from OID
                              989189
                              I do not see any existing lookups by the name "Lookup.LDAP.UM.ReconAttrMap.Trusted or Lookup.OID.UM.ReconAttrMap.Trusted or LookupEDIR.UM.ReconAttrMap.Trusted.

                              Please let me know if I am missing anything or if I need to look into anything else.

                              Thanks,
                              Partha
                              • 12. Re: Trusted Source Recon from OID
                                Vamsi Krishna
                                In Design Console, Under Lookup-Definition -> Lookup Code: Search for: **Trusted**
                                And give me the Lookup Defition Table results that you see.

                                Cheers,
                                Vamsi.

                                Edited by: Vamsi Krishna on 18-Mar-2013 08:05
                                • 13. Re: Trusted Source Recon from OID
                                  989189
                                  I get only one result:

                                  Code:Objects.Trusted Source
                                  Field: OBJ_TRUSTED_SOURCE
                                  Field Type

                                  Regards,
                                  Partha
                                  • 14. Re: Trusted Source Recon from OID
                                    989189
                                    I should have added this details while first creating the post

                                    OID Connector being used is 9.0.4.12.

                                    Thanks