IBM Support

JR54402: Using Dataload to reload searchable attributes might produce a unique index violation after installation of JR52361 and JR53333

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • For searchable attribute data that existed before Dataload APARs
    JR52361 and JR53333 were applied, the primary key was generated
     by the key manager.
    
    In Management Center (CMC), the primary key is mapped to the
    negative value of the attribute ID. APAR JR52361 synchronized
    Dataload behavior with CMC. However, data created before the
    APAR might cause Dataload to throw an exception if it gets
    reloaded.
    
    As the primary key of the searchable attribute is not used in
    business logic, the original behavior of retrieving the primary
    key from the key manager is restored in the APAR.
    

Local fix

  • Do not use Dataload to change or reload searchable attribute
    data that are created before JR52361 and JR53333. Instead,
    manually update them through Commerce Management Center.
    

Problem summary

  • USERS AFFECTED:
    V7 fixpack 6 and FEP5; V7 fixpack 7 and FEP6; V7 fixpack 8 and
    FEP7; V7 fixpack 9 and FEP8.
    
    PROBLEM ABSTRACT:
    Using Dataload to reload searchable attributes might produce a
    unique index violation after installation of JR52361 and JR53333
    
    BUSINESS IMPACT:
    Dataload utility might throw exception when reloading searchable
     attribute data that are created before JR52361 and JR53333.
    
    RECOMMENDATION:
    

Problem conclusion

  • Restored the original behavior of Dataload obtaining the primary
     key of the searchable attribute from the keys manager.
    
    Note that the primary key assignment of the searchable attribute
     are different between Dataload behavior and CMC behavior.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR54402

  • 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

    2015-09-29

  • Closed date

    2015-12-17

  • Last modified date

    2015-12-21

  • 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