oracle.iam.reconciliation.exception.DBAccessException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

    • 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(DBAccessTemplate.java:71) at oracle.iam.reconciliation.impl.BaseEntityTypeHandler.executeSql(BaseEntityTypeHandler.java:508) at oracle.iam.reconciliation.impl.AccountHandler.getMatchingKeys(AccountHandler.java:818) at oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:555) at oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:535) 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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy444.ignoreEvent(Unknown Source) at Thor.API.Operations.tcReconciliationOperationsIntfEJB.ignoreEventx(Unknown Source) 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.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.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
    No Bugmate found.