Direct link to fix
APAR status
Closed as program error.
Error description
When you use the schema generator of the saved search acceleration tools to create pivot tables, you receive an exception like the following exception: SEVERE: com.lombardisoftware.tools.optimization.search.SchemaGenerator - com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-20521, SQLSTATE=428HV, SQLERRMC=_;7, DRIVER=4.18.60 com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-20521, SQLSTATE=428HV, SQLERRMC=_;7, DRIVER=4.18.60 at com.ibm.db2.jcc.am.kd.a(kd.java:747) 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) at com.ibm.db2.jcc.am.bp.d(bp.java:2776) at com.ibm.db2.jcc.am.bp.b(bp.java:2143) at com.ibm.db2.jcc.t4.bb.i(bb.java:226) at com.ibm.db2.jcc.t4.bb.c(bb.java:48) at com.ibm.db2.jcc.t4.p.b(p.java:38) at com.ibm.db2.jcc.t4.vb.h(vb.java:124) at com.ibm.db2.jcc.am.bp.jb(bp.java:2138) at com.ibm.db2.jcc.am.bp.a(bp.java:3313) at com.ibm.db2.jcc.am.bp.e(bp.java:1108) at com.ibm.db2.jcc.am.bp.execute(bp.java:1087) at com.lombardisoftware.tools.optimization.search.SchemaGenerator.d oSQL(SchemaGenerator.java:146) at com.lombardisoftware.tools.optimization.search.SchemaGenerator.m ain(SchemaGenerator.java:544) SEVERE: com.lombardisoftware.tools.optimization.search.SchemaGenerator - SchemaGenerator FAILED. PRODUCTS AFFECTED IBM Business Process Manager (BPM) Advanced IBM BPM Standard IBM BPM Express
Local fix
Remove leading underscores from the alias of every searchable variable in all of your business process definitions (BPDs) and delete every process instance that was created using these BPDs regardless of its state.
Problem summary
When you apply the search optimization, a table is generated based on the data in the LSW_BPD and LSW_BPD_INSTANCE_VARIABLES tables that holds a column for each variable that is marked 'Visible in Process Portal' in IBM Process Designer. If the alias of one of these variables starts with an underscore, the table creation SQL statement fails.
Problem conclusion
A fix will be available in IBM BPM V8.5.7 cumulative fix 2017.06 that removes leading underscores from variable aliases before creating the SQL statement.
Temporary fix
Comments
APAR Information
APAR number
JR57868
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
2017-05-08
Closed date
2017-05-17
Last modified date
2017-05-17
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
R857 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
17 May 2017