JR44891: CMVC 225239 - GENERATE A VALID PRODUCT LINK IN MARKETING EMAIL

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• In an extended site, create a product in the extended site.
  Create an e-mail template, and include a link to display the
  product.
  
  When sending the e-mail, the marketing e-mail code looks up the
  catalog entry using the SKU (contained in the e-mail:Link tag)
  and a member ID. It is assumed the member ID is the owner of the
  master catalog (which is the owner of the catalog asset store).
  However, in an extended site, if the product is local to the
  extended site, the owner of the product is the owner of the
  extended site. In such situations, the marketing code is unable
  to load the catalog entry and would return null for the image
  path to the product.  An error similar to the following may
  appear in the logs:
  
  
  [11/12/12 6:00:06:856 PST] 00000549 SystemErr     R
  javax.ejb.ObjectNotFoundException
  [11/12/12 6:00:06:911 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.datatype.AbstractFinderResult.myHydrateCachedFi
  nderException(AbstractFinderResult.java:452)
  [11/12/12 6:00:06:912 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.datatype.AbstractFinderResult.throwUseableExcep
  tion(AbstractFinderResult.java:739)
  [11/12/12 6:00:06:913 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.datatype.CacheableFinderResult.generateFinderRe
  sult(CacheableFinderResult.java:248)
  [11/12/12 6:00:06:914 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.dynacache.commands.AbstractFinderResultCache.my
  InvokeFinder(AbstractFinderResultCache.java:1331)
  [11/12/12 6:00:06:914 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.dynacache.commands.AbstractFinderResultCache.in
  vokeFinder(AbstractFinderResultCache.java:987)
  [11/12/12 6:00:06:915 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.catalog.objsrc.CatalogEntryCache.invokeFinder(C
  atalogEntryCache.java:2165)
  [11/12/12 6:00:06:915 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.catalog.objsrc.CatalogEntryCache.myFindByMember
  IdAndSKUNumber(CatalogEntryCache.java:1556)
  [11/12/12 6:00:06:918 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.catalog.objsrc.CatalogEntryCache.findByMemberId
  AndSKUNumber(CatalogEntryCache.java:1535)
  [11/12/12 6:00:06:918 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.emarketing.emailtemplate.tag.TagLinkBase.getPro
  ductImagePath(TagLinkBase.java:354)
  [11/12/12 6:00:06:919 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.emarketing.emailtemplate.tag.TagLink.getDisplay
  ProductLinkValue(TagLink.java:154)
  [11/12/12 6:00:06:919 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.emarketing.emailtemplate.tag.TagLink.getTagValu
  e(TagLink.java:76)
  [11/12/12 6:00:06:919 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.emarketing.emailtemplate.tag.TagEngineImpl.pars
  e(TagEngineImpl.java:234)
  [11/12/12 6:00:06:921 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.emarketing.emailtemplate.tag.TagEngineImpl.rend
  erEmailContent(TagEngineImpl.java:115)
  [11/12/12 6:00:06:922 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.emarketing.engine.PersonalizedContentManagedEma
  ilContent.getContent(PersonalizedContentManagedEmailContent.java
  :277)
  ..
  ..
  [11/12/12 6:00:06:926 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.emarketing.commands.EmailActivitySendCmdImpl.pe
  rformExecute(EmailActivitySendCmdImpl.java:94)
  [11/12/12 6:00:06:927 PST] 00000549 SystemErr     R    at
  com.ibm.commerce.command.ECCommandTarget.executeCommand(ECComman
  dTarget.java:157)
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on 7.0 using Management Center e-mail
  templates in an extended site
  
  PROBLEM ABSTRACT:
  The product images may be "null" in the marketing e-mail sent
  out by WebSphere Commerce when extended sites are used.
  
  BUSINESS IMPACT:
  Marketing e-mail may not contain product images when extended
  sites are used
  
  RECOMMENDATION:
  

Problem conclusion

• The marketing e-mail code was changed to use a different API
  that finds a catalog entry using the SKU and store ID.
  This API respects the catalog store path, and will find the
  catalog entry in either the extended site or in the catalog
  asset store.
  -------------------------------------------------------------
  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 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