IBM Support

IT11319: INDEX BUSINESS PROCESS SERVICE SOMETIMES SETS THE LIFESPAN WRONG FOR BUSINESS PROCESSES

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • On occasion, the Index Business Process service
    calculates the lifepsan of processes
    incorrectly and allows mailbox message payloads to be deleted
    early.
    

Local fix

  • STRRTC - 477277
    JPM/JPM
    

Problem summary

  • Users Affected:
    5.2.5 and 5.2.6 users only.
    
    Problem Summary:
    On occasion, the Index Business Process service calculates the
    lifespan of processes incorrectly and allows mailbox message
    payloads to be deleted early.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix has been provided.
    
    Delivered In:
    5020500_9
    5020601
    

Temporary fix

  • For 5.2.5 versions, add the following to your
    customer_overrides.properties file:
    jdbcService.query.calcDocumentLifespanSql1=INSERT INTO
    BPMV_LS_WRK (WORKFLOW_ID, LIFESPAN) SELECT DL1.WORKFLOW_ID,
    MAX(DL1.LIFE_SPAN) FROM (SELECT DL.WORKFLOW_ID,
    MAX(DL.LIFE_SPAN) LIFE_SPAN FROM DOCUMENT_LIFESPAN DL,
    BPMV_LS_WRK2 W where DL.WORKFLOW_ID = W.WORKFLOW_ID GROUP by
    DL.WORKFLOW_ID UNION SELECT DL.WORKFLOW_ID, MAX(DL.LIFE_SPAN)
    LIFE_SPAN FROM DOCUMENT_LIFESPAN DL, BPMV_LS_WRK2 W where
    DL.DOC_ID = W.DOC_ID GROUP by DL.WORKFLOW_ID) DL1 GROUP BY
    DL1.WORKFLOW_ID UNION SELECT W1.WORKFLOW_ID, MAX(W1.LIFE_SPAN)
    FROM (SELECT W.WORKFLOW_ID, MAX(DL.LIFE_SPAN) LIFE_SPAN FROM
    DOCUMENT_LIFESPAN DL, BPMV_LS_WRK2 W where DL.WORKFLOW_ID =
    W.WORKFLOW_ID GROUP by W.WORKFLOW_ID UNION SELECT W.WORKFLOW_ID,
    MAX(DL.LIFE_SPAN) LIFE_SPAN FROM DOCUMENT_LIFESPAN DL,
    BPMV_LS_WRK2 W where DL.DOC_ID = W.DOC_ID GROUP by
    W.WORKFLOW_ID) W1 GROUP BY W1.WORKFLOW_ID
    
    For 5.2.6 versions, add the following to your
    customer_overrides.properties file:
    jdbcService.query.calcDocumentLifespanSql1=INSERT INTO
    BPMV_LS_WRK (WORKFLOW_ID, LIFESPAN) SELECT F.WORKFLOW_ID,
    MAX(F.LS) FROM (SELECT DL1.WORKFLOW_ID, MAX(DL1.LIFE_SPAN) LS
    FROM (SELECT DL.WORKFLOW_ID, MAX(DL.LIFE_SPAN) LIFE_SPAN FROM
    DOCUMENT_LIFESPAN DL, BPMV_LS_WRK2 W where DL.WORKFLOW_ID =
    W.WORKFLOW_ID GROUP by DL.WORKFLOW_ID UNION SELECT
    DL.WORKFLOW_ID, MAX(DL.LIFE_SPAN) LIFE_SPAN FROM
    DOCUMENT_LIFESPAN DL, BPMV_LS_WRK2 W where DL.DOC_ID = W.DOC_ID
    GROUP by DL.WORKFLOW_ID) DL1 GROUP BY DL1.WORKFLOW_ID UNION
    SELECT W1.WORKFLOW_ID, MAX(W1.LIFE_SPAN) LS FROM (SELECT
    W.WORKFLOW_ID, MAX(DL.LIFE_SPAN) LIFE_SPAN FROM
    DOCUMENT_LIFESPAN DL, BPMV_LS_WRK2 W where DL.WORKFLOW_ID =
    W.WORKFLOW_ID GROUP by W.WORKFLOW_ID UNION SELECT W.WORKFLOW_ID,
    MAX(DL.LIFE_SPAN) LIFE_SPAN FROM DOCUMENT_LIFESPAN DL,
    BPMV_LS_WRK2 W where DL.DOC_ID = W.DOC_ID GROUP by
    W.WORKFLOW_ID) W1 GROUP BY W1.WORKFLOW_ID) F GROUP BY
    F.WORKFLOW_ID
    

Comments

APAR Information

  • APAR number

    IT11319

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    525

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-09-18

  • Closed date

    2015-10-06

  • Last modified date

    2015-12-09

  • 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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

  • R525 PSY

       UP

  • R526 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
09 December 2015