IBM Support

JR53118: OUT-OF-RANGE DATE IN TRACKED FIELD CAUSES RECORDS TO ACCUMULATE IN THE LSW_PERF_DATA_TRANSFER TABLE OF THE IBM BPM DATABASE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a date is received that is out of the acceptable range for
    the database (that is, before the year 1753 for SQL Server), the
    records in the LSW_PERF_DATA_TRANSFER table of the IBM BPM
    database cannot move to the Performance Data Warehouse database.
    
    PRODUCTS AFFECTED
    IBM Business Process Manager (BPM) Advanced
    IBM BPM Standard
    IBM BPM Express
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    io
    
    
    
    il
    
    
    
    va
    
    
    po
    
    6)
    
    
    
    
    
    
    
    
    se
    
    
    
    SQ
    

Local fix

Problem summary

  • The problem occurs because the validation code incorrectly
    validates the out-of-range date. As a result, an SQL error
    occurs while attempting to insert the date into the Performance
    Data Warehouse database. The record is never moved to the
    LSW_DATA_TRANSFER_ERRORS table of the Performance Data Warehouse
     database.
    

Problem conclusion

  • A fix is available for IBM BPM V8.0.1.1 that ensures
    out-of-range dates fail validation and are properly moved to the
     LSW_DATA_TRANSFER_ERRORS table of the Performance Data
    Warehouse database.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR53118:
    
    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 JR53118, 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

Comments

APAR Information

  • APAR number

    JR53118

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-04-15

  • Closed date

    2015-05-22

  • Last modified date

    2015-05-22

  • 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 ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
22 May 2015