Direct links to fixes
APAR status
Closed as program error.
Error description
When IBM Process Federation Server V8.5.7 CF2017.06 or V8.6 performs the compaction maintenance operation with a DB2 database, you might see the following exception: [9/11/17 9:40:43:868 EDT] 000000a2 id= com.ibm.tx.jta.embeddable.impl.EmbeddableTimeoutManager I WTRN0006W: Transaction 0000015E7129E21C000000017E30439885CDEDE2408F9342F32ED26390EA7BE6 201577FD0000015E7129E21C000000017E30439885CDEDE2408F9342F32ED263 90EA7BE6201577FD00000001 has timed out after 120 seconds. [9/11/17 9:40:43:869 EDT] 000000a2 id= com.ibm.tx.jta.embeddable.impl.EmbeddableTimeoutManager I WTRN0124I: When the timeout occurred the thread with which the transaction is, or was most recently, associated was Thread[Default Executor-thread-39,5,Default Executor Thread Group]. The stack trace of this thread when the timeout occurred was: java.net.SocketInputStream.socketRead0(Native Method) java.net.SocketInputStream.socketRead(SocketInputStream.java:127 ) java.net.SocketInputStream.read(SocketInputStream.java:182) java.net.SocketInputStream.read(SocketInputStream.java:152) com.ibm.db2.jcc.t4.y.b(y.java:224) com.ibm.db2.jcc.t4.y.c(y.java:336) com.ibm.db2.jcc.t4.y.c(y.java:449) com.ibm.db2.jcc.t4.y.v(y.java:1217) com.ibm.db2.jcc.t4.bb.e(bb.java:76) com.ibm.db2.jcc.t4.p.d(p.java:63) com.ibm.db2.jcc.t4.vb.m(vb.java:185) com.ibm.db2.jcc.am.sp.lb(sp.java:2207) com.ibm.db2.jcc.am.tp.a(tp.java:4582) com.ibm.db2.jcc.am.tp.b(tp.java:4173) com.ibm.db2.jcc.am.tp.mc(tp.java:817) com.ibm.db2.jcc.am.tp.executeUpdate(tp.java:791) com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate( WSJdbcPreparedStatement.java:524) com.ibm.bpm.federated.indexer.bpd.changelog.persistence.spi.impl .AbstractIndexChangePM.compactChangeLog(AbstractIndexChangePM.ja va:1311) PRODUCTS AFFECTED Process Federation Server
Local fix
Problem summary
No additional information is available.
Problem conclusion
A fix that modifies the compaction SQL query for DB2 to prevent the transaction timeout will be included in a future release of Process Federation Server.
Temporary fix
Not applicable.
Comments
APAR Information
APAR number
JR58529
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
857
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-10-04
Closed date
2017-10-24
Last modified date
2017-10-24
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
R857 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
24 October 2017