Question

1
Replies
1190
Views
srivishnu Member since 2016 28 posts
CAPGEMINI
Posted: 2 years ago
Last activity: 2 years 9 months ago
Closed

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:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar:12.1.0.2.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:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar:12.1.0.2.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:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar:12.1.0.2.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:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar:12.1.0.2.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:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) ~[ojdbc6.jar:12.1.0.2.0]

at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) ~[ojdbc6.jar:12.1.0.2.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

Moderation Team has archived post
Share this page LinkedIn