A fix is available
APAR status
Closed as program error.
Error description
The first time you start the deployment manager after applying the IBM Business Process Manager (BPM) V8.5.6.0 cumulative fix 1, the server does not start and SQLCODE=-952 database errors like the following errors are logged in the <profile_root>/logs/BPMUpdateSystemApp*.log file: org.springframework.dao.TransientDataAccessResourceException:Sta tementCallback; SQL [ DELETE FROM BPM_COACH_VIEW_CONFIG_OPTION WHERE VERSION_ID NOT IN(SELECT PO_VERSION_ID FROM LSW_PO_VERSIONS WHERE PO_TYPE = 66)]; DB2 SQL Error: SQLCODE=-952, SQLSTATE=57014,SQLERRMC=null, DRIVER=4.18.60; nested exception iscom.ibm.db2.jcc.am.SqlTimeoutException: DB2 SQL Error: SQLCODE=-952,SQLSTATE=57014, SQLERRMC=null, DRIVER=4.18.60 at org.springframework.jdbc.support.SQLExceptionSubclassTranslator. translate(SQLExceptionSubclassTranslator.java:58) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTransla tor.translate(SQLErrorCodeSQLExceptionTranslator.java:237)... Caused by: com.ibm.db2.jcc.am.SqlTimeoutException: DB2 SQL Error:SQLCODE=-952, SQLSTATE=57014, SQLERRMC=null, DRIVER=4.18.60 at com.ibm.db2.jcc.am.kd.a(kd.java:749)at com.ibm.db2.jcc.am.kd.a(kd.java:66) at com.ibm.db2.jcc.am.kd.a(kd.java:135)at com.ibm.db2.jcc.am.bp.c(bp.java:2788)... PRODUCTS AFFECTED IBM BPM Advanced IBM BPM Standard IBM BPM Express
Local fix
N/A
Problem summary
If you have many entries in the LSW_PO_VERSIONS table of the IBM Process Server database, a value that is too small for the Java maximum heap size is set when the BPMUpdateSystemApp admin command runs to update the IBM BPM toolkits and process applications.
Problem conclusion
A fix will be incorporated into an IBM BPM V8.5.6.0 cumulative fix that increases the Java maximum heap size for running the BPMUpdateSystemApp admin command. NOTE: This fix might not work all your DEs. A fix that applies to all DEs will be available later.
Temporary fix
Comments
APAR Information
APAR number
JR54815
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
856
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-11-26
Closed date
2015-12-15
Last modified date
2015-12-15
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
R856 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"856","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
13 October 2021