java.sql.SQLException: ORA-01436: CONNECT BY loop in user data

Oracle Community | GVC_OIM | 3 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

    OIM PostProcess Event Handlers

    Oracle Community | 1 month ago | Muhammad Kashif Ali
    java.sql.SQLException: ORA-01436: CONNECT BY loop in user data
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    Is there a way where we can set the headers from custom plugin

    Oracle Community | 4 years ago | abhay kumar
    java.sql.SQLException: ORA-01465: invalid hex number
  4. 0

    Passing complete sql query as a parameter to dataset in report

    Stack Overflow | 4 years ago | Bhaskar
    java.sql.SQLException: SQL string is not Query
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-01436: CONNECT BY loop in user data

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:924)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
    13 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
    1 frame
  4. oracle.iam.identity
    UserManagerProviderImpl.isUserManagerOf
    1. oracle.iam.identity.usermgmt.internal.impl.UserManagerInternalImpl.isUserManagerOf(UserManagerInternalImpl.java:95)
    2. oracle.iam.identity.usermgmt.impl.UserManagerProviderImpl.isUserManagerOf(UserManagerProviderImpl.java:59)
    2 frames
  5. oracle.iam.platform
    AuthorizationServiceImpl.hasAccess
    1. oracle.iam.platform.authz.vo.InternalObligation.validate(InternalObligation.java:266)
    2. oracle.iam.platform.authz.impl.OESAuthzServiceImpl.doCheckAccess(OESAuthzServiceImpl.java:241)
    3. oracle.iam.platform.authz.impl.OESAuthzServiceImpl.hasAccess(OESAuthzServiceImpl.java:187)
    4. oracle.iam.platform.authz.impl.AuthorizationServiceImpl.hasAccess(AuthorizationServiceImpl.java:185)
    4 frames
  6. oracle.iam.identity
    UserManagerEJB.getDetailsx
    1. oracle.iam.identity.usermgmt.utils.UserManagerUtils.getAuthorizedLookupableAttrs(UserManagerUtils.java:150)
    2. oracle.iam.identity.usermgmt.impl.UserManagerImpl.getDetails(UserManagerImpl.java:1556)
    3. oracle.iam.identity.usermgmt.api.UserManagerEJB.getDetailsx(Unknown Source)
    3 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor3304.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames