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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 5 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>]

    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