IBM Support

IT18261: SCHEDULE_ASSOCIATEBPSTODOCS REMOVES DOCUMENTS THAT ARE STILL REFERENCED IN THE DATA_FLOW TABLE

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

  • When the customer goes into the user interface under "Business
    Process", "Monitor", "Advanced Search" and "Data Flows" some
    data flows appear in the list but you cannot view the detail
    tracking information.
    
    In the ui.log there is:
    
    [2016-10-19 15:51:54.575] ERROR [1476885114575] No document
    with ID =301654157d84d9f46node1
    [2016-10-19 15:51:54.575] ERRORDTL
    [1476885114575]com.sterlingcommerce.woodstock.workflow.DocumentN
    otFoundException: No document with ID = 301654157d84d9f46node1
    
    This occurs when an XML Notification is sent to the HTTP Server
    Adapter to  trigger a business process. The notification
    contains the path and filename of a document that is collected
    using a File System Adapter and placed in a mailbox.
    The Data Flow records in the database have linked the XML
    Notification to the Document collected.
    Once the retention period is reached the XML Notification gets
    removed by the AssociateBpsToDocs process and creates the
    situation.
    

Local fix

  • You can circumvent the behavior by adding the following line in
    the customer_overrides.properties file:
    
    jdbcService.query.getUnassociatedDocsWithDocLifespan.oracle=SELE
    CT distinct D.DOC_ID, D.BODY, D.ENC_IV, D.ENC_KEY, D.ENC_IV,
    D.ENC_KEY FROM DOCUMENT D, DOCUMENT_LIFESPAN DL WHERE
    D.DOC_ID=DL.DOC_ID(+) and not exists (select * from
    document_lifespan dl2 where dl2.doc_id=d.doc_id and
    (dl2.workflow_id > 0 or (D.CREATE_TIME + (DL2.LIFE_SPAN /
    1440)) >= SYSDATE)) AND (D.WORKFLOW_ID=-1 OR D.WORKFLOW_ID=0 OR
    D.WORKFLOW_ID=-2) and ((D.CREATE_TIME + (DL.LIFE_SPAN / 1440))
    < SYSDATE OR dl.DOC_ID IS NULL) and D.CREATE_TIME < ? AND NOT
    EXISTS(SELECT * FROM WORKFLOW_CONTEXT WC WHERE
    WC.DOC_ID=D.DOC_ID) and NOT EXISTS(select * from DATA_FLOW DF
    where DF.ROOT_DOCUMENT=D.DOC_ID)
    
    This wil prevent the AssociateBpsToDocs service to remove any
    documents that are still referenced in the DATA_FLOW table.
    

Problem summary

  • USERS AFFECTED:
    All
    
    PROBLEM DESCRIPTION:
    Schedule_AssociateBpsToDocs prematurely removes documents that
    still have a row in DATA_FLOW table.
    
    PLATFORMS AFFECTED:
    All
    

Problem conclusion

  • RESOLUTION SUMMARY:
    A code fix is provided.
    
    DELIVERED IN:
    5020603_2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT18261

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    525

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-12-06

  • Closed date

    2017-06-07

  • Last modified date

    2017-06-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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

  • 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:
22 June 2017