DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-08177

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    has anyone faced this error (08177) before? I think it's an application coding problem but not sure
    I have never faced this problem so dunno what can this be?

    Can anyone have a look at these errors?




    TxCoordinator LOG: Transaction rolled back due to beforeCompletion exception
    java.sql.SQLException: ORA-08177: can't serialize access for this transaction

    at java.lang.Throwable.fillInStackTrace(Native Method)
    at java.lang.Throwable.fillInStackTrace(Compiled Code)
    at java.lang.Throwable.(Compiled Code)
    at java.lang.Exception.(Compiled Code)
    at java.sql.SQLException.(SQLException.java:43)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
    at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)
    at oracle.jdbc.ttc7.Oall7.receive(Compiled Code)
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(Compiled Code)
    at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.executeNonQuery(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.doExecuteOther(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.doExecute(Compiled Code)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Compiled Code)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Compiled Code)
    at weblogic.jdbcbase.jts.Statement.executeUpdate(Compiled Code)
    at accenture.ejb.entity.language.LanguagePSJDBC.update(Compiled Code)
    at accenture.ejb.entity.language.LanguagePSJDBC.store(Compiled Code)
    at weblogic.ejb.internal.EntityEJBContext.store(Compiled Code)
    at weblogic.ejb.internal.EntityEJBContext.beforeCompletion(Compiled Code)
    at weblogic.jts.internal.CoordinatorImpl.notifyBefore(Compiled Code)
    at weblogic.jts.internal.CoordinatorImpl.prepare(Compiled Code)
    at weblogic.jts.internal.CoordinatorImpl.commit(Compiled Code)
    at weblogic.jts.internal.TxContext.commit(Compiled Code)
    at weblogic.ejb.internal.StatefulEJBObject.postInvokeOurTx(Compiled Code)
    at weblogic.ejb.internal.BaseEJBObject.postInvoke(Compiled Code)
    at accenture.ejb.entity.language.LanguageBeanEOImpl.getToken(Compiled Code)
    at jspwdir._jsp._acc._menuizdo_95_I._jspService(Compiled Code)
    at weblogic.servlet.jsp.JspBase.service(Compiled Code)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Compiled Code)
    at weblogic.servlet.internal.ServletContextImpl.invokeServlet(Compiled Code)
    at weblogic.servlet.JSPServlet.service(Compiled Code)
    at javax.servlet.http.HttpServlet.service(Compiled Code)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Compiled Code)
    at weblogic.servlet.internal.ServletContextImpl.invokeServlet(Compiled Code)
    at weblogic.servlet.internal.ServletContextImpl.invokeServlet(Compiled Code)
    at weblogic.socket.MuxableSocketHTTP.invokeServlet(Compiled Code)
    at weblogic.socket.MuxableSocketHTTP.execute(Compiled Code)
    at weblogic.t3.srvr.ExecuteThread.run(Compiled Code)

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    08177, 00000, "can't serialize access for this transaction"
    // *Cause: Encountered data changed by an operation that occurred after
    // the start of this serializable transaction.
    // *Action: In read/write transactions, retry the intended operation or
    // transaction.




    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    th error I posted is just a little part of the log, the whole log is full of this error so I guess the transaction has been retried for several times!

    BTW the version is 8.1.6

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes that is possible.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yea so retrying doesnt solve the problem it seems....

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925

    at java.sql.SQLException.(SQLException.java:43)
    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
    at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)

    Since I don't deal v.much with the web, I don't have much idea for the cause of the problem. But, did you get to find the cause od the abouve three errors. It might help you to better target the issue. In the mean time did you get to post the problem in the dev. forum. Since those folks get to work on the dev, they may be able to guide you better in trouble shooting this issue.

    I'm very for not being able to help.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width