4 Replies Latest reply: Jun 14, 2013 5:47 AM by Ritesh Maddala RSS

    AD User Target Delete Recon throws The LookupCode 'null' does not exist

    user1134069
      Hi,

      running OIM 11.1.1.5.0 with MSFT_AD_Base_9.1.1.7.0 connector I've been struggling with "AD User Target Delete Recon" for a while to make it work, but with no success, so I ask the forum for advice.

      I've already ran this task in other environment with OIM 9.1.0.2 without problems, but with the new environment (11g) and latest version of AD Connector it's throwing the following error:

      +<23-abr-2012 15H38' CEST> <Error> <XELLERATE.APIS> <BEA-000000> <Class/Method: tcLookupOperationsBean/getLookupValuesFilteredData encounter some problems: The LookupCode 'null' does not exist.>+
      +<23-abr-2012 15H38' CEST> <Error> <OIMCP.ADCS> <BEA-000000> <====================================================>+
      +<23-abr-2012 15H38' CEST> <Error> <OIMCP.ADCS> <BEA-000000> <com.thortech.xl.integration.ActiveDirectory.tcUtilAttributeNameMap : getIntegrationAttributes(String, boolean, boolean) : null>+
      +<23-abr-2012 15H38' CEST> <Error> <OIMCP.ADCS> <BEA-000000> <====================================================+
      +>+
      +<23-abr-2012 15H38' CEST> <Error> <OIMCP.ADCS> <BEA-000000> <================= Start Stack Trace =======================>+
      +<23-abr-2012 15H38' CEST> <Error> <OIMCP.ADCS> <BEA-000000> <com.thortech.xl.integration.ActiveDirectory.tcUtilAttributeNameMap : getIntegrationAttributes(String, boolean, boolean)>+
      +<23-abr-2012 15H38' CEST> <Error> <OIMCP.ADCS> <BEA-000000> <null>+
      +<23-abr-2012 15H38' CEST> <Error> <OIMCP.ADCS> <BEA-000000> <Description : null>+
      +<23-abr-2012 15H38' CEST> <Error> <OIMCP.ADCS> <BEA-000000> <Thor.API.Exceptions.tcInvalidLookupException+
      at com.thortech.xl.ejb.beansimpl.tcLookupOperationsBean.getLookupValuesFilteredData(tcLookupOperationsBean.java:1422)
      at com.thortech.xl.ejb.beansimpl.tcLookupOperationsBean.getLookupValuesData(tcLookupOperationsBean.java:1335)
      at com.thortech.xl.ejb.beansimpl.tcLookupOperationsBean.getLookupValues(tcLookupOperationsBean.java:1318)
      at Thor.API.Operations.tcLookupOperationsIntfEJB.getLookupValuesx(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor2082.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 $Proxy355.getLookupValuesx(Unknown Source)
      at Thor.API.Operations.tcLookupOperationsIntf_qfl6u3_tcLookupOperationsIntfRemoteImpl.__WL_invoke(Unknown Source)
      at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
      at Thor.API.Operations.tcLookupOperationsIntf_qfl6u3_tcLookupOperationsIntfRemoteImpl.getLookupValuesx(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor2081.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:85)
      at $Proxy142.getLookupValuesx(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor2080.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
      at $Proxy350.getLookupValuesx(Unknown Source)
      at Thor.API.Operations.tcLookupOperationsIntfDelegate.getLookupValues(Unknown Source)
      at com.thortech.xl.integration.ActiveDirectory.tcUtilAttributeNameMap.getIntegrationAttributes(Unknown Source)
      at com.thortech.xl.integration.ActiveDirectory.tcUtilAttributeNameMap.getIntegrationAttributes(Unknown Source)
      at com.thortech.xl.schedule.tasks.ADDeleteReconTask.initialize(Unknown Source)
      at com.thortech.xl.schedule.tasks.ADDeleteReconTask.execute(Unknown Source)
      at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
      at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
      at sun.reflect.GeneratedMethodAccessor1513.invoke(Unknown Source)
      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:196)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
      +>+
      +<23-abr-2012 15H38' CEST> <Error> <OIMCP.ADCS> <BEA-000000> <================= End Stack Trace =======================>+

      I've looked in documentation and found nothing but the description of the scheduled task's attributes. Here's how I've set the task's attributes:

      ADCS TimeStamp          20120418141118.0Z
      Configuration Lookup          Lookup.AD.Configuration
      IT Resource Name          ADITResource
      Search Filter               (objectClass=user)
      Target Resource Object     AD User
      Task Scheduler Name          AD User Target Delete Recon

      Note that both provisioning and 'AD User Target Recon' works ok.

      Trying to find where does it get that 'null' LookupCode I've even capture packets between OIM and database and found this suspicious query:

      select lku_key from lku where lku_type_string_key = 'null' and lku_type = 'l'

      It seems that for some reason the scheduled task is searching some lookup called 'null' but no idea of why.

      Does anyone experienced the same issue? Any thoughts?
      Thanks in advance.
        • 1. Re: AD User Target Delete Recon throws The LookupCode 'null' does not exist
          Saurabh Tripathi
          Hi,

          try for one user change the search filter :-

          Search Filter (objectClass=user) -> Search Filter (sAMAccountName=ABC)

          ABC is your user's sAMAccountName.

          let me know it is working fine or giving same error.


          Thanks
          • 2. Re: AD User Target Delete Recon throws The LookupCode 'null' does not exist
            user1134069
            Thanks for the response.

            I've tried to change the Seach Filter to samaccountname but keeps giving the same error.
            • 4. Re: AD User Target Delete Recon throws The LookupCode 'null' does not exist
              Ritesh Maddala

              Hi

               

              I am also receiving the same exception during the target reconciliation of users

              Here is the log

               

              [2013-06-14T10:37:18.523+00:00] [oim_server1] [ERROR] [] [XELLERATE.APIS] [tid: OIMQuartzScheduler_Worker-3] [userId: oiminternal] [ecid: 0000Jx1ueU8CknC5VFL6ic1Hihiv000003,1:30894] [APP: oim#11.1.2.0.0] Class/Method: tcLookupOperationsBean/getLookupValuesFilteredData encounter some problems: The LookupCode 'null' does not exist.

              [2013-06-14T10:37:18.532+00:00] [oim_server1] [ERROR] [] [XL_INTG.SJSDS] [tid: OIMQuartzScheduler_Worker-3] [userId: oiminternal] [ecid: 0000Jx1ueU8CknC5VFL6ic1Hihiv000003,1:30894] [APP: oim#11.1.2.0.0] ====================================================

              [2013-06-14T10:37:18.532+00:00] [oim_server1] [ERROR] [] [XL_INTG.SJSDS] [tid: OIMQuartzScheduler_Worker-3] [userId: oiminternal] [ecid: 0000Jx1ueU8CknC5VFL6ic1Hihiv000003,1:30894] [APP: oim#11.1.2.0.0] com.thortech.xl.integration.iplanet.util.tcUtilAttributeNameMap : getIntegrationAttributes : null

              [2013-06-14T10:37:18.532+00:00] [oim_server1] [ERROR] [] [XL_INTG.SJSDS] [tid: OIMQuartzScheduler_Worker-3] [userId: oiminternal] [ecid: 0000Jx1ueU8CknC5VFL6ic1Hihiv000003,1:30894] [APP: oim#11.1.2.0.0] ====================================================[[

               

               

              ]]

              [2013-06-14T10:37:18.559+00:00] [oim_server1] [ERROR] [] [XL_INTG.SJSDS] [tid: OIMQuartzScheduler_Worker-3] [userId: oiminternal] [ecid: 0000Jx1ueU8CknC5VFL6ic1Hihiv000003,1:30894] [APP: oim#11.1.2.0.0] com.thortech.xl.integration.iplanet.recon.schedule.tasks.tcTskIPlanetUserReconciliation : init() : : Init Failed

              [2013-06-14T10:37:18.560+00:00] [oim_server1] [ERROR] [] [XL_INTG.SJSDS] [tid: OIMQuartzScheduler_Worker-3] [userId: oiminternal] [ecid: 0000Jx1ueU8CknC5VFL6ic1Hihiv000003,1:30894] [APP: oim#11.1.2.0.0] com.thortech.xl.integration.iplanet.recon.schedule.tasks.tcTskIPlanetUserReconciliation : execute() :  Variables not initialized properly. Terminating !!!!!!!!

              [2013-06-14T10:37:18.589+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-3] [userId: oiminternal] [ecid: 0000Jx1ueU8CknC5VFL6ic1Hihiv000003,1:30894] [APP: oim#11.1.2.0.0] Job Listener, Job was executed  QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.iPlanet User Target Recon Task Name iPlanet User Target Recon Task

              [2013-06-14T10:37:27.947+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.reconciliation.utils] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 9dc06a0ef6659213:-60ebad79:13f41ea5606:-8000-00000000000004ee,0] [APP: oim#11.1.2.0.0] User 1 is granted access to operation SEARCH_EVENT

              [2013-06-14T10:37:27.952+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.reconciliation.agentry.reconEvent] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 9dc06a0ef6659213:-60ebad79:13f41ea5606:-8000-00000000000004ee,0] [APP: oim#11.1.2.0.0] Reconciliation Search: Counted Size = 23.

              [2013-06-14T10:37:27.953+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.reconciliation.agentry.reconEvent] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 9dc06a0ef6659213:-60ebad79:13f41ea5606:-8000-00000000000004ee,0] [APP: oim#11.1.2.0.0] Reconciliation Search: Starting to Fetch...

              [2013-06-14T10:37:27.954+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.reconciliation.agentry.reconEvent] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 9dc06a0ef6659213:-60ebad79:13f41ea5606:-8000-00000000000004ee,0] [APP: oim#11.1.2.0.0] Reconciliation Search: Starting to Fetch...

              [2013-06-14T10:37:27.961+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.reconciliation.utils] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 9dc06a0ef6659213:-60ebad79:13f41ea5606:-8000-00000000000004ee,0] [APP: oim#11.1.2.0.0] User 1 is granted access to operation SEARCH_EVENT

              [2013-06-14T10:37:27.971+00:00] [oim_server1] [NOTIFICATION] [] [oracle.iam.reconciliation.agentry.reconEvent] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 9dc06a0ef6659213:-60ebad79:13f41ea5606:-8000-00000000000004ee,0] [APP: oim#11.1.2.0.0] Reconciliation Search: Search Results size = 23.

              [2013-06-14T10:37:27.971+00:00] [oim_server1

              what is the problem ...can any boby help me on this.

               

              Regards

              Ritesh