IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR57353

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    857

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-02-01

  • Closed date

    2017-02-13

  • Last modified date

    2017-02-13

  • 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":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
13 February 2017