IBM Support

IT14876: SCHEDULE_BPLINKAGEPURGESERVICE ERROR OCCURS WHEN WF_ID > 2147483647

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

  • The Schedule_BPLinkagePurgeService process is failing when
    WORKFLOW_LINKAGE.ROOT_WF_ID exceeds the maximum integer value
    of 2147483647.  The records are not deleted and the following
    error is found in the system log:
    
    [2016-03-07 05:00:13.862] ERROR WFLinkagePurgeService:Exception
    occured
    while purging.
    [2016-03-07 05:00:13.862] ERROR [1457348413862] For input
    string:
    "2147483778"
    [2016-03-07 05:00:13.862] ERRORDTL [1457348413862]java.lang.
    NumberFormatException: For input string: "2147483778"
            at java.lang.NumberFormatException.forInputString
    (NumberFormatException.java:77)
            at java.lang.Integer.parseInt(Integer.java:507)
            at java.lang.Integer.parseInt(Integer.java:539)
            at
    com.sterlingcommerce.woodstock.services.wflinkagepurge.
    WFLinkagePurgeService.purgeEligibleLinkage(WFLinkagePurgeService
    .java:
    259)
            at
    com.sterlingcommerce.woodstock.services.wflinkagepurge.
    WFLinkagePurgeService.run(WFLinkagePurgeService.java:450)
            at java.lang.Thread.run(Thread.java:795)
    [2016-03-07 05:00:13.862] ERROR 000000000000 GLOBAL_SCOPE
    WFLinkagePurgeService:Exception occured while purging.
    java.lang.NumberFormatException: For input string: "2147483778"
            at java.lang.NumberFormatException.forInputString
    (NumberFormatException.java:77)
            at java.lang.Integer.parseInt(Integer.java:507)
            at java.lang.Integer.parseInt(Integer.java:539)
            at
    com.sterlingcommerce.woodstock.services.wflinkagepurge.
    WFLinkagePurgeService.purgeEligibleLinkage(WFLinkagePurgeService
    .java:
    259)
            at
    com.sterlingcommerce.woodstock.services.wflinkagepurge.
    WFLinkagePurgeService.run(WFLinkagePurgeService.java:450)
            at java.lang.Thread.run(Thread.java:795)
    
    
    The customer queried their WORKFLOW_LINKAGE Table and found the
    following values:
    
    max(ROOT_WF_ID) = 2147483793
    max(P_WF_ID) = 2147484066
    max(C_WF_ID) = 2147484071
    
    This problem was also observed on support instances 5020500_8
    (Oracle), 5020600 (SQL Server) and 5020601 (DB2).
    
    To reproduce the problem, update WORKFLOW_LINKAGE to set
    ROOT_WF_ID equal to 2147484000.  Run
    Schedule_BPLinkagePurgeService.  Observe that Business Process
    Linkage Data Purge Service step reports "Error occured in
    purging process.".  Find "java.lang.NumberFormatException: For
    input string:" error in system log.
    
    Note that problem was a little different in 5020601: The
    Schedule_BPLinkagePurgeService completed successfully and there
    was no error in the system log.  However, the record (with
    ROOT_WF_ID = 2147484000) was still not deleted from the
    WORKFLOW_LINKAGE table.  When I updated the value to "555555"
    and ran Schedule_BPLinkagePurgeService again, it was deleted.
    

Local fix

  • STRRTC - 494732
    PC / PC
    Circumvention:
    
    Run PurgeAll and reset WFUNIQUEID.MAX_VALUE to "1" (one).
    
    Disable Schedule_BPLinakgePurgeService and manually delete all
    rows from WORKFLOW_LINKAGE where ROOT_WF_ID < MIN(WF_ID) from
    ARCHIVE_INFO where GROUP_ID = 1.
    

Problem summary

  • PLATFORMS AFFECTED:
    ALL
    
    
    PROBLEM DESCRIPTION:
    Schedule_BPLinkagePurgeService error occurs when WF_ID >
    2147483647.
    The Schedule_BPLinkagePurgeService process fails when
    WORKFLOW_LINKAGE.ROOT_WF_ID exceeds the maximum value of
    2147483647
    
    
    USERS AFFECTED:
    ALL
    

Problem conclusion

  • A code fix is provided.
    The fix removes the parent child BP linkage when the WF_ID is
    greater than 2147483647.
    
    
    DELIVERED IN:
    5020500_13
    5020603
    5020601_7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT14876

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    524

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-20

  • Closed date

    2016-05-27

  • Last modified date

    2017-03-08

  • 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

[{"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.4","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
08 March 2017