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