Direct links to fixes
APAR status
Closed as program error.
Error description
IBM Business Process Manager (BPM) has a daemon and an administrative script function that you use to clean up unused staff query instance data from the product database, either periodically or manually. In an IBM BPM environment with Oracle database, the procedure might fail and you might see an SQL error similar to this one: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
Local fix
To circumvent the problem, you can disable the daemon, which temporarily prevents the function to cleanup of unused query results. To disable the daemon, set the value to DURATION_INFINITE. This change applies to cleaning up both shared work items and unused cached people query results. For more information, see "Cleanup procedures for Business Process Choreographer" at http://www.ibm.com/support/knowledgecenter/SSFTDH_8.5.7/com.ibm. wbpm.bpc.doc/topics/c2_cleanup.html.
Problem summary
No additional information is available. PRODUCTS AFFECTED IBM BPM Advanced
Problem conclusion
A fix will be included in IBM BPM V8.5.7 cumulative fix 2016.09 that corrects how the SQL statement is generated. To determine whether the cumulative fix is available and download it if it is, complete the following steps on Fix Central (http://www.ibm.com/support/fixcentral): 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.
Temporary fix
Comments
APAR Information
APAR number
JR56439
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
2016-08-04
Closed date
2016-08-19
Last modified date
2016-08-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 ADVANCED
Fixed component ID
5725C9400
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
04 September 2023