IBM Support

JR53511: Remove database queries on the table ORDITPROMOCD when it is not used in a customization.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • When a shopping cart is evaluated by the promotion engine, a
    WCSOrder object is constructed. The WCSOrder object represents
    the contents of the shopping cart. During the construction of
    the WCSOrder object by the WCSOrderFactory, a query is performed
     on the ORDITPROMOCD database table to find promotion codes
    associated with individual order items.
    
    However, in the default out of the box behavior, the
    ORDITPROMOCD table is not used.  This table is provided
    exclusively for customization purposes.
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce v7.0 customers who use promotions.
    
    PROBLEM ABSTRACT:
    Remove database queries on the table ORDITPROMOCD when it is not
     used in a customization.
    
    BUSINESS IMPACT:
    Unnecessary queries are executed on the table ORDITPROMOCD.
    
    RECOMMENDATION:
    

Problem conclusion

  • A configuration flag, isTableORDITPROMOCDInUse, is added in the
    promotion component configuration file, wc-admin-component.xml,
    that allows customers to disable the queries on the ORDITPROMOCD
     table when no customizations are using that database table.
    This avoids unnecessary database queries.
    
    <_config:property name="isTableORDITPROMOCDInUse"
    value="false"/>
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR53511

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function

  • Submitted date

    2015-06-03

  • Closed date

    2015-06-19

  • Last modified date

    2015-06-19

  • 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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
11 December 2021