10 Replies Latest reply: Nov 20, 2012 7:24 AM by Le�ncio-Oracle RSS

    SSH Reconciliation Issue after applying BP4 for OIM11g

    Giuseppe
      Hi all,

      I'm facing an issue when trying to reconcile users between OIM11g and an SSH Target resource. In particulare, all worked well before applying the BP4 for OIM11g. I have a custom reconciliation rule that acts as mapper betweek an user's custom field called SSH, in which I enter the specific target account to reconcile, and the field Users.UserLogin of the SSH Form. The rule is specifically defined, through the design console, as "SSH equals Users.UserLogin". Now when I launch the SSH User Target Reconciliation for the specific host, OIM11g creates all the reconciliation events but does not link target accounts to IDM users (Not linked to any user).

      Does anyone know how can I overcome this issue? Reading the log it seems to be no one error.

      Thank you so much.

      Regards,
      Giuseppe.

      Edited by: Giuseppe on Nov 14, 2012 2:35 PM
        • 1. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
          Kevin Pinsky
          Did you click Create Reconciliation Profile on the resource object tab for reconciliation?

          -Kevin
          • 2. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
            Giuseppe
            Hi Kevin,

            yes I did, but nothing changes. Any other idea?

            Regards,
            Giuseppe.
            • 3. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
              Dhananjay Neeraj2
              During 10G days, following trick used to work:-


              Update obj set obj_recon_sequence = 0 where obj_name='SSH Resource Object'


              You may try that... After making this change, don't forget to click on the Create Recon Profile.
              • 4. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
                Giuseppe
                Hi dear,

                just tried to select the filed that you want me to update on... but it is already set to 0. I'm going slighly mad, I don't know how to get the reconciliation still working!

                Regards,
                Giuseppe.
                • 5. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
                  BikashBagaria
                  What state are your recon events in? 'Data Recieved', 'Event Recieved' ??? Check the recon_events table based on the job id as rj_key and see if you find something there.

                  -Bikash
                  • 6. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
                    Giuseppe
                    Hi Bikash,

                    my events are in "Data Received" status also after running the "Non scheduled batch recon" Job. If I understood well, it seems that the OIM doesn't trigger the Rule Based Linking. How is it possible? The reconciliation worked well before...

                    How can I try to solve this issue in such a way?

                    Thank you for your precious help.

                    Regards,
                    Giuseppe.
                    • 7. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
                      Giuseppe
                      I see this stacktrace on OIM Server Output:

                      oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00936: missing e
                      xpression
                      ORA-06512: at "PROD_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 1072
                      ORA-06512: at "PROD_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 90
                      ORA-06512: at line 1
                      at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
                      at oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1344)
                      at oracle.iam.reconciliation.dao.ReconActionDao.executeBulkAccountMatchCRUD(ReconActionDao.java:844)
                      at oracle.iam.reconciliation.impl.AccountHandler.executeBulkCUD(AccountHandler.java:72)
                      at oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:42)
                      at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:137)
                      at oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:92)
                      at oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)
                      at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:101)
                      at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:71)
                      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 $Proxy348.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)
                      Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
                      ORA-06512: at "PROD_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 1072
                      ORA-06512: at "PROD_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 90
                      ORA-06512: at line 1
                      • 8. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
                        Le�ncio-Oracle
                        Hey Giuseppe,

                        There is a open bug related of this issue: Bug 14493217 and note ID 1494023.1

                        pls, go to metalink and check it out.

                        I hope this helps,
                        Thiago Leoncio.
                        • 9. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
                          Giuseppe
                          Hi Leôncio,

                          this is exactly what I was looking for. But this is really sad: the patch bundle 04 resolves so many issues... and creates a new bigger one!

                          Thank you very much for your help.

                          Regards,
                          Giuseppe.
                          • 10. Re: SSH Reconciliation Issue after applying BP4 for OIM11g
                            Le�ncio-Oracle
                            Anytime, buddy!

                            Thiago Leoncio.