11 Replies Latest reply on Jul 16, 2012 12:15 PM by 1D10T

    ORA-01086: savepoint 'BO_SP' never established

    629225
      Hi,

      I have an editable af:table based and trying to commit changes [add/edit/delete] and sometimes I get this error message ORA-01086: savepoint 'BO_SP' never established. Attempting to Commit again works, but why it complains about savepoint 'BO_SP' which does not even exist anywhere in my Model Project.

      Any idea ?

      Thank you,
        • 1. Re: ORA-01086: savepoint 'BO_SP' never established
          Timo Hahn
          These save points are generated by the framework at specific times (i.e. entering a task flow with a special option active, or passivation of an application module). They are normally saved into a special db table (ps_txn) in the schema you are working with.
          If you see such an error it's possible because this table does not exist.

          You should try find out what exactly happens. Please provide more information (stack trace, jdev version, ui technology ...).

          Timo
          1 person found this helpful
          • 2. Re: ORA-01086: savepoint 'BO_SP' never established
            629225
            Hi Timo,

            Thanks for your response,

            JDeveloper Studio Edition Version 11.1.1.0.2
            Build JDEVADF_MAIN.BOXER_GENERIC_090328.0229.5205

            It does not produce any stack trace, just the error message in <af:message/>

            Also, I am seeing some strange behaviour around Commit , first time committing does not work, but as soon as I commit second time it works, it seems like something went wrong during first commit. Anyways, that's beside the point, but it's strange.

            Thanks,
            • 3. Re: ORA-01086: savepoint 'BO_SP' never established
              Timo Hahn
              Run the app in the debuger and put -Djbo.debugoutput=console as java option in the run profile. Then you should see some messages in the console window inside jdev.

              Timo
              1 person found this helpful
              • 4. Re: ORA-01086: savepoint 'BO_SP' never established
                680096
                Hi ,

                I too have the same issue. But this does not come in local.

                The version is R12 and Jdev version id 10g.

                Below is the complete stack:


                Error Page
                Exception Details.
                oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Rollback to Savepoint": SQL Statement "null".
                     at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:980)
                     at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
                     at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
                     at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
                     at cisco.oracle.apps.xxg2c.goaling.webui.Xxg2cGoalSheeUpdateViewCO.processFormRequest(Xxg2cGoalSheeUpdateViewCO.java:281)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:815)
                     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
                     at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1189)
                     at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
                     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
                     at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
                     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
                     at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
                     at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2841)
                     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1835)
                     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:533)
                     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:421)
                     at OA.jspService(_OA.java:204)
                     at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
                     at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
                     at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
                     at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
                     at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
                     at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
                     at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
                     at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
                     at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
                     at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
                     at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
                     at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
                     at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
                     at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
                     at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
                     at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                     at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                     at java.lang.Thread.run(Thread.java:595)
                ## Detail 0 ##
                java.sql.SQLException: ORA-01086: savepoint 'BO_SP' never established

                     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
                     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
                     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
                     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
                     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
                     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445)
                     at oracle.jbo.server.OracleSQLBuilderImpl.rollbackToSavepoint(OracleSQLBuilderImpl.java:1447)
                     at oracle.jbo.server.DBTransactionImpl.rollbackToSavepoint(DBTransactionImpl.java:2847)
                     at oracle.jbo.server.DBTransactionImpl.restoreTmpPostState(DBTransactionImpl.java:1833)
                     at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2823)
                     at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1971)
                     at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2173)
                     at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:690)
                     at cisco.oracle.apps.xxg2c.goaling.server.Xxg2cGoalSheetUpdateViewAMImpl.commitTrans(Xxg2cGoalSheetUpdateViewAMImpl.java:891)
                     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:585)
                     at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
                     at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
                     at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
                     at cisco.oracle.apps.xxg2c.goaling.webui.Xxg2cGoalSheeUpdateViewCO.processFormRequest(Xxg2cGoalSheeUpdateViewCO.java:281)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:815)
                     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
                     at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1189)
                     at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
                     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
                     at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
                     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
                     at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
                     at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2841)
                     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1835)
                     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:533)
                     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:421)
                     at OA.jspService(_OA.java:204)
                     at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
                     at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
                     at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
                     at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
                     at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
                     at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
                     at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
                     at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
                     at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
                     at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
                     at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
                     at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
                     at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
                     at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
                     at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
                     at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                     at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                     at java.lang.Thread.run(Thread.java:595)
                java.sql.SQLException: ORA-01086: savepoint 'BO_SP' never established

                     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
                     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
                     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
                     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
                     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
                     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445)
                     at oracle.jbo.server.OracleSQLBuilderImpl.rollbackToSavepoint(OracleSQLBuilderImpl.java:1447)
                     at oracle.jbo.server.DBTransactionImpl.rollbackToSavepoint(DBTransactionImpl.java:2847)
                     at oracle.jbo.server.DBTransactionImpl.restoreTmpPostState(DBTransactionImpl.java:1833)
                     at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2823)
                     at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1971)
                     at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2173)
                     at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:690)
                     at cisco.oracle.apps.xxg2c.goaling.server.Xxg2cGoalSheetUpdateViewAMImpl.commitTrans(Xxg2cGoalSheetUpdateViewAMImpl.java:891)
                     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:585)
                     at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
                     at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
                     at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
                     at cisco.oracle.apps.xxg2c.goaling.webui.Xxg2cGoalSheeUpdateViewCO.processFormRequest(Xxg2cGoalSheeUpdateViewCO.java:281)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:815)
                     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
                     at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1189)
                     at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
                     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
                     at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
                     at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
                     at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
                     at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
                     at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2841)
                     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1835)
                     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:533)
                     at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:421)
                     at OA.jspService(_OA.java:204)
                     at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
                     at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
                     at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
                     at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
                     at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
                     at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
                     at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
                     at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
                     at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
                     at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
                     at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
                     at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
                     at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
                     at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
                     at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
                     at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                     at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                     at java.lang.Thread.run(Thread.java:595)

                Please revert back with any pointer on this.

                Thanks
                • 5. Re: ORA-01086: savepoint 'BO_SP' never established
                  Timo Hahn
                  This look like a OA Framework problem. Please ask this on the OA forum

                  Timo
                  • 6. Re: ORA-01086: savepoint 'BO_SP' never established
                    1D10T
                    hello i got the similar problem , what could be a problem ?

                    message: JBO-26041: Failed to post data to database during "Rollback to Savepoint": SQL Statement "null".
                    occurance: 2012.06.01 12:14:14,000000000
                    track_trace: "oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Rollback to Savepoint": SQL Statement "null".
                    at oracle.jbo.server.DBTransactionImpl.rollbackToSavepoint(DBTransactionImpl.java:3033)
                    at oracle.jbo.server.DBTransactionImpl.restoreTmpPostState(DBTransactionImpl.java:1801)
                    at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2277)
                    at ******.common.datatags.RowTag.doEndTag(RowTag.java:486)
                    at jsp_servlet._common._comp.__cmn_datahandlercomponent._jspService(__cmn_datahandlercomponent.java:258)
                    at weblogic.servlet.jsp.JspBase.service(JspBase.java:35)
                    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
                    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
                    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                    at ******.common.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:63)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                    at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:94)
                    at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:138)
                    at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
                    at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:447)
                    at oracle.jbo.html.jsp.datatags.ComponentTag.doStartTag(ComponentTag.java:61)
                    at jsp_servlet._common._comp.__save._jspService(__save.java:178)
                    at weblogic.servlet.jsp.JspBase.service(JspBase.java:35)
                    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
                    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
                    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                    at ******.common.filter.CacheControlFilter.doFilter(CacheControlFilter.java:44)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                    at ******.common.filter.XssFilter.doFilter(XssFilter.java:38)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                    at ******.common.filter.DTFilterElementFilter.doFilter(DTFilterElementFilter.java:41)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                    at ******.common.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:63)
                    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
                    at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:94)
                    at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:138)
                    at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
                    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
                    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
                    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
                    at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
                    Caused by: java.sql.SQLException: ORA-01086: savepoint ''''*BO_SP*'''' never established in this session or is invalid

                    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
                    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
                    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
                    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
                    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
                    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
                    at oracle" "

                    Edited by: 945445 on 2012.10.7 03:42
                    • 7. Re: ORA-01086: savepoint 'BO_SP' never established
                      John Stegeman
                      WHy would you wake up a 2-year-old thread - different versions of software at the very very least - instead of posting a new thread with the details of your problem. As it is, a stack trace is fairly useless - we don't know what version of JDeveloper, what your use case is, what this special lv.panda.xxxxxx tag is, etc
                      • 8. Re: ORA-01086: savepoint 'BO_SP' never established
                        1D10T
                        The problem is , in that in our test server All are working correct but in client server with this error message !


                        Sry for incorect place to thread
                        • 9. Re: ORA-01086: savepoint 'BO_SP' never established
                          John Stegeman
                          The problem is , in that in our test server All are working correct but in client server with this error message !
                          You see, that would have been useful information to post when you opened a thread, and would lead to such responses as "are the WLS servers the same version" and "did you install the correct version of the Application Development Runtime on the client's servers?"
                          • 10. Re: ORA-01086: savepoint 'BO_SP' never established
                            1D10T
                            WLS & ADR are the same versions in both servers !

                            Thanks for fast reply .
                            • 11. Re: ORA-01086: savepoint 'BO_SP' never established
                              1D10T
                              Anyone can help ?