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]

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

      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.UserHandler.getMatchingKeys(UserHandler.java:601)
      4. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:556)
      5. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:535)
      5 frames
    3. Java RT
      GeneratedMethodAccessor3188.invoke
      1. sun.reflect.GeneratedMethodAccessor3188.invoke(Unknown Source)
      1 frame