2 Replies Latest reply: Aug 10, 2012 1:22 AM by 944276 RSS

    OIM 11g AD Connector Access Policy Based Provisioning Issue

    944276
      Hi,

      I created Approval Policy for Access Policy Based Provisioning request type for request level (autoapproval) and operational level (used standart beneficiaryManagerApproval process), but when the resource must assigned to User,- throws exception when running setAdDn adapter of Process Definition Form:

      Running ISADAM
      Target Class = java.lang.String
      Running Get Attribute Map
      Running AD Create User
      Running ISADAM
      Target Class = java.lang.String
      Running GETUSESSL
      Target Class = java.lang.String
      Running CheckUserStatus
      Running GETATTRIBUTEHASH
      Target Class = com.thortech.xl.util.adapters.tcUtilHashTableOperations
      Running Set User Attribute
      Running Set User Expiration Date
      Running ISADAM
      Target Class = java.lang.String
      Running CheckUserStatus
      Running GETPWDEXPIRESATTRIBUTEHASH
      Target Class = com.thortech.xl.util.adapters.tcUtilHashTableOperations
      Running Set Pwd Expires Attribute False
      Running GETATTRIBUTEHASH
      Target Class = com.thortech.xl.util.adapters.tcUtilHashTableOperations
      Running SETADDN
      [2012-07-19T16:15:52.281+03:00] [oim_server1] [ERROR] [] [XELLERATE.SERVER] [tid: [STUCK].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-00000000000000bb,0] [APP: oim#11.1.1.3.0] Class/Method: tcDataObj/save Error :Insertion of dataobject into database failed
      [2012-07-19T16:16:34.375+03:00] [oim_server1] [WARNING] [] [XELLERATE.DATABASE] [tid: [STUCK].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-00000000000000bb,0] [APP: oim#11.1.1.3.0] Exception while trying to get the connection count : 0
      [2012-07-19T16:16:55.422+03:00] [oim_server1] [WARNING] [] [XELLERATE.DATABASE] [tid: [STUCK].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-00000000000000bb,0] [APP: oim#11.1.1.3.0] Exception while trying to get the connection count : 1
      [2012-07-19T16:17:12.750+03:00] [oim_server1] [ERROR] [] [XELLERATE.APIS] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-0000000000000003,0] [APP: oim#11.1.1.3.0] Class/Method: tcLookupOperationsBean/getLookupValuesFilteredData encounter some problems: The LookupCode 'Lookup.ESSOMFONumbers' does not exist.
      [2012-07-19T16:17:14.703+03:00] [oim_server1] [ERROR] [] [XELLERATE.APIS] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-0000000000000003,0] [APP: oim#11.1.1.3.0] Class/Method: tcLookupOperationsBean/getLookupValuesFilteredData encounter some problems: The LookupCode 'Lookup.ESSOMFONumbers' does not exist.
      [2012-07-19T16:17:15.203+03:00] [oim_server1] [ERROR] [] [XELLERATE.APIS] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-0000000000000003,0] [APP: oim#11.1.1.3.0] Class/Method: tcLookupOperationsBean/getLookupValuesFilteredData encounter some problems: The LookupCode 'Lookup.ESSOMFONumbers' does not exist.
      [2012-07-19T16:17:15.703+03:00] [oim_server1] [ERROR] [] [XELLERATE.APIS] [tid: OIMQuartzScheduler_Worker-10] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-0000000000000003,0] [APP: oim#11.1.1.3.0] Class/Method: tcLookupOperationsBean/getLookupValuesFilteredData encounter some problems: The LookupCode 'Lookup.ESSOMFONumbers' does not exist.
      [2012-07-19T16:17:16.469+03:00] [oim_server1] [WARNING] [] [XELLERATE.DATABASE] [tid: [STUCK].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-00000000000000bb,0] [APP: oim#11.1.1.3.0] Exception while trying to get the connection count : 2
      [2012-07-19T16:17:37.516+03:00] [oim_server1] [WARNING] [] [XELLERATE.DATABASE] [tid: [STUCK].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-00000000000000bb,0] [APP: oim#11.1.1.3.0] Exception while trying to get the connection count : 3
      [2012-07-19T16:17:58.562+03:00] [oim_server1] [WARNING] [] [XELLERATE.DATABASE] [tid: [STUCK].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-00000000000000bb,0] [APP: oim#11.1.1.3.0] Exception while trying to get the connection count : 4
      [2012-07-19T16:17:58.562+03:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: [STUCK].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 3f3d2d8955322f32:-2e0e6e14:1389f3fa30b:-8000-00000000000000bb,0] [APP: oim#11.1.1.3.0] 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: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Event handler ApprovalInitiation is asynchronous but orchestration is configured as synchronous.
           at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1616)
           at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1503)
           at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
           at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
           at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
           at oracle.iam.platform.utils.vo.OIMDataSource.getConnection(OIMDataSource.java:57)
           at com.thortech.xl.util.DirectDB.getConnection(DirectDB.java:200)
           at com.thortech.xl.util.DirectDB.getConnection(DirectDB.java:148)
           at com.thortech.xl.dataaccess.tcDataBase.getConnection(tcDataBase.java:3198)
           at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:705)
           at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(tcDataBase.java:271)
           at com.thortech.xl.dataobj.tcDataBase.readStatement(tcDataBase.java:221)
           at com.thortech.xl.dataobj.tcDataBase.getError(tcDataBase.java:700)
           at com.thortech.xl.dataobj.tcDataObj.handleError(tcDataObj.java:1197)
           at com.thortech.xl.dataobj.tcDataObj.handleError(tcDataObj.java:1140)
           at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:487)
           at com.thortech.xl.dataobj.tcORC.insertNonConditionalMilestones(tcORC.java:844)
           at com.thortech.xl.dataobj.tcORC.completeSystemValidationMilestone(tcORC.java:1159)
           at com.thortech.xl.dataobj.tcOrderItemInfo.completeCarrierBaseMilestone(tcOrderItemInfo.java:735)
           at com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(tcOrderItemInfo.java:171)
           at com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:234)
           at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
           at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
           at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
           at com.thortech.xl.dataobj.tcORC.autoDOBSave(tcORC.java:2995)
           at com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(tcOrderPackages.java:526)
           at com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(tcOrderPackages.java:177)
           at com.thortech.xl.dataobj.tcOIU.provision(tcOIU.java:527)
           at com.thortech.xl.dataobj.tcOIU.eventPostInsert(tcOIU.java:303)
           at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
           at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
           at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
           at com.thortech.xl.dataobj.tcUserProvisionObject.insertImplementation(tcUserProvisionObject.java:283)
           at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:591)
           at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
           at oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:104)
           at oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:35)
           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.platform.kernel.impl.EventHandlerDynamicProxy.invoke(EventHandlerDynamicProxy.java:30)
           at $Proxy250.execute(Unknown Source)
           at oracle.iam.platform.kernel.impl.OrchProcessData.runActionEvents(OrchProcessData.java:1035)
           at oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:644)
           at oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:227)
           at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:669)
           at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:716)
           at oracle.iam.platform.kernel.impl.OrhestrationAsyncTask.execute(OrhestrationAsyncTask.java:108)
           at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:100)
           at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:70)
           at oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
           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 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.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 $Proxy311.onMessage(Unknown Source)
           at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:574)
           at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:477)
           at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:379)
           at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
           at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
           at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
           at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
           at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
           at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

           at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1522)
           at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
           at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
           at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
           at oracle.iam.platform.utils.vo.OIMDataSource.getConnection(OIMDataSource.java:57)
           at com.thortech.xl.util.DirectDB.getConnection(DirectDB.java:200)
           at com.thortech.xl.util.DirectDB.getConnection(DirectDB.java:148)
           at com.thortech.xl.dataaccess.tcDataBase.getConnection(tcDataBase.java:3198)
           at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:705)
           at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(tcDataBase.java:271)
           at com.thortech.xl.dataobj.tcDataBase.readStatement(tcDataBase.java:221)
           at com.thortech.xl.dataobj.tcDataBase.getError(tcDataBase.java:700)
           at com.thortech.xl.dataobj.tcDataObj.handleError(tcDataObj.java:1197)
           at com.thortech.xl.dataobj.tcDataObj.handleError(tcDataObj.java:1140)
           at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:487)
           at com.thortech.xl.dataobj.tcORC.insertNonConditionalMilestones(tcORC.java:844)
           at com.thortech.xl.dataobj.tcORC.completeSystemValidationMilestone(tcORC.java:1159)
           at com.thortech.xl.dataobj.tcOrderItemInfo.completeCarrierBaseMilestone(tcOrderItemInfo.java:735)
           at com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(tcOrderItemInfo.java:171)
           at com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:234)
           at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
           at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
           at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
           at com.thortech.xl.dataobj.tcORC.autoDOBSave(tcORC.java:2995)
           at com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(tcOrderPackages.java:526)
           at com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(tcOrderPackages.java:177)
           at com.thortech.xl.dataobj.tcOIU.provision(tcOIU.java:527)
           at com.thortech.xl.dataobj.tcOIU.eventPostInsert(tcOIU.java:303)
           at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
           at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
           at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
           at com.thortech.xl.dataobj.tcUserProvisionObject.insertImplementation(tcUserProvisionObject.java:283)
           at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:591)
           at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
           at oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:104)
           at oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:35)
           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.platform.kernel.impl.EventHandlerDynamicProxy.invoke(EventHandlerDynamicProxy.java:30)
           at $Proxy250.execute(Unknown Source)
           at oracle.iam.platform.kernel.impl.OrchProcessData.runActionEvents(OrchProcessData.java:1035)
           at oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:644)
           at oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:227)
           at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:669)
           at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:716)
           at oracle.iam.platform.kernel.impl.OrhestrationAsyncTask.execute(OrhestrationAsyncTask.java:108)
           at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:100)
           at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:70)
           at oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
           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 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.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 $Proxy311.onMessage(Unknown Source)
           at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:574)
           at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:477)
           at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:379)
           at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
           at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
           at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
           at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
           at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
           at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

      But when I try to provision this Resource through Access Policy, but without approving it works fine!!!

      Please, Help.

      Edited by: user13830503 on 19/7/2012 6:39