Support Article

Timeout at shutdown on pr4_log_rule_usage_details

SA-32033

Summary



Database exception caused by prior exception, with Pega 7.2.


Error Messages



User ID: System
13 Last SQL: delete from PEGADATA.pr4_log_rule_usage_details where pxObjClass = 'Log-RuleUsage-Details' and pxSystemNode = ? and pyLabel = ?
14 com.ibm.db2.jcc.am.SqlException: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE 00000304, AND RESOURCE NAME PEGADBA .PGTS0104.X'00002B' '.X'01'. SQLCODE=-913, SQLSTATE=57033, DRIVER=4.15.113
15 at com.ibm.db2.jcc.am.fd.a(fd.java:701)
16 at com.ibm.db2.jcc.am.fd.a(fd.java:60)
17 at com.ibm.db2.jcc.am.fd.a(fd.java:127)
18 at com.ibm.db2.jcc.am.qo.b(qo.java:2421)
19 at com.ibm.db2.jcc.am.qo.c(qo.java:2404)
20 at com.ibm.db2.jcc.t4.bb.l(bb.java:374)
21 at com.ibm.db2.jcc.t4.bb.a(bb.java:61)
22 at com.ibm.db2.jcc.t4.q.a(q.java:50)
23 at com.ibm.db2.jcc.t4.sb.b(sb.java:220)
24 at com.ibm.db2.jcc.am.ro.rc(ro.java:3527)
25 at com.ibm.db2.jcc.am.ro.b(ro.java:4490)
26 at com.ibm.db2.jcc.am.ro.lc(ro.java:2834)
27 at com.ibm.db2.jcc.t4.k.lc(k.java:233)
28 at com.ibm.db2.jcc.am.ro.execute(ro.java:2809)
29 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:958)
30 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:625)
31 at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:582)
...
Caused by:
121 com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: -913 SQLState: 57033 Message: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE 00000304, AND RESOURCE NAME PEGADBA .PGTS0104.X'00002B' '.X'01'. SQLCODE=-913, SQLSTATE=57033, DRIVER=4.15.113
122 DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlException: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE 00000304, AND RESOURCE NAME PEGADBA .PGTS0104.X'00002B' '.X'01'. SQLCODE=-913, SQLSTATE=57033, DRIVER=4.15.113
123 | SQL Code: -913 | SQL State: 57033
124 From: (B97E156DC51A5AABC5F85019EE29E85CC)
125 SQL: delete from PEGADATA.pr4_log_rule_usage_details where pxObjClass = 'Log-RuleUsage-Details' and pxSystemNode = ? and pyLabel = ?
126 Caused by SQL Problems.
127 Problem #1, SQLState 57033, Error code -913: com.ibm.db2.jcc.am.SqlException: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE 00000304, AND RESOURCE NAME PEGADBA .PGTS0104.X'00002B' '.X'01'. SQLCODE=-913, SQLSTATE=57033, DRIVER=4.15.113
128 at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
129 at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6519)
130 at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6932)
131 at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6885)
132 at com.pega.pegarules.data.internal.access.DatabaseImpl.executeRDB(DatabaseImpl.java:6865)
133 at com.pega.pegarules.monitor.internal.context.RuleUsageImpl.deleteUsageDetails(RuleUsageImpl.java:454)
134 ... 40 more
135 Caused by:
136 com.ibm.db2.jcc.am.SqlException: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE 00000304, AND RESOURCE NAME PEGADBA .PGTS0104.X'00002B' '.X'01'. SQLCODE=-913, SQLSTATE=57033, DRIVER=4.15.113
137 at com.ibm.db2.jcc.am.fd.a(fd.java:701)
138 at com.ibm.db2.jcc.am.fd.a(fd.java:60)
139 at com.ibm.db2.jcc.am.fd.a(fd.java:127)
140 at com.ibm.db2.jcc.am.qo.b(qo.java:2421)
141 at com.ibm.db2.jcc.am.qo.c(qo.java:2404)
142 at com.ibm.db2.jcc.t4.bb.l(bb.java:374)
143 at com.ibm.db2.jcc.t4.bb.a(bb.java:61)
144 at com.ibm.db2.jcc.t4.q.a(q.java:50)
145 at com.ibm.db2.jcc.t4.sb.b(sb.java:220)
146 at com.ibm.db2.jcc.am.ro.rc(ro.java:3527)
147 at com.ibm.db2.jcc.am.ro.b(ro.java:4490)
148 at com.ibm.db2.jcc.am.ro.lc(ro.java:2834)
149 at com.ibm.db2.jcc.t4.k.lc(k.java:233)
150 at com.ibm.db2.jcc.am.ro.execute(ro.java:2809)
151 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:958)
152 at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:625)
153 at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:582)
154 at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6447)
155 ... 44 more


Steps to Reproduce



Shutdown the nodes.


Root Cause



A defect or configuration issue in the operating environment:

The pr4_log_rule_usage_details table needed a re-org to allow processing to not time out.


Resolution



Perform the following local-change:

Re-org: pr4_log_rule_usage_details. Seek your DBA's assistance if required.

Published December 30, 2016 - Updated January 12, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.