oracle.iam.reconciliation.exception.DBAccessException: Failed SQL:: SELECT UD_ADUSER.UD_ADUSER_KEY UD_ADUSER_KEY,UD_ADUSER.ORC_KEY ORC_KEY FROM UD_ADUSER,OIU, OST WHERE UD_ADUSER_STREET is null and UD_ADUSER_IPPHONE is null and UD_ADUSER_EXPIRATIONDATE is null and UD_ADUSER_TELEPHONE is null and UD_ADUSER_ALLOW_LOGIN is null and UD_ADUSER_TITLE is null and UD_ADUSER_COMPANY is null and UD_ADUSER_DEPARTMENT is null and UD_ADUSER_PAGER is null and UD_ADUSER_OFFICE is null and UD_ADUSER_FULLNAME=? and UD_ADUSER_LOCKED=? and UD_ADUSER_HOMEPHONE is null and UD_ADUSER_FAX is null and UD_ADUSER_UID=? and UD_ADUSER_FNAME=? and UD_ADUSER_TERMINAL_HDIR is null and UD_ADUSER_TERMINAL_PPATH is null and UD_ADUSER_USERPRINCIPALNAME=? and UD_ADUSER_NEVER=? and UD_ADUSER_SERVER=? and UD_ADUSER_CITY is null and UD_ADUSER_LNAME=? and UD_ADUSER_MANAGER is null and UD_ADUSER_ZIP is null and UD_ADUSER_COUNTRY is null and UD_ADUSER_POSTOFFICE is null and UD_ADUSER_MNAME is null and UD_ADUSER_MUST=? and UD_ADUSER_COMMONNAME=? and UD_ADUSER_ORGNAME=? and UD_ADUSER_EMAIL is null and UD_ADUSER_STATE is null and UD_ADUSER_MOBILE is null and UD_ADUSER_OBJECTGUID=? and OIU.OST_KEY=OST.OST_KEY AND OIU.ORC_KEY=UD_ADUSER.ORC_KEY and (UD_ADUSER.UD_ADUSER_OBJECTGUID=? AND UD_ADUSER.UD_ADUSER_SERVER=?) AND (upper(OST.OST_STATUS)='ENABLED' OR upper(OST.OST_STATUS) = 'PROVISIONED') =>PARAMS:: [madhavi, 0, madhavi, madhavi, madhavi@odc.com, 0, 21, madhavi, 0, madhavi, 21~OU=Users1,DC=odc,DC=com, <GUID=afffa20f845f9e4880b55dd298968b8c>, 21, <GUID=afffa20f845f9e4880b55dd298968b8c>]

Oracle Community | 856562 | 4 years ago
  1. 0

    Target Recon in OIM 11G R2 using AD 11.1.1.5&#160; connector

    Oracle Community | 4 years ago | 856562
    oracle.iam.reconciliation.exception.DBAccessException: Failed SQL:: SELECT UD_ADUSER.UD_ADUSER_KEY UD_ADUSER_KEY,UD_ADUSER.ORC_KEY ORC_KEY FROM UD_ADUSER,OIU, OST WHERE UD_ADUSER_STREET is null and UD_ADUSER_IPPHONE is null and UD_ADUSER_EXPIRATIONDATE is null and UD_ADUSER_TELEPHONE is null and UD_ADUSER_ALLOW_LOGIN is null and UD_ADUSER_TITLE is null and UD_ADUSER_COMPANY is null and UD_ADUSER_DEPARTMENT is null and UD_ADUSER_PAGER is null and UD_ADUSER_OFFICE is null and UD_ADUSER_FULLNAME=? and UD_ADUSER_LOCKED=? and UD_ADUSER_HOMEPHONE is null and UD_ADUSER_FAX is null and UD_ADUSER_UID=? and UD_ADUSER_FNAME=? and UD_ADUSER_TERMINAL_HDIR is null and UD_ADUSER_TERMINAL_PPATH is null and UD_ADUSER_USERPRINCIPALNAME=? and UD_ADUSER_NEVER=? and UD_ADUSER_SERVER=? and UD_ADUSER_CITY is null and UD_ADUSER_LNAME=? and UD_ADUSER_MANAGER is null and UD_ADUSER_ZIP is null and UD_ADUSER_COUNTRY is null and UD_ADUSER_POSTOFFICE is null and UD_ADUSER_MNAME is null and UD_ADUSER_MUST=? and UD_ADUSER_COMMONNAME=? and UD_ADUSER_ORGNAME=? and UD_ADUSER_EMAIL is null and UD_ADUSER_STATE is null and UD_ADUSER_MOBILE is null and UD_ADUSER_OBJECTGUID=? and OIU.OST_KEY=OST.OST_KEY AND OIU.ORC_KEY=UD_ADUSER.ORC_KEY and (UD_ADUSER.UD_ADUSER_OBJECTGUID=? AND UD_ADUSER.UD_ADUSER_SERVER=?) AND (upper(OST.OST_STATUS)='ENABLED' OR upper(OST.OST_STATUS) = 'PROVISIONED') =>PARAMS:: [madhavi, 0, madhavi, madhavi, madhavi@odc.com, 0, 21, madhavi, 0, madhavi, 21~OU=Users1,DC=odc,DC=com, <GUID=afffa20f845f9e4880b55dd298968b8c>, 21, <GUID=afffa20f845f9e4880b55dd298968b8c>]
  2. 0

    User not created in OIM 11gr2 - trusted reconciliation from OID

    Oracle Community | 4 years ago | 973950
    oracle.iam.reconciliation.exception.DBAccessException: Failed SQL:: select USR_KEY from usr where USR_MIDDLE_NAME is null and USR_UDF_ORCLGUID=? and USR_FIRST_NAME=? and USR_EMAIL=? and USR_LAST_NAME=? and USR_STATUS=? and USR.USR_STATUS != 'Deleted' AND ((UPPER(USR.USR_LOGIN)=UPPER(RA_OIDTRUSTEDUSERBCBD344A.RA_USERLOGIN7C7B96D4))) =>PARAMS:: [CF7C29EE75F5A78FE040A8C084000DE8, orcladmin, orcladmin, orcladmin, Enabled]
  3. 0

    Error encountered during recon profile creation

    Oracle Community | 2 years ago | 921074
    oracle.iam.reconciliation.exception.DBAccessException: Failed SQL:: SELECT OBJ_KEY FROM OBJ WHERE OBJ_NAME = ? =>PARAMS:: [LDAP User]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.iam.reconciliation.exception.DBAccessException

      Failed SQL:: SELECT UD_ADUSER.UD_ADUSER_KEY UD_ADUSER_KEY,UD_ADUSER.ORC_KEY ORC_KEY FROM UD_ADUSER,OIU, OST WHERE UD_ADUSER_STREET is null and UD_ADUSER_IPPHONE is null and UD_ADUSER_EXPIRATIONDATE is null and UD_ADUSER_TELEPHONE is null and UD_ADUSER_ALLOW_LOGIN is null and UD_ADUSER_TITLE is null and UD_ADUSER_COMPANY is null and UD_ADUSER_DEPARTMENT is null and UD_ADUSER_PAGER is null and UD_ADUSER_OFFICE is null and UD_ADUSER_FULLNAME=? and UD_ADUSER_LOCKED=? and UD_ADUSER_HOMEPHONE is null and UD_ADUSER_FAX is null and UD_ADUSER_UID=? and UD_ADUSER_FNAME=? and UD_ADUSER_TERMINAL_HDIR is null and UD_ADUSER_TERMINAL_PPATH is null and UD_ADUSER_USERPRINCIPALNAME=? and UD_ADUSER_NEVER=? and UD_ADUSER_SERVER=? and UD_ADUSER_CITY is null and UD_ADUSER_LNAME=? and UD_ADUSER_MANAGER is null and UD_ADUSER_ZIP is null and UD_ADUSER_COUNTRY is null and UD_ADUSER_POSTOFFICE is null and UD_ADUSER_MNAME is null and UD_ADUSER_MUST=? and UD_ADUSER_COMMONNAME=? and UD_ADUSER_ORGNAME=? and UD_ADUSER_EMAIL is null and UD_ADUSER_STATE is null and UD_ADUSER_MOBILE is null and UD_ADUSER_OBJECTGUID=? and OIU.OST_KEY=OST.OST_KEY AND OIU.ORC_KEY=UD_ADUSER.ORC_KEY and (UD_ADUSER.UD_ADUSER_OBJECTGUID=? AND UD_ADUSER.UD_ADUSER_SERVER=?) AND (upper(OST.OST_STATUS)='ENABLED' OR upper(OST.OST_STATUS) = 'PROVISIONED') =>PARAMS:: [madhavi, 0, madhavi, madhavi, madhavi@odc.com, 0, 21, madhavi, 0, madhavi, 21~OU=Users1,DC=odc,DC=com, <GUID=afffa20f845f9e4880b55dd298968b8c>, 21, <GUID=afffa20f845f9e4880b55dd298968b8c>]

      at oracle.iam.reconciliation.utils.DBAccessTemplate.executeQuery()
    2. oracle.iam.reconciliation
      ReconOperationsServiceImpl.ignoreEvent
      1. oracle.iam.reconciliation.utils.DBAccessTemplate.executeQuery(DBAccessTemplate.java:71)
      2. oracle.iam.reconciliation.impl.BaseEntityTypeHandler.executeSql(BaseEntityTypeHandler.java:508)
      3. oracle.iam.reconciliation.impl.AccountHandler.getMatchingKeys(AccountHandler.java:818)
      4. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:555)
      5. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:535)
      5 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    4. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    5. oracle.iam.platform
      DMSMethodInterceptor.invoke
      1. oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25)
      1 frame
    6. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    7. Unknown
      $Proxy444.ignoreEvent
      1. $Proxy444.ignoreEvent(Unknown Source)
      1 frame
    8. Thor.API.Operations
      tcReconciliationOperationsIntfEJB.ignoreEventx
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB.ignoreEventx(Unknown Source)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    10. com.bea.core
      ReflectiveMethodInvocation.proceed
      1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
      2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      6 frames
    11. com.oracle.pitchfork
      MethodInvocationVisitorImpl.visit
      1. com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
      1 frame