IBM Support

JR52815: EVENT-JOB-THRESHOLD SET TO 0 SHOULD NOT EXECUTE A DATABASE QUERY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Enhance the currently available  show all  button. This
    option currently limits the number of entries, that are
    displayed on the page. It does not limit the resultset queried
    from the database.  E.g when you today specify zero entries to
    be displayed, the page still would not come up because the
    query is still processed and would run into a timeout.
    
      A WTRN00006W is logged along with the accompanying
    [8/3/16 15:17:39:778 CST] 0000004d TimeoutManage I   WTRN0124I:
    When the timeout occurred the thread with which the transaction
    is, or was most recently, associated was Thread[server.startup
    : 2,5,main].
    The
    stack trace of this thread when the timeout occurred was:
     java.net.SocketInputStream.socketRead0(Native Method)
     java.net.SocketInputStream.read(SocketInputStream.java:164)
     java.net.SocketInputStream.read(SocketInputStream.java:134)
    ...
     com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpd
    ate(WSJdbcPreparedStatement.java:1187)
     com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate
    (WSJdbcPreparedStatement.java:804)
     com.lombardisoftware.server.scheduler.BlackoutCalendarUtils$2.e
    xecute(BlackoutCalendarUtils.java:123)
    
    We suggest that when 0 is specified the query is not executed at
    all. This can be implemented and delivered on the maintenance
    stream.
    

Local fix

  • n/a
    

Problem summary

  • A fix that solves this issue will be incorporated into a
    later release.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR52815

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    855

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-03-12

  • Closed date

    2015-08-25

  • Last modified date

    2016-10-19

  • 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

  • R855 PSN

       UP

  • R856 PSN

       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":"855","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
19 October 2016