2 Replies Latest reply: Dec 6, 2011 2:30 AM by 903833 RSS

    Problem with Database_App_Tables_9.1.0.5.0 Connector

    903833
      Hi All,

      I am using Oracle Identity and Access Management 11g (11.1.1.5.0) and have configured the Database App Tables GTC for Trust Source Reconciliation. I am trying to implement the example configuration as specified in Appendix A of Connector Guide for Database Application Tables Release 9.1.0. However, I am getting the exception below:

      <06 Dec 2011 8:20:49 AM> <Error> <oracle.iam.reconciliation.dao> <IAM-5010001> <Calling stored procedure - XL_SP_RECONEVALUATEUSER
      strTargetTableName_in=RA_ACMEHRGTC6
      strRequiredAttributesList_in=RECON_LAST_NAME,RECON_USR_LOGIN,RECON_FIRST_NAME
      strMatchingRule_in=(((USR.USR_LOGIN=RA_ACMEHRGTC6.RECON_USR_LOGIN)))
      intEventKey_in=15
      intUserKey_in=5>
      <06 Dec 2011 8:20:50 AM> <Warning> <oracle.iam.callbacks.common> <IAM-2030146> <[CALLBACKMSG] Are applicable policies present for this async eventhandler ? : false>
      <06 Dec 2011 8:20:52 AM> <Error> <Default> <BEA-000000> <Failed to communicate with any of configured Access Server, ensure that it is up and running.>
      <06 Dec 2011 8:20:52 AM> <Error> <oracle.iam.identity.usermgmt.impl.handlers.create> <IAM-3051103> <The create operation on user entity failed in action stage.
      oracle.iam.platform.entitymgr.MissingRequiredAttributeException: [Xellerate Type]
      at oracle.iam.platform.entitymgr.impl.EntityManagerImpl.checkRequired(EntityManagerImpl.java:1450)
      at oracle.iam.platform.entitymgr.impl.EntityManagerImpl.createEntity(EntityManagerImpl.java:263)
      at oracle.iam.platform.entitymgr.impl.EntityManagerImpl.createEntity(EntityManagerImpl.java:239)
      at oracle.iam.identity.usermgmt.impl.handlers.create.CreateUserActionHandler.execute(CreateUserActionHandler.java:153)
      at oracle.iam.identity.usermgmt.impl.handlers.create.CreateUserActionHandler.execute(CreateUserActionHandler.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 oracle.iam.platform.kernel.impl.EventHandlerDynamicProxy.invoke(EventHandlerDynamicProxy.java:30)
      at $Proxy251.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:664)
      at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.process(OrchestrationEngineImpl.java:435)
      at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.orchestrate(OrchestrationEngineImpl.java:381)
      at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.orchestrate(OrchestrationEngineImpl.java:344)
      at oracle.iam.reconciliation.impl.UserHandler.orchestrate(UserHandler.java:210)
      at oracle.iam.reconciliation.impl.UserHandler.create(UserHandler.java:153)
      at oracle.iam.reconciliation.impl.UserHandler.applyRule(UserHandler.java:91)
      at oracle.iam.reconciliation.impl.UserHandler.process(UserHandler.java:66)
      at oracle.iam.reconciliation.impl.ActionEngine.processEvent(ActionEngine.java:194)
      at oracle.iam.reconciliation.impl.ActionEngine.processEvent(ActionEngine.java:156)
      at oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:94)
      at oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)
      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 $Proxy330.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)

      My mappings between ACMEHR (in Reconciliation Staging) and User (in OIM) are as follows:

      EMPLOYEE_ID -> User Login
      FIRST_NAME -> First Name
      LAST_NAME -> Last Name
      EMAIL -> Email
      PHONE_NUMBER -> Telephone Number
      HIRE_DATE -> Hire Date
      STATUS -> Status
      Organization -> Organization
      Employee Type -> Role
      User Type -> User Type

      Any assistance will be appreciated...