IBM Support

IT33280: DOC_NURSERY_LIFESPAN RECORDS ARE BEING ORPHANED IN THE DOCUMENT_LIFESPAN TABLE WHEN LISTSTAGEDDOCUMENTS=TRUE

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

  • Make sure that sftp.listStagedDocuments=true in the
    customer_overrides.properties.
    
    Open two SFTP Sessions to the
    same mailbox in B2Bi using the same User Account.
    
    
    With the first Winscp SFTP Session upload a
    large file maybe over 1gb so you have time to run the test.
    Then while the upload is ongoing start uploading the same
    document with the other Winscp SFTP session. You will be
    prompted to resume the file upload. Answer yes to resume.
    Once
    the resume starts in the second session open Windows Task
    Manager and End the Task on the still active first SFTP
    Session.
    Then let the second SFTP Session completely upload the
    file.
    
    Once finished you can run the following query and find
    the orphaned document in the document_lifespan table.
    
    select *
    from DOCUMENT_LIFESPAN where USER_KEY ='DOC_NURSERY_LIFESPAN'
    and DOC_ID not in (select DOCUMENT_ID from
    DOCUMENT_NURSERY)
    
    You will see that the DOCUMENT_LIFESPAN
    record will have a LIFE_SPAN = 5256000 which will not allow
    associateBpToDocs to pick up this document and purge it from
    the system.
    
    There is not any mechanism that will clean out these
    orphaned record.
    For Linux, use run control_extpurge.sh script and make sure that
     above created orphan records in DOCUMENT_LIFESPAN table are
    removed.
    For Windows, use startExternalPurgeWindowsService.cmdand make
    sure that above created orphan records in DOCUMENT_LIFESPAN
    table are removed.
    

Local fix

  • STRRTC - L3REQ-188
    JN / JN
    Circumvention: None / workaround
    

Problem summary

  • Users Affected:
    
    All
    
    
    
    Problem Description:
    
    DOC_NURSERY_LIFESPAN records are being orphaned in the
    DOCUMENT_LIFESPAN table when listStagedDocuments=truePlatforms.
    
    
    
    Platforms Affected:
    
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix is provided.
    Fix has been made in control_extpurge script such that by
    running control_extpurge script, it will remove/delete the
    orphan records of DOCUMENT_LIFESPAN table with user key
    DOC_NURSERY_LIFESPAN and not having an entry in DOCUMENT_NURSERY
    table.
    
    
    
    Delivered in:
    
    5020603_16
    5020605_4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT33280

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    526

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-06-22

  • Closed date

    2021-04-08

  • Last modified date

    2021-05-21

  • 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

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

Document Information

Modified date:
22 May 2021