4 Replies Latest reply on Oct 31, 2008 2:03 AM by Ramesh Nittur Anantharamaiah-Oracle

    ORA-01000: maximum open cursors exceeded

    659604
      Hi,

      Sometimes the file processing fails with lot of errors as following, one of which says maximum open cursors exceeded, which I believe is causing other errors. We have only 6 edi partners with very lite volume. Max cursors is set to 1000 in database. Anyone has any ideas what could be causing this? Appreciate any pointers.

      Error -: AIP-50014: General Error: Error -: AIP-50025: Repository error : Error -: AIP-11052: Writing following objects: Wire Message failed due to following constraint violation: null: Error -: AIP-11052: Writing following objects: Wire Message failed due to following constraint violation: null: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
      ORA-06512: at "B2B.RUN_WIREMESSAGE_RV", line 7
      ORA-04088: error during execution of trigger 'B2B.RUN_WIREMESSAGE_RV'
           at oracle.tip.adapter.b2b.engine.Engine.processOutgoingMessage(Engine.java:1129)
           at oracle.tip.adapter.b2b.engine.Engine.handleMessageEvent(Engine.java:2322)
           at oracle.tip.adapter.b2b.engine.Engine.processEvents(Engine.java:2258)
           at oracle.tip.adapter.b2b.data.MsgListener.onMessage(MsgListener.java:500)
           at oracle.tip.adapter.b2b.data.MsgListener.run(MsgListener.java:348)
           at java.lang.Thread.run(Thread.java:534)

      Thanks
      Venkat