java.sql.SQLException: ORA-01000: maximum open cursors exceeded ORA-06512: at "ELLIPSE.PROPFILE_READ_PR", line 17 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

Oracle Community | 807574 | 8 years ago
  1. 0

    How to close ref cursors in Java CAPS 5.1.3?

    Oracle Community | 8 years ago | 807574
    java.sql.SQLException: ORA-01000: maximum open cursors exceeded ORA-06512: at "ELLIPSE.PROPFILE_READ_PR", line 17 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  2. 0

    Java Language - java.sql.SQLException: ORA-06550

    Stack Overflow | 3 years ago | fedel1234
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'ROCWEB.USERLIST_DATAPROV' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  3. 0

    Io exception: End of TNS data channel

    Stack Overflow | 5 years ago | ıllıllı lק ıllıllı
    java.sql.SQLException: Io exception: End of TNS data channel
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    AIA Order to Cash Implementation Issue

    Oracle Community | 7 years ago | Bharathy
    java.sql.SQLException: ORA-06531: Reference to uninitialized collection ORA-06512: at "APPS.OE_INBOUND_INT", line 4947 ORA-06512: at line 1 Error Code: 6531
  6. 0

    Problem in Data Template ORA-00911: invalid character

    Oracle Community | 7 years ago | 665465
    java.sql.SQLException: ORA-06550: line 2, column 15: PLS-00302: component 'P_FROM' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored ORA-06550: line 3, column 15: PLS-00302: component 'P_TO' must be declared ORA-06550: line 3, column 1: PL/SQL: Statement ignored

    1 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-01000: maximum open cursors exceeded ORA-06512: at "ELLIPSE.PROPFILE_READ_PR", line 17 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleCallableStatement.execute
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      3. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
      4. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
      5. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:954)
      6. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
      7. oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4039)
      8. oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10804)
      9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3314)
      10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3422)
      11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394)
      11 frames
    3. com.stc.connector
      OracleCallableStatementAgent.execute
      1. com.stc.connector.oracleadapter.base.PreparedStatementAgentImpl.execute(PreparedStatementAgentImpl.java:1067)
      2. com.stc.connector.oracleadapter.OracleCallableStatementAgent.execute(OracleCallableStatementAgent.java:1052)
      2 frames
    4. com.ngrid.ellipse
      jcdWorkOrderTaskCMMToWORTS.receive
      1. com.ngrid.ellipse.prjellipse.prjworts.prjworkordertaskcmmtoworts.jcdWorkOrderTaskCMMToWORTS.getLookupData(com.ngrid.ellipse.prjellipse.prjworts.prjworkordertaskcmmtoworts.jcdWorkOrderTaskCMMToWORTS:461)
      2. com.ngrid.ellipse.prjellipse.prjworts.prjworkordertaskcmmtoworts.jcdWorkOrderTaskCMMToWORTS.mapBusinessRules(com.ngrid.ellipse.prjellipse.prjworts.prjworkordertaskcmmtoworts.jcdWorkOrderTaskCMMToWORTS:327)
      3. com.ngrid.ellipse.prjellipse.prjworts.prjworkordertaskcmmtoworts.jcdWorkOrderTaskCMMToWORTS.receive(com.ngrid.ellipse.prjellipse.prjworts.prjworkordertaskcmmtoworts.jcdWorkOrderTaskCMMToWORTS:176)
      3 frames
    5. prjWorkOrderTaskCMMToWORTS.svcWorkOrderTaskCMMToWORTS
      jcdWorkOrderTaskCMMToWORTS_Runtime_Handler.handleRequest
      1. prjWorkOrderTaskCMMToWORTS.svcWorkOrderTaskCMMToWORTS.jcdWorkOrderTaskCMMToWORTS_Runtime_Handler.handleRequest(prjWorkOrderTaskCMMToWORTS.svcWorkOrderTaskCMMToWORTS.jcdWorkOrderTaskCMMToWORTS_Runtime_Handler:381)
      1 frame
    6. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:615)
      3 frames
    7. Security Core Classes
      SecurityUtil.invoke
      1. com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:140)
      1 frame
    8. Embedded GlassFish Web
      EJBLocalObjectInvocationHandler.invoke
      1. com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:135)
      1 frame
    9. Unknown
      $Proxy37.handleRequest
      1. $Proxy37.handleRequest(Unknown Source)
      1 frame
    10. com.stc.codegen
      JMSEndPointListener.onMessage
      1. com.stc.codegen.JMSImpl.runtime.ejb.JMSEndPointListener.sendMessage(JMSEndPointListener.java:331)
      2. com.stc.codegen.JMSImpl.runtime.ejb.JMSEndPointListener.onContents(JMSEndPointListener.java:110)
      3. com.stc.codegen.JMSImpl.runtime.ejb.JMSEndPointListener.onMessage(JMSEndPointListener.java:170)
      3 frames
    11. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:615)
      3 frames
    12. Security Core Classes
      SecurityUtil$2.run
      1. com.sun.enterprise.security.SecurityUtil$2.run(SecurityUtil.java:146)
      1 frame
    13. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(AccessController.java:275)
      1 frame
    14. com.sun.enterprise
      EJBSecurityManager.doAsPrivileged
      1. com.sun.enterprise.security.application.EJBSecurityManager.doAsPrivileged(EJBSecurityManager.java:940)
      1 frame
    15. Security Core Classes
      SecurityUtil.invoke
      1. com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:151)
      1 frame
    16. Embedded GlassFish Web
      MessageBeanListenerImpl.deliverMessage
      1. com.sun.ejb.containers.MessageBeanContainer.deliverMessage(MessageBeanContainer.java:948)
      2. com.sun.ejb.containers.MessageBeanListenerImpl.deliverMessage(MessageBeanListenerImpl.java:42)
      2 frames
    17. com.sun.enterprise
      MessageEndpointInvocationHandler.invoke
      1. com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:136)
      1 frame
    18. Unknown
      $Proxy38.onMessage
      1. $Proxy38.onMessage(Unknown Source)
      1 frame
    19. com.stc.jmsjca
      SerialDelivery.onMessage
      1. com.stc.jmsjca.core.Delivery.deliverToEndpoint(Delivery.java:1180)
      2. com.stc.jmsjca.core.SerialDelivery.onMessage(SerialDelivery.java:228)
      2 frames
    20. com.stc.jms
      SessionImpl$2.run
      1. com.stc.jms.client.SessionImpl.processAsyncDataAvailable(SessionImpl.java:1661)
      2. com.stc.jms.client.SessionImpl.processAsync(SessionImpl.java:1750)
      3. com.stc.jms.client.SessionImpl.asyncEnter(SessionImpl.java:1778)
      4. com.stc.jms.client.SessionImpl.access$500(SessionImpl.java:56)
      5. com.stc.jms.client.SessionImpl$1.run(SessionImpl.java:1556)
      6. com.stc.jms.client.SessionImpl$2.run(SessionImpl.java:1809)
      6 frames
    21. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:803)
      1 frame