java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (IAMTEST_OIM.FK_ORC_ORD) violated - parent key n ot found ORA-06512: at "IAMTEST_OIM.OIM_USER_MGMT", line 858 ORA-06512: at line 1 Error Code: 2291 Call: BEGIN OIM_USER_MGMT.BulkUserModify(p_intUserKey=>?, p_arUSRList=>?, p_arColumnlist=>?, p_arColumnValue=>?, p_arMLSColLocaleValue=>?, p_intReturnC ode_out=>?, p_strErrMessage_out=>?); END; bind => [1, oracle.sql.ARRAY@199c54c1, oracle.sql.ARRAY@199c6768, oracle.sql.ARRAY@199c489c, oracle.sql.ARRAY@199c6167, => p_intReturnCode_out, => p_strErrMessage_out] Query: DataReadQuery()

Oracle Community | 947122 | 4 years ago
  1. 0

    Error updating user's Organization

    Oracle Community | 4 years ago | 947122
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (IAMTEST_OIM.FK_ORC_ORD) violated - parent key n ot found ORA-06512: at "IAMTEST_OIM.OIM_USER_MGMT", line 858 ORA-06512: at line 1 Error Code: 2291 Call: BEGIN OIM_USER_MGMT.BulkUserModify(p_intUserKey=>?, p_arUSRList=>?, p_arColumnlist=>?, p_arColumnValue=>?, p_arMLSColLocaleValue=>?, p_intReturnC ode_out=>?, p_strErrMessage_out=>?); END; bind => [1, oracle.sql.ARRAY@199c54c1, oracle.sql.ARRAY@199c6768, oracle.sql.ARRAY@199c489c, oracle.sql.ARRAY@199c6167, => p_intReturnCode_out, => p_strErrMessage_out] Query: DataReadQuery()
  2. 0

    parent key not found error  via a two level One-To-Many relationship

    Oracle Community | 8 years ago | 696567
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (OBJDEV.COL_VALUE_ALL_COL_OBJECT_FK1) violated - parent key not found Error Code: 2291 Call: INSERT INTO COL_VALUE_ALL (ID, NOTES, val_number, OBJECT_ID, PROPERTY_ID, DTYPE) VALUES (?, ?, ?, ?, ?, ?) bind => [238, test, 11.0, 299, 47, 1] Query: InsertObjectQuery(genedata.expressionist.collector.dom.ValueNumber@15e0638)
  3. 0

    Missing class indicator field from database row

    Oracle Community | 8 years ago | 696567
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (OBJDEV.COL_VALUE_ALL_COL_OBJECT_FK1) violated - parent key not found Error Code: 2291 Call: INSERT INTO COL_VALUE_ALL (ID, NOTES, OBJECT_ID, PROPERTY_ID, DTYPE) VALUES (?, ?, ?, ?, ?) bind => [197, test, 243, 47, 1] Query: InsertObjectQuery(collector.dom.ValueNumber@9b86ea)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error in My Blackboard Settings - Ask The MVPs

    blackboard.com | 11 months ago
    blackboard.persist.PersistenceException: A database error occurred.
  6. 0

    Integrity constraint violated just when I commit the transaction

    Stack Overflow | 4 years ago | Julio
    java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (PERPLADM.ADDRESS_EMPLOYEE_FK) violated - parent key not found

    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.SQLIntegrityConstraintViolationException

      ORA-02291: integrity constraint (IAMTEST_OIM.FK_ORC_ORD) violated - parent key n ot found ORA-06512: at "IAMTEST_OIM.OIM_USER_MGMT", line 858 ORA-06512: at line 1 Error Code: 2291 Call: BEGIN OIM_USER_MGMT.BulkUserModify(p_intUserKey=>?, p_arUSRList=>?, p_arColumnlist=>?, p_arColumnValue=>?, p_arMLSColLocaleValue=>?, p_intReturnC ode_out=>?, p_strErrMessage_out=>?); END; bind => [1, oracle.sql.ARRAY@199c54c1, oracle.sql.ARRAY@199c6768, oracle.sql.ARRAY@199c489c, oracle.sql.ARRAY@199c6167, => p_intReturnCode_out, => p_strErrMessage_out] Query: DataReadQuery()

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException()
    2. EclipseLink (non-OSGi)
      AbstractSession.executeSelectingCall
      1. org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
      2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:797)
      3. org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.executeStoredProcedure(DatabasePlatform.java:1991)
      4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:593)
      5. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
      6. org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529)
      7. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
      8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
      9. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:263)
      10. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:245)
      11. org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:192)
      12. org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:148)
      13. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:740)
      14. org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:134)
      15. org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2392)
      16. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
      17. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
      18. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1233)
      19. org.eclipse.persistence.internal.sessions.AbstractSession.executeSelectingCall(AbstractSession.java:1397)
      19 frames
    3. oracle.iam.oimdataproviders
      OIMUserDataProvider.modify
      1. oracle.iam.oimdataproviders.impl.OIMUserDataProvider.modifyProcedureCall(OIMUserDataProvider.java:721)
      2. oracle.iam.oimdataproviders.impl.OIMUserDataProvider.modify(OIMUserDataProvider.java:578)
      2 frames
    4. oracle.iam.platform
      DefaultActionHandler.execute
      1. oracle.iam.platform.entitymgr.impl.EntityManagerImpl.modifyEntity(EntityManagerImpl.java:388)
      2. oracle.iam.platform.kernel.impl.EntityDefaultActionHandler.execute(EntityDefaultActionHandler.java:41)
      3. oracle.iam.platform.kernel.impl.DefaultActionHandler.execute(DefaultActionHandler.java:41)
      3 frames
    5. oracle.iam.identity
      ModifyUserActionHandler.execute
      1. oracle.iam.identity.usermgmt.impl.handlers.modify.ModifyUserActionHandler.execute(ModifyUserActionHandler.java:108)
      2. oracle.iam.identity.usermgmt.impl.handlers.modify.ModifyUserActionHandler.execute(ModifyUserActionHandler.java:56)
      2 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor685.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    7. oracle.iam.platform
      EventHandlerDynamicProxy.invoke
      1. oracle.iam.platform.kernel.impl.EventHandlerDynamicProxy.invoke(EventHandlerDynamicProxy.java:30)
      1 frame