IBM Support

JR51278: A unique constraint error may occur when using dataload to creat e a catalog entry and assign attribute values at the same time.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using data load to create a catalog entry and assign
    attribute values to it at the same time, the data load utility
    attempts a create operation on the attribute.  The attempted
    creation of an existing attribute will cause a unique constraint
     error.
    

Local fix

  • Load the attributes and their related values in one dataload
    operation and the catalog entries in a separate dataload
    operation.
    

Problem summary

  • USERS AFFECTED:
    Users who use dataload to load catalog entry and their
    attributes in the same operation.
    
    PROBLEM ABSTRACT:
    A unique constraint error may occur when using dataload to
    create a catalog entry and assign attribute values at the same
    time.
    
    BUSINESS IMPACT:
    Can not load catalog entry and assign attributes and values
    together using one invocation of data load.
    
    RECOMMENDATION:
    

Problem conclusion

  • In most cases, if the primary object being loaded is new, the
    child objects are also new.  The utility's original design used
    this type of relationship.  This led to better performance of
    the utility by assuming the same operation at all levels
    (insert/update/delete)
    
    Attribute Dictionary attributes operate on a shared model, so
    the child objects might not be new.
    
    A new method, setBaseTableObjectEnabled(boolean enabled), is
    added to the dataload framework to allow the mediator to have
    more control over the operation for child objects.  The catalog
    entry mediator is also updated to take advantage of this new
    capability.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR51278

  • 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

    2014-09-17

  • Closed date

    2014-12-22

  • Last modified date

    2014-12-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

    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