APAR status
Closed as program error.
Error description
If you upgrade to BPM 8.0.1.2 or install IFix JR46470 on top of BPM 8.0.1.1 while using DB2 9.5, a DB2 error "bad SQL grammar" / "SQLCODE=-104, SQLSTATE=42601" will prevent the system from working correctly.
Local fix
n/a.
Problem summary
Upgrading to BPM 8.0.1.2 with DB2 9.5 leads to "BAD SQL GRAMMAR" error in SystemOut.log PROBLEM DETAILED DESCRIPTION: In BPM 8.0.1.2, some queries were restructured. Especially, the query that retrieves alive Event Managers is now done with the 'WITH UR' clause to reduce locking behavior. Unfortunatly, this query is used as a sub query, and 'WITH UR' in sub queries is not supported by DB2 9.5.
Problem conclusion
This IFix introduces code changes that determine whether DB2 9.5 is in use, and if so, the code strips the 'WITH UR' clause from the sub query that retrieves the alive Event Managers. FIX AVAILABILITY: iFix for 8.0.1.1 is/will be available on Fix Central; search for APAR JR48878 at http://www.ibm.com/support/fixcentral/ iFix for 8.0.1.2 is/will be available on Fix Central; search for APAR JR48878 at http://www.ibm.com/support/fixcentral/ Fix is also targetted for inclusion in next fixpack for BPM 8.0.1 When obtaining any of the above fixes, be sure to download the accompanying readme, for itself, and any prerequisite fixes, and review them thorougly.
Temporary fix
Comments
APAR Information
APAR number
JR48878
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-12-19
Closed date
2014-02-19
Last modified date
2014-02-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:
12 October 2021