JR57353: PROCESS INSTANCES THAT HAVE A VARIABLE OF BASE DATA TYPE "SELECTION" MEETING THE SEARCH CONDITION ARE NOT RETURNED

bpm.8570.cf2017.03.delta.repository
Downloading IBM Business Process Manager V8.5.7 Cumulative Fix 2017.03

APAR status

• Closed as program error.

Error description

• The process search query does not find process instances that
  have a variable with the base data type "selection" and that
  meet the search condition that is applied to the variable of
  base data type "selection" even if the variable is searchable.
  When you implemented pivot tables to optimize the process
  search, the variable value is not persisted and you see the
  following exception:
  
  [1/30/17 17:23:12:385 CET] 00000116 BPDInstanceDA E
  [jcc][10143][10845][4.21.29] Invalid parameter 10: Parameter is
  not set nor registered. ERRORCODE=-4461, SQLSTATE=42815
  
  com.ibm.db2.jcc.am.SqlSyntaxErrorException:
  [jcc][10143][10845][4.21.29] Invalid parameter 10: Parameter is
  not set nor registered. ERRORCODE=-4461, SQLSTATE=42815
   at com.ibm.db2.jcc.am.kd.a(kd.java:810)
   at com.ibm.db2.jcc.am.kd.a(kd.java:66)
   at com.ibm.db2.jcc.am.kd.a(kd.java:116)
   at com.ibm.db2.jcc.am.tp.Oc(tp.java:6150)
   at com.ibm.db2.jcc.am.tp.a(tp.java:4209)
   at com.ibm.db2.jcc.am.tp.b(tp.java:4173)
   at com.ibm.db2.jcc.am.tp.mc(tp.java:817)
   at com.ibm.db2.jcc.am.tp.executeUpdate(tp.java:791)
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpda
  te(WSJdbcPreparedStatement.java:1187)
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(
  WSJdbcPreparedStatement.java:804)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.insertBDV
  ariablesInPivot(BPDInstanceDAO.java:1525)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.updatePiv
  otTable(BPDInstanceDAO.java:1376)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.saveSearc
  hableValues(BPDInstanceDAO.java:1299)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.createBPD
  Instance(BPDInstanceDAO.java:224)
   at
  com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.doStar
  tBPD(BPDEngineServicesCore.java:599)
   at
  com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.startB
  PD(BPDEngineServicesCore.java:275)
   at
  com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.startB
  PD(BPDEngineServicesCore.java:260)
   at
  com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.startB
  PD(BPDEngineServicesCore.java:255)
  

Local fix

Problem summary

• No additional information is available.
  
  Behavior change:
  With the fix installed, the process search query engine also
  retrieves process instances when a search condition has been
  applied to a process variable of base data type "selection",
  provided that the condition is met.
  
  
  PRODUCTS AFFECTED
  IBM BPM Advanced
  IBM BPM Standard
  IBM BPM Express
  

Problem conclusion

• A fix will be available in IBM BPM V8.5.7 cumulative fix 2017.03
  that ensures process instances that have variables of base data
  type "selection" are returned in searches.
  

Temporary fix

Comments

APAR Information

• 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