Direct links to fixes
APAR status
Closed as program error.
Error description
While processing a transaction, the following exception is logged: [8/23/16 12:37:19:088 CEST] 000000b8 wle E CWLLG0594E: An exception occurred while initializing the runnable thread. Error: com.lombardisoftware.core.TeamWorksException: [jcc][t4][10120][10898][4.15.134] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null at com.lombardisoftware.core.TeamWorksException. asTeamWorksException(TeamWorksException.java:136) at com.lombardisoftware.component.common.workflow. ExecutionContextHelper.getStoredSymbolTable (ExecutionContextHelper.java:278) at com.lombardisoftware.component.common.workflow. ExecutionContext.getStoredTable (ExecutionContext.java:849) at com.lombardisoftware.server.ejb.workflow. EJBWorkflowManagerBean.generateStayOnUiResult (EJBWorkflowManagerBean.java:1749) ... Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120][10898][4.15.134] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null at com.ibm.db2.jcc.am.fd.a(fd.java:680) at com.ibm.db2.jcc.am.fd.a(fd.java:60) at com.ibm.db2.jcc.am.fd.a(fd.java:103) at com.ibm.db2.jcc.am.ResultSet.checkForClosedResultSet (ResultSet.java:4600) at com.ibm.db2.jcc.am.ResultSet.findColumnX(ResultSet.java:1932) at com.ibm.db2.jcc.am.ResultSet.getBytes(ResultSet.java:1711) at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getBytes (WSJdbcResultSet.java:913) at com.lombardisoftware.component.common.workflow. ExecutionContextHelper.getStoredSymbolTable (ExecutionContextHelper.java:267) ... 67 more
Local fix
Problem summary
An entry is expected in the database table LSW_STORED_SYMBOL_TABLE, which might temporarily not be present and might cause the result set to be already closed when the transaction tries to access it.
Problem conclusion
A fix that ensures a missing entry in the database table LSW_STORED_SYMBOL_TABLE is accepted under certain circumstances and is interpreted as an empty symbol table for the corresponding task is available for IBM BPM V8.0.1.3 and will be available in IBM BPM V8.5.7 cumulative fix 2016.12. For IBM BPM V8.0.1.3, search for JR56556 on Fix Central (http://www.ibm.com/support/fixcentral): 1. Select IBM Business Process Manager with your edition from the product selector, the installed version to the fix pack level, and your platform, and then click Continue. 2. Select APAR or SPR, enter JR56556, and click Continue. For IBM BPM V8.5.7, determine whether the cumulative fix is available by completing the following steps on Fix Central: 1. On the Select product tab, select WebSphere as the product group, IBM Business Process Manager with your edition from the WebSphere options, All as the installed version, and All as the platform, and then click Continue. 2. In the Text field, enter "cumulative fix", and click Continue. If cumulative fix 2016.12 is available, download and install it. When you download fix packages, ensure that you also download the readme file for each fix. Review each readme file for additional installation instructions and information about the fix.
Temporary fix
Comments
APAR Information
APAR number
JR56556
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-09-02
Closed date
2017-01-19
Last modified date
2017-01-19
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 STANDARD
Fixed component ID
5725C9500
Applicable component levels
R801 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
15 October 2021