java.sql.SQLException: ORA-02091: transaction rolled back ORA-02291: integrity constraint (CHANGEREQ.FK_DESCRIPTION_REQUEST_ID) violated - parent key not found

Oracle Community | 3004 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Sequences and app vs. db identity

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-02091: transaction rolled back ORA-02291: integrity constraint (CHANGEREQ.FK_DESCRIPTION_REQUEST_ID) violated - parent key not found
  2. 0

    bea 8.1 oracle thin drivers and deferred constraints

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-02091: transaction rolled back ORA-02291: integrity constraint (NEWTON.FK_SAMPLE_BATCHID) violated - parent key not found OK! this is good. You get a SQLException during commit(). We should also then, and wouldn't ignore it. Would you plese make sure that the Oracle driver you are using in the standalone case is also the one the weblogic server is using. If it's not the one in the weblogic.jar file, you can make sure the zip file is ahead of the official weblogic stuff in the server's classpath. Then please turn on jdbc logging for the server, and repeat the same JDBC from within weblogic, and you should see the same exception in the jdbc log. It would be a bug if the exception showed in the log, but your application code didn't get it too. If the exception doesn't show in the log, something else is afoot. Joe > >
  3. 0

    Thalai Muthu Oracle Apps DBA: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.;

    blogspot.com | 1 year ago
    oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    error after changing domain to the essbase server

    Oracle Community | 7 years ago | user1127616
    java.sql.SQLException: ORA-12638: Recupero credenziali non riuscito
  6. 0

    SQl - ORA-00933 error

    Stack Overflow | 3 years ago | praba
    java.sql.SQLException: ORA-00933: SQL command not properly ended

  1. rp 1 times, last 2 months ago
26 unregistered visitors
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-02091: transaction rolled back ORA-02291: integrity constraint (CHANGEREQ.FK_DESCRIPTION_REQUEST_ID) violated - parent key not found

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.commit
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.java:138)
    3. oracle.jdbc.ttc7.TTC7Protocol.commit(TTC7Protocol.java:441)
    3 frames
  4. Oracle jdbc
    OracleConnection.commit
    1. oracle.jdbc.driver.OracleConnection.commit(OracleConnection.java:1377)
    1 frame
  5. com.solarmetric.jdbc
    DelegatingConnection.commit
    1. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
    2. com.solarmetric.jdbc.PoolConnection.commit(PoolConnection.java:182)
    3. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
    4. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
    5. com.solarmetric.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.commit(ConfiguringConnectionDecorator.java:127)
    6. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
    7. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
    8. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:162)
    9. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
    9 frames
  6. kodo.jdbc.runtime
    JDBCStoreManager.commit
    1. kodo.jdbc.runtime.JDBCStoreManager.commit(JDBCStoreManager.java:120)
    1 frame
  7. kodo.runtime
    PersistenceManagerImpl.commit
    1. kodo.runtime.PersistenceManagerImpl.endTransaction(PersistenceManagerImpl.java:799)
    2. kodo.runtime.PersistenceManagerImpl.afterCompletion(PersistenceManagerImpl.java:668)
    3. kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:86)
    4. kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:411)
    4 frames
  8. Unknown
    testEntry.doPost
    1. testEntry.processRequest(testEntry.java:433)
    2. testEntry.doPost(testEntry.java:463)
    2 frames
  9. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    2 frames
  10. jrun.servlet
    ServletEngineService.dispatch
    1. jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
    2. jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
    3. jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
    4. jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
    4 frames
  11. jrun.servlet.jrpp
    JRunProxyService.invokeRunnable
    1. jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:207)
    1 frame
  12. jrunx.scheduler
    WorkerThread.run
    1. jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
    2. jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
    3. jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
    4. jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
    4 frames