IBM Support

IT23485: IBM STERLING B2B INTEGRATOR OFTP SCHEDULE ADAPTER TAKES OVER 10 MINUTES TO BE ENABLED AFTER STARTING THE APPLICATION

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 there is a very high number of rows in the OFTP_OBJECT
    table with a Status of SCHEDULED, the OFTP Schedule Adapter
    takes a long time to go to the Enabled state.
    
    As a consequence, Business Processes that make calls to the
    OFTP Scheduler Adapter will get errors as the adapter isn't
    available yet for processing.
    
    This behavior has only been noticed with MS SQL Server
    Databases.
    

Local fix

  • RTC -  542589
    
    
    You can avoid the behavior by adding the following line in the
    customer_overrides.properties file:
    
    jdbcService.query.getObserveEntries = SELECT TOP 1000 EVENT_ID,
    STATUS,
    LPC, UPDATE_TIME FROM OFTP_OBJECT WHERE (EXTENSION_POINT &
    ?)<>0 AND
    (EXTENSION_POINT & ?)=0
    
    Important Note: This override is only valid for MS SQL Server
    databases and will cause an SQL error if used for DB2 or Oracle.
    

Problem summary

  • Users Affected:
    All OFTP users
    
    Problem Description:
    OFTP Adapter hangs during startup when there are thousands of
    messages in SCHEDULED Status on the OFTP Message Queue.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    
    A code fix is provided.
    
    Delivered In:
    5020603_6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23485

  • 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

    2017-12-13

  • Closed date

    2018-07-11

  • Last modified date

    2018-07-12

  • 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

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

Document Information

Modified date:
12 July 2018