Question

2
Replies
378
Views
prudhvirajua4242 Member since 2019 2 posts
Morgan Stanley & Company International PLC
Posted: 1 year ago
Last activity: 1 year 5 months ago
Closed
Solved

Custom queue class and table issue with sppr_sys_reservequeueitem_b stored proc

Hi ,

we have created a Custom queue class extending System-Queue-DefaultEntry and a dedicated table to save the Queue records.

we have configured a standard agent to process these queue items.we are able to queue the items.

when we try to start the agent it is throwing below error.[for SQLCODE=-302, SQLSTATE=22001 we already verified column lengths all the properties in dedicated table having max values.] .

Agent xxxxx #31: System-Queue-DefaultEntry-xxxxxx.xxxxxx encountered an execution error. Restarting after delay. Exception at 20190327T121842.009 GMT: com.pega.pegarules.pub.context.PRQueueException: There was a problem getting a list: code: -302 SQLState: 22001 Message: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.62.56: 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:453) at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:945) at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1259) at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008) at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:901) at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:670) at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991) at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532) at java.lang.Thread.run(Thread.java:748) Caused by: com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: -302 SQLState: 22001 Message: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.62.56 From: (B6378E9ABAF9748286C18B66F10E12F91) SQL: {call xxxxx_DATA.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) } SQL Inserts: <xxxx_DATA.xxxxxx> <System-Queue-DefaultEntry-xxxx> <xxxxx:xxxxx> <Scheduled> <xxxxxxxx> <> <20190327T121841.997 GMT> <true> <> <(OUTPUT PARAMETER)> Caused by SQL Problems. Problem #1, SQLState 22001, Error code -302: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.62.56 at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262) at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6232) at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6625) at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6581) at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6562) at com.pega.pegarules.session.internal.async.agent.QueueManagerImpl$QueueIteratorImpl.next(QueueManagerImpl.java:1998) ... 10 more Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.62.56 at com.ibm.db2.jcc.am.fd.a(fd.java:668) at com.ibm.db2.jcc.am.fd.a(fd.java:60) at com.ibm.db2.jcc.am.fd.a(fd.java:127) at com.ibm.db2.jcc.am.jn.b(jn.java:2299) at com.ibm.db2.jcc.am.jn.c(jn.java:2282) at com.ibm.db2.jcc.t4.cb.k(cb.java:370) at com.ibm.db2.jcc.t4.cb.e(cb.java:98) at com.ibm.db2.jcc.t4.q.e(q.java:81) at com.ibm.db2.jcc.t4.rb.k(rb.java:160) at com.ibm.db2.jcc.am.jn.jb(jn.java:2248) at com.ibm.db2.jcc.am.kn.b(kn.java:4078) at com.ibm.db2.jcc.am.kn.b(kn.java:4188) at com.ibm.db2.jcc.am.ln.fc(ln.java:113) at com.ibm.db2.jcc.am.ln.execute(ln.java:96) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:173) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:173) at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:581) at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6151) ... 14 more

***Edited by Moderator: Pallavi to update platform capability tags***

Low-Code App Development Data Integration
Moderation Team has archived post
Share this page LinkedIn