IBM Support

JR50193: AFTER YOU APPLY APAR JR49638, A NULLPOINTEREXCEPTION OR AN SQLSYNTAXERROREXCEPTION MIGHT OCCUR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When you install the APAR JR49638 interim fix, two exceptions
    could occur when you use Pivot tables:
    
    - A NullPointerException could occur when null data is inserted
      into the Pivot table.
    - An SQLException could occur when business data is updated in
      the Pivot table that indicates that the number of parameters
      used by the SQL statement is not correct.
    
    [5/1/14 13:08:28:790 CST] 0000036e wle           E   CWLLG0323E:
    An exception occurred in saveSearchableValues,
      reason:java.lang.NullPointerException.java.lang.
      NullPointerException
    at com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.
      insertBDVariablesInPivot(BPDInstanceDAO.java:1340)
    at com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.
      updatePivotTable(BPDInstanceDAO.java:1210)
    at com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.
      saveSearchableValues(BPDInstanceDAO.java:1137)
    at com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.
      createBPDInstance(BPDInstanceDAO.java:186)
    at com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.
      doStartBPD(BPDEngineServicesCore.java:564)
    at com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.
      startBPDWithMessageEvent(BPDEngineServicesCore.java:311)
    at com.lombardisoftware.bpd.runtime.engine.message.
      BPDMessageEventHelper.startBPDInstances
      (BPDMessageEventHelper.java:271)
    at com.lombardisoftware.bpd.runtime.engine.message.
      BPDMessageEventHelper.messageReceived
      (BPDMessageEventHelper.java:162)
    at com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.
      messageArrived(BPDEngineServicesCore.java:971)
    at sun.reflect.NativeMethodAccessorImpl.invoke0
      (NativeMethod)
    at sun.reflect.NativeMethodAccessorImpl.invoke
      (NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke
      (DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    
    
    [4/30/14 15:50:36:948 CDT] 00000151 wle           E
    
    com.ibm.db2.jcc.am.SqlSyntaxErrorException:
    [jcc][10143][10845][4.11.69] Invalid parameter 6: Parameter is
    not set nor registered. ERRORCODE=-4461, SQLSTATE=42815
        at com.ibm.db2.jcc.am.gd.a(gd.java:676)
        at com.ibm.db2.jcc.am.gd.a(gd.java:60)
        at com.ibm.db2.jcc.am.gd.a(gd.java:103)
        at com.ibm.db2.jcc.am.kn.Gc(kn.java:5089)
        at com.ibm.db2.jcc.am.kn.b(kn.java:3531)
        at com.ibm.db2.jcc.am.kn.gc(kn.java:743)
        at com.ibm.db2.jcc.am.kn.executeUpdate(kn.java:722)
        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.
          pmiExecuteUpdate(WSJdbcPreparedStatement.java:1187)
        at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.
          executeUpdate(WSJdbcPreparedStatement.java:804)
        at com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.
          insertBDVariablesInPivot(BPDInstanceDAO.java:1352)
        at com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.
          updatePivotTable(BPDInstanceDAO.java:1210)
        at com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.
          saveSearchableValues(BPDInstanceDAO.java:1137)
        at com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.
          createBPDInstance(BPDInstanceDAO.java:186)
        at com.lombardisoftware.server.ejb.bpd.
          BPDEngineServicesCore.doStartBPD
          (BPDEngineServicesCore.java:564)
        at com.lombardisoftware.server.ejb.bpd.
          BPDEngineServicesCore.startBPDWithMessageEvent
          (BPDEngineServicesCore.java:311)
        at com.lombardisoftware.bpd.runtime.engine.message.
          BPDMessageEventHelper.startBPDInstances
          (BPDMessageEventHelper.java:271)
        at com.lombardisoftware.bpd.runtime.engine.message.
          BPDMessageEventHelper.messageReceived
          (BPDMessageEventHelper.java:162)
        at com.lombardisoftware.server.ejb.bpd.
          BPDEngineServicesCore.messageArrived
          (BPDEngineServicesCore.java:971)
        at sun.reflect.NativeMethodAccessorImpl.invoke0
          (NativeMethod)
        at sun.reflect.NativeMethodAccessorImpl.invoke
          (NativeMethodAccessorImpl.java:60)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke
          (DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
    

Local fix

Problem summary

  • APAR JR49638 does not check for null scenarios. As a result, the
    number of parameters that the SQL statement uses to update the
    Pivot tables is incorrect.
    

Problem conclusion

  • A fix is available for IBM BPM V8.5.0.0 that ensures that null
    values are handled correctly and that the correct number of
    parameters is used for SQL statements.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR50193:
    
    1. Select IBM Business Process Manager with your edition from
      the product selector, the installed version to the fix pack
      level, and your platform, and then click Continue.
    
    2. Select APAR or SPR, enter JR50193, and click Continue.
    
    When you download fix packages, ensure that you also download
    the readme file for each fix. Review each readme file for
    additional installation instructions and information about the
    fix.
    

Temporary fix

  • Not applicable
    

Comments

APAR Information

  • APAR number

    JR50193

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-09

  • Closed date

    2015-06-02

  • Last modified date

    2015-06-02

  • 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

  • R850 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
14 October 2021