IBM Support

JR44173: CMVC 224263 - CMVC SKU AUTO GENERATION NOT APPEND LANGUAGE ID IN URL KEYWORD WITH SEO ENABLED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With SEO feature is enabled, if product has the same
    descriptions for multiple languages, the SKU auto generation in
    CMC will fail and throw DB2 duplicated key exception SQL0803N
    when creating SEO friendly URLs for all languages.
    

Local fix

Problem summary

  • USERS AFFECTED:
    Any business user who uses Management Center SKU auto generation
    with SEO enabled and has SKUs with the same name in multiple
    languages.
    
    PROBLEM ABSTRACT:
    If SKUs have the same name in multiple languages then Management
    Center SKU auto generation does not automatically create the SEO
    URL in more than one of those languages for each SKU.
    
    BUSINESS IMPACT:
    Management Center SKU auto generation will not automatically
    create SEO URLs in some cases.
    
    RECOMMENDATION:
    

Problem conclusion

  • When creating a catalog entry, if using the part number and name
    does not form a unique SEO URL then the language ID is appended
    to the end of the SEO URL.
    
    -------------------------------------------------------------
    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

    JR44173

  • Reported component name

    WC BUS DEV ED W

  • Reported component ID

    5724I3900

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-09-24

  • Closed date

    2012-11-26

  • Last modified date

    2012-11-26

  • 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 DEV ED W

  • Fixed component ID

    5724I3900

Applicable component levels

  • R700 PSY

       UP

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer 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:
07 December 2021