9 Replies Latest reply: Mar 25, 2013 8:17 AM by oimcoder RSS

    DBAT recon error in OIM 11g

    957307
      Below are the error when do recon from DB

      [2013-03-20T15:26:29.711+00:00] [oim_server1] [ERROR] [] [XELLERATE.GC.FRAMEWORKRECONCILIATION] [tid: OIMQuartzScheduler_Worker-5] [userId: oiminternal] [ecid: 0000Jq7uBGDAlJG5yzo2yW1HIRHW000002,0] [APP: oim#11.1.1.3.0] Reconciliation Encountered error: [[
      java.lang.NullPointerException
           at java.util.Hashtable.put(Hashtable.java:394)
           at com.thortech.xl.gc.impl.common.DBFacade.retrieveRecord(Unknown Source)
           at com.thortech.xl.gc.impl.common.DBFacade.getRecord(Unknown Source)
           at com.thortech.xl.gc.impl.common.DBFacade.getTargetRecord(Unknown Source)
           at com.thortech.xl.gc.impl.recon.DBReconTransportProvider.getFirstPage(Unknown Source)
           at com.thortech.xl.gc.runtime.GCScheduleTask.execute(GCScheduleTask.java:103)
           at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
           at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
           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:196)
           at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
           at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
        • 1. Re: DBAT recon error in OIM 11g
          ramandeep singh - oracle
          check whether you have created a key field in reconciliation key field mapping ? There has to be atleast one key field mapping.
          • 2. Re: DBAT recon error in OIM 11g
            957307
            Already UserId is mapped to Key Field for Reconcilation Mapping.
            • 3. Re: DBAT recon error in OIM 11g
              957307
              Can any one give a approach to solve the issue....

              Thanks,
              Rama
              • 4. Re: DBAT recon error in OIM 11g
                Vamsi Krishna
                Let us know if you are running trusted or target recon?

                Cheers,
                Vamsi.
                • 5. Re: DBAT recon error in OIM 11g
                  957307
                  Hi Vamsi,

                  Thanks for the reply we are doing Trusted Recon from MS SQL Server.

                  Rama.
                  • 6. Re: DBAT recon error in OIM 11g
                    Vamsi Krishna
                    Did you specify the unique parameter attribute in the connection parameters screen.
                    After that, did you specify the matching only checked for atleast one attribute in the mapping screen.

                    And, Verify if you have got any reconcilation events that are generated under: Advanced > Event Management > Search for reconciliation events.

                    Cheers,
                    Vamsi.
                    • 7. Re: DBAT recon error in OIM 11g
                      957307
                      Hi Vamsi,

                      Yes i specified the unique parameter attribute in the connection parameters screen. (unique-attribute: userid)
                      and also specified the matching only for one attribute in the mapping screen.
                      The below is the log file generated when i run the Scheduler.


                      [2013-03-22T12:31:50.598+00:00] [oim_server1] [ERROR] [] [XELLERATE.GC.FRAMEWORKRECONCILIATION] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 0000JqD^NB^AlJG5yzo2yW1HImT1000002,0] [APP: oim#11.1.1.3.0] Reconciliation Encountered error: [[
                      java.lang.NullPointerException
                           at java.util.Hashtable.put(Hashtable.java:394)
                           at com.thortech.xl.gc.impl.common.DBFacade.retrieveRecord(Unknown Source)
                           at com.thortech.xl.gc.impl.common.DBFacade.getRecord(Unknown Source)
                           at com.thortech.xl.gc.impl.common.DBFacade.getTargetRecord(Unknown Source)
                           at com.thortech.xl.gc.impl.recon.DBReconTransportProvider.getFirstPage(Unknown Source)
                           at com.thortech.xl.gc.runtime.GCScheduleTask.execute(GCScheduleTask.java:103)
                           at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
                           at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
                           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:196)
                           at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
                           at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

                      ]]
                      [2013-03-22T12:31:50.599+00:00] [oim_server1] [WARNING] [] [XELLERATE.GC.FRAMEWORKRECONCILIATION] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 0000JqD^NB^AlJG5yzo2yW1HImT1000002,0] [APP: oim#11.1.1.3.0] Though Reconciliation Scheduled task has encountered an error, Reconciliation Transport providers have been "ended" smoothly. Any provider operation that occurs during that "end" or "clean-up" phase would have been executed e.g. Data archival. In case you want that data to be a part of next Reconciliation execution, restore it from Staging. Provider logs must be containing details about storage entities that would have been archived
                      [2013-03-22T12:31:50.619+00:00] [oim_server1] [NOTIFICATION] [IAM-1020005] [oracle.iam.scheduler.impl.quartz] [tid: OIMQuartzScheduler_Worker-6] [userId: oiminternal] [ecid: 0000JqD^NB^AlJG5yzo2yW1HImT1000002,0] [APP: oim#11.1.1.3.0] Job Listener, Job was executed QuartzJobListener.jobWasExecuted Description null FullName DEFAULT.DBNEW_GTC Name DBNEW_GTC
                      [2013-03-22T12:31:55.521+00:00] [oim_server1] [NOTIFICATION] [IAM-0060016] [oracle.iam.platform.auth.impl] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 78809a203c5b4cc7:52ddfbb9:13d8d9156ec:-8000-0000000000000d0c,0] [APP: oim#11.1.1.3.0] The IP address from which browser is triggered is 10.16.20.99
                      [2013-03-22T12:31:55.680+00:00] [oim_server1] [NOTIFICATION] [IAM-1010010] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 78809a203c5b4cc7:52ddfbb9:13d8d9156ec:-8000-0000000000000d0c,0] [APP: oim#11.1.1.3.0] ********** Entering the Authorization Segment with parameters:: LoggedInUserId = 1, target resourceID = null, Feature = SCHEDULER, Action = JOB_MODIFY **********
                      [2013-03-22T12:31:55.681+00:00] [oim_server1] [NOTIFICATION] [IAM-1010029] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 78809a203c5b4cc7:52ddfbb9:13d8d9156ec:-8000-0000000000000d0c,0] [APP: oim#11.1.1.3.0] OES Results found in cache with Key F: SCHEDULERS: 1P: JOB_MODIFYOESDefinition
                      [2013-03-22T12:31:55.681+00:00] [oim_server1] [NOTIFICATION] [IAM-1010021] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 78809a203c5b4cc7:52ddfbb9:13d8d9156ec:-8000-0000000000000d0c,0] [APP: oim#11.1.1.3.0] Validating the Internal Obligations: [InternalObligation: name: noop, values: [true], convertToObligation: false, InternalObligation: name: noop, values: [true], convertToObligation: false]
                      [2013-03-22T12:31:55.681+00:00] [oim_server1] [NOTIFICATION] [IAM-1010022] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 78809a203c5b4cc7:52ddfbb9:13d8d9156ec:-8000-0000000000000d0c,0] [APP: oim#11.1.1.3.0] ---------- The list of Internal Obligation is satisfied, returning TRUE ----------
                      [2013-03-22T12:31:55.681+00:00] [oim_server1] [NOTIFICATION] [IAM-1010026] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: 78809a203c5b4cc7:52ddfbb9:13d8d9156ec:-8000-0000000000000d0c,0] [APP: oim#11.1.1.3.0] ********** Exiting the Authorization Segment with result Decision :PERMIT[[
                      Obligations from policy: **********
                      ]]

                      Thanks.
                      • 8. Re: DBAT recon error in OIM 11g
                        Vamsi Krishna
                        Do you see any reconciliation events that have come as shown in the previous post:
                        Go to Advanced console > Click on Event Management > Search for reconciliation events
                        Check if there were any events that were generated recently.

                        Cheers,
                        Vamsi.
                        • 9. Re: DBAT recon error in OIM 11g
                          oimcoder
                          not sure if this helps but the DBAT connector does not support MSSQL NVARCHAR fields in the table. NVARCHAR fields will cause a NPE since the connector cannot find the data type.

                          Edited by: oimcoder on Mar 25, 2013 6:16 AM