Question

2
Replies
101
Views
TheerayutT Member since 2015 1 post
Kasikornbank
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed

Error on ServiceLevelEvents

Hey Guys,

We have same issue --> https://community1.pega.com/community/product-support/question/service-…

any one can help me to solve this problem.

Agent Pega-ProCom #0: System-Queue-ServiceLevel.ProcessEvent encountered an execution error. Restarting after delay. Exception at 20180928T034526.910 GMT: com.pega.pegarules.pub.context.PRQueueException: There was a problem getting a list: code: -911 SQLState: 40001 Message: DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=2, DRIVER=3.64.106: code: <none> SQLState: <none> Message: <none> at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:2176) at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:1920) at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:451) at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:885) at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1177) at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:926) at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:825) at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:618) at com.pega.pegarules.session.internal.async.Agent.queueBatchActivityForAgent(Agent.java:1505) at com.pega.pegarules.session.internal.async.Agent.queueBatchActivityForAgent(Agent.java:1294) at com.pega.pegarules.session.internal.async.AgentQueue.run(AgentQueue.java:769) at com.pega.pegarules.session.internal.async.Agent.runAgentTask(Agent.java:937) at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.processAsyncTask(AsyncServant.java:220) at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.invoke(AsyncServant.java:166) at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:315) at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:263) at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:225) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:613) at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338) at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379) at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216) at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:238) at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168) at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source) at com.pega.pegarules.session.internal.engineinterface.etier.mdb.PRAsync.processRequest(PRAsync.java:155) at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.AsyncTask.run(AsyncTask.java:64) at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.RunnableWrapper.run(RunnableWrapper.java:71) at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:270) at java.security.AccessController.doPrivileged(AccessController.java:229) at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:796) at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222) at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864) Caused by: com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: -911 SQLState: 40001 Message: DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=2, DRIVER=3.64.106 From: (B1A973829750F06047C7E30F4C4848A1E) SQL: {call WORK.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) } SQL Inserts: <WORK.pr_sys_queue_sla> <System-Queue-ServiceLevel> <Pega-ProCom:ServiceLevelEvents> <Scheduled> <21bfbc76c44165298bc75ddffdc39d88> <> <20180928T034517.713 GMT> <true> <> <(OUTPUT PARAMETER)> Caused by SQL Problems. Problem #1, SQLState 40001, Error code -911: com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=2, DRIVER=3.64.106 at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:257) at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6080) at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6473) at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6429) at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6410) at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:1998) ... 35 more Caused by: com.ibm.db2.jcc.am.SqlTransactionRollbackException: DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=2, DRIVER=3.64.106 at com.ibm.db2.jcc.am.bd.a(bd.java:666) at com.ibm.db2.jcc.am.bd.a(bd.java:60) at com.ibm.db2.jcc.am.bd.a(bd.java:127) at com.ibm.db2.jcc.am.io.c(io.java:2706) at com.ibm.db2.jcc.t4.ab.t(ab.java:982) at com.ibm.db2.jcc.t4.ab.l(ab.java:405) at com.ibm.db2.jcc.t4.ab.f(ab.java:98) at com.ibm.db2.jcc.t4.p.e(p.java:81) at com.ibm.db2.jcc.t4.qb.k(qb.java:160) at com.ibm.db2.jcc.am.io.jb(io.java:2322) at com.ibm.db2.jcc.am.jo.b(jo.java:4401) at com.ibm.db2.jcc.am.CallableStatement.hc(CallableStatement.java:115) at com.ibm.db2.jcc.am.CallableStatement.execute(CallableStatement.java:97) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:958) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:625) at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:576) at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6003) ... 39 more

Case Management
Moderation Team has archived post
Share this page LinkedIn