IBM Support

JR43051: CMVC 223222 - AVOID PREPROCESS FULLBUILD/DELTA UPDATE CONFLICTS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Procedures/Steps to reproduce problem:
    
    1. Start preprocess- fullbuild
    2. In CMC, change a product. This will cause the
    TI_DELTA_CATENTRY table to be updated
    3. Perform a search on the storefront
    4. Preprocess full build 'completes'
    5. Notice that the temporary tables are blank
    
    Once preprocess completes, customers will run buildindex
    -fullbuild without realizing that the temporary tables are
    empty. The storefront unexpectedly loses all products
    
    Observed Results: automatic delta updates run during a
    preprocess fullbuild. This results in the storefront emptying,
    requiring the customer to rebuild the index yet again
    
    Expected Results: automatic delta updates should not be allowed
    to run during a fullbuild of preprocess
    

Local fix

Problem summary

  • USERS AFFECTED:
    All users
    
    PROBLEM ABSTRACT:
    
    preprocess/buildindex command line scripts conflicts with
    runtime index build process. command line scripts did not check
    if there is a runtime process is doing indexing and did not put
    a lock to prevent runtime to start if the preprocess/buildindex
    started from command line.
    
    BUSINESS IMPACT:
    Storefront lose all products
    
    RECOMMENDATION:
    

Problem conclusion

  • APAR JR43051 changes the behaviour of preprocess, to first check
    if another preprocess is running.
    
    
    -------------------------------------------------------------
    The latest available maintenance information can be obtained
    from the Recommended Fixes for WebSphere Commerce technote:
    http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR43051

  • Reported component name

    WC DEV PRO ED W

  • Reported component ID

    5724I4100

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-08

  • Closed date

    2012-09-17

  • Last modified date

    2012-09-17

  • 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

    WC DEV PRO ED W

  • Fixed component ID

    5724I4100

Applicable component levels

  • R700 PSY

       UP

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSCRVD","label":"WebSphere Commerce Developer Professional"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
07 December 2021