Direct link to fix
APAR status
Closed as program error.
Error description
If an IBM Business Process Manager (BPM) group named starting with a colon was replicated from a user registry and was removed from that user registry, the following exception might be found in the log files after the IBM BPM server has been restarted: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [update LSW_USR_GRP_XREF set GROUP_STATE = 1 where (GROUP_NAME in (...))] As a result, the group is still visible within IBM BPM, such as in the Process Admin Console. PRODUCTS AFFECTED IBM BPM IBM BPM Standard IBM BPM Advanced IBM BPM Express IBM Business Automation Workflow
Local fix
Problem summary
This issue occurs because the group name is not surrounded by single quotation marks, which results in an syntactically incorrect SQL statement.
Problem conclusion
A fix that generates a syntactically correct SQL statement will be included in upcoming releases of Business Automation Workflow.
Temporary fix
Comments
APAR Information
APAR number
JR61130
Reported component name
BPM
Reported component ID
5737A5700
Reported release
860
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-05-23
Closed date
2019-10-07
Last modified date
2019-10-07
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
Fixed component ID
5737A5700
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFPJS","label":"IBM Business Process Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.6.0.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
14 September 2022