Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
Hi Team,
We are getting below exception.
Pega Version: V7.3
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:542) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:386) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:181) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:75) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2976) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2956) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2025) ~[prprivate.jar:?]
... 10 more
Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc6.jar: Proprietary information hidden.0]
Hi Team,
We are getting below exception.
Pega Version: V7.3
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:542) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:386) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:181) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:75) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2976) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2956) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2025) ~[prprivate.jar:?]
... 10 more
Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar: Proprietary information hidden.0]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:507) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:364) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:181) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:75) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2976) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2956) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2025) ~[prprivate.jar:?]
... 10 more
2017-12-07 00:41:59,646 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ PegaRULES:07.10] ( internal.async.AgentQueue) ERROR - Problem queue Pega-ProCom #0: System-Queue-ServiceLevel.ProcessEvent will restart in 180000 ms
2017-12-07 00:42:59,500 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ PegaRULES:07.10] (re.rdbms.JdbcConnectionManager) ERROR - Not returning connection 4 for database "pegadata" to the pool as it previously encountered the following error
User ID: System
Last SQL: {call U90CCMDT.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar: Proprietary information hidden.0]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:507) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:364) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:181) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:75) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2976) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2956) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2025) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:1935) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:503) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1055) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1304) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1052) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:934) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:761) ~[prprivate.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991) ~[prjsr166java6-3.0.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532) ~[prjsr166java6-3.0.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_144]
2017-12-07 00:42:59,501 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ PegaRULES:07.10] ( async.agent.QueueManagerImpl) ERROR - Problem with browse of System-Queue-DefaultEntry
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 1000 SQLState: 72000 Message: ORA-01000: maximum open cursors exceeded
DatabaseException caused by prior exception: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
| SQL Code: 1000 | SQL State: 72000
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:542) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:386) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:181) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:75) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2976) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2956) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2025) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:1935) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:503) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1055) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1304) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1052) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:934) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:761) ~[prprivate.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991) ~[prjsr166java6-3.0.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532) ~[prjsr166java6-3.0.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_144]
Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar: Proprietary information hidden.0]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:507) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:364) ~[prprivate.jar:?]
... 16 more
2017-12-07 00:42:59,502 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ PegaRULES:07.10] (ernal.async.BatchRequestorTask) ERROR - Batch activity "PegaAccel-Management-Rebase.pzProcessRebase" threw:
com.pega.pegarules.pub.context.PRQueueException: There was a problem getting a list: code: 1000 SQLState: 72000 Message: ORA-01000: maximum open cursors exceeded
DatabaseException caused by prior exception: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
| SQL Code: 1000 | SQL State: 72000
: code: <none> SQLState: <none> Message: <none>
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2207) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:1935) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:503) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1055) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1304) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1052) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:934) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:761) ~[prprivate.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991) ~[prjsr166java6-3.0.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532) ~[prjsr166java6-3.0.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_144]
Caused by: com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 1000 SQLState: 72000 Message: ORA-01000: maximum open cursors exceeded
DatabaseException caused by prior exception: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
| SQL Code: 1000 | SQL State: 72000
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:542) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:386) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:181) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:75) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2976) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2956) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2025) ~[prprivate.jar:?]
... 10 more
Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar: Proprietary information hidden.0]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:507) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:364) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:181) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:75) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2976) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2956) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2025) ~[prprivate.jar:?]
... 10 more
2017-12-07 00:42:59,502 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ PegaRULES:07.10] ( internal.async.AgentQueue) ERROR - Agent Pega-RuleRefactoring #1: PegaAccel-Management-Rebase.pzProcessRebase encountered an execution error. Restarting after delay.
com.pega.pegarules.pub.context.PRQueueException: There was a problem getting a list: code: 1000 SQLState: 72000 Message: ORA-01000: maximum open cursors exceeded
DatabaseException caused by prior exception: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
| SQL Code: 1000 | SQL State: 72000
: code: <none> SQLState: <none> Message: <none>
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2207) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:1935) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:503) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1055) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1304) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1052) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:934) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:761) ~[prprivate.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991) ~[prjsr166java6-3.0.jar:?]
at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532) ~[prjsr166java6-3.0.jar:?]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_144]
Caused by: com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 1000 SQLState: 72000 Message: ORA-01000: maximum open cursors exceeded
DatabaseException caused by prior exception: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
| SQL Code: 1000 | SQL State: 72000
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:542) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:386) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:181) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:75) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2976) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2956) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2025) ~[prprivate.jar:?]
... 10 more
Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar: Proprietary information hidden.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar: Proprietary information hidden.0]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197) ~[tomcat-dbcp.jar:8.5.23]
at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:507) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:364) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:181) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:124) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:75) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2976) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:2956) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2025) ~[prprivate.jar:?]
... 10 more
2017-12-07 00:42:59,520 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ PegaRULES:07.10] ( internal.async.AgentQueue) ERROR - Problem queue Pega-RuleRefactoring #1: PegaAccel-Management-Rebase.pzProcessRebase will restart in 180000 ms
Thanks in Advance