IBM Support

JR43386: CMVC 223695 - HAVE DI-PREPROCESS CREATE TEMPORARY TABLES IN ALPHABETICAL ORDER OF THE WC-DATAIMPORT-PREPROCESS XML FILES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Di-preprocess does not build the tables in alphabetical order of
    the file names. The temporary tables are built in a random
    order. If creating a custom table that relies on data from
    another temporary table, it is required that this precursor
    temporary table be created first. This is currently not
    manageable if the two temporary tables are created in different
    preprocess files.
    

Local fix

  • By grouping temporary tables together in the same file the order
    can be controlled; placing one temporary table after the other
    will ensure it will be created/populated after the first
    temporary table.
    

Problem summary

  • USERS AFFECTED:
    Users that have created a custom temporary table for use during
    di-preprocess, where that temporary table relies on data from
    another temporary table.
    
    PROBLEM ABSTRACT:
    Di-preprocess builds the temporary tables in a random order,
    This causes problems if custom preprocess tables are created
    that have a dependency on other preprocess tables; a consistent
    order when generating the tables is required. .
    
    BUSINESS IMPACT:
    di-preprocess will not always populate the tables correctly
    
    RECOMMENDATION:
    

Problem conclusion

  • This ifix makes temporary tables be created in alphabetical
    order, according to the file names of the preprocess files.
    
    -------------------------------------------------------------
    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

    JR43386

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-10

  • Closed date

    2012-08-28

  • Last modified date

    2012-08-28

  • 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 BUS EDITION

  • Fixed component ID

    5724I3800

Applicable component levels

  • R700 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
28 August 2012