oracle.iam.reconciliation.exception.DBAccessException: Failed SQL:: SELECT OBJ_KEY FROM OBJ WHERE OBJ_NAME = ? =>PARAMS:: [LDAP User]

Oracle Community | 921074 | 2 years ago
  1. 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]
  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

    Target Recon in OIM 11G R2 using AD 11.1.1.5  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>]
  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 OBJ_KEY FROM OBJ WHERE OBJ_NAME = ? =>PARAMS:: [LDAP User]

      at oracle.iam.reconciliation.utils.DBAccessTemplate.executeQuery()
    2. oracle.iam.reconciliation
      ProfileManagerImpl.configure
      1. oracle.iam.reconciliation.utils.DBAccessTemplate.executeQuery(DBAccessTemplate.java:71)
      2. oracle.iam.reconciliation.dao.ReconActionDao.getOBJKey(ReconActionDao.java:1595)
      3. oracle.iam.reconciliation.impl.config.ExtendedProfile.<init>(ExtendedProfile.java:20)
      4. oracle.iam.reconciliation.impl.config.ProfileManagerImpl.putInCache(ProfileManagerImpl.java:184)
      5. oracle.iam.reconciliation.impl.config.ProfileManagerImpl.configure(ProfileManagerImpl.java:108)
      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.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      1 frame
    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
      $Proxy881.configure
      1. $Proxy881.configure(Unknown Source)
      1 frame
    8. oracle.iam.reconciliation
      ReconConfigServiceImpl.configureProfile
      1. oracle.iam.reconciliation.impl.ReconConfigServiceImpl.configureProfile(ReconConfigServiceImpl.java:53)
      1 frame
    9. Java RT
      NativeMethodAccessorImpl.invoke0
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      1 frame