APAR status
Closed as program error.
Error description
BPM Advanced 7.5.1 ( z Linux) DB2 Z/OS 10 Following the upgrade of BPM Advanced 7.5.0.1 to BPM Advanced 7.5.1 the following error is thrown when a user logs in to ProcessAdmin and goes to the "Process Inspector" tab. bad SQL grammar [select count (distinct instanceId) from (select i.bpd_instance_id as instanceId from lsw_task t inner join lsw_bpd_instance i on t.bpd_instance_id = i.bpd_instance_id left join lsw_bpd_status_codes istatus on i.execution_status = istatus.status_id where ( ( i.last_modified_datetime > to_date ('2011-12-06 17:00:00', 'YYYY-MM-DD HH24:MI:SS') AND istatus.name = 'Completed' ) ) union all select i.bpd_instance_id as instanceId from lsw_task t inner join lsw_bpd_instance i on t.bpd_instance_id = i.bpd_instance_id left join lsw_bpd_status_codes istatus on i.execution_status = istatus.status_id where ( ( i.last_modified_datetime > to_date ('2011-12-06 17:00:00', 'YYYY-MM-DD HH24:MI:SS') AND istatus.name = 'Terminated' ) ) ) ]; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=<EMPTY>; CORRELATION NAME, DRIVER=3.62.56 com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=- 104, SQLSTATE=42601, SQLERRMC=<EMPTY>;CORRELATION NAME, DRIVER=3.62.56 Upon tracing the jdbc/TeamWorksDB data source (attached: pstrace_xads_5) it can be seen that the sql statement that is being executed does not have a CORRELATION NAME. When the statement is executed outside of BPM and a CORRELATION NAME is added to the end of the statement (as acti) it executes without issue. When a similiar trace is executed in a DIFFERENT 7.5.1 environment (that has a distributed DB2 instead of DB2 Z/OS) the issue does not occur and the statement that is executed has "as acti" on the end. It seems that the SQL statement is being incorrectly built for DB2 ZOS. We have also tried this in a DB2 Z/OS 9 environment, and the issue occurs there also.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of BPM on DB2 z/OS * **************************************************************** * PROBLEM DESCRIPTION: Following the upgrade of BPM Advanced * * 7.5.0.1 to BPM Advanced * * 7.5.1 error is thrown * * when a user logs in to ProcessAdmin * * and goes to the "Process Inspector" * * tab. * **************************************************************** * RECOMMENDATION: Install ifix if using DB2 z/OS * **************************************************************** Following the upgrade of BPM Advanced 7.5.0.1 to BPM Advanced 7.5.1 error is thrown when a user logs in to ProcessAdmin and goes to the "Process Inspector" tab. com.ibm.websphere.ce.cm.StaleConnectionException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=<EMPTY>; CORRELATION NAME, DRIVER=3.62.56 com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=- 104, SQLSTATE=42601, SQLERRMC=<EMPTY>;CORRELATION NAME, DRIVER=3.62.56
Problem conclusion
The fix is available as a part of the JR42012 ifix package (http://www-01.ibm.com/support/docview.wss?uid=swg1JR42012) and needs to be installed as follows: - Install JR42012 on both Process Designer and Process Center/Server using IM - On Process Center/Server run bpmprofileUpgrade as outlined in http://www-01.ibm.com/support/docview.wss?uid=swg27022245#recove rFailure
Temporary fix
Comments
APAR Information
APAR number
JR41469
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
750
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-12-13
Closed date
2012-01-16
Last modified date
2012-04-18
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
R750 PSY
UP
R751 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":"7.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
18 April 2012