JR46007: CMVC 227187 - SMTP CONNECTION FOR EMAIL ACTIVITY FROM MARKETING LOGIC

7.0.0-WS-WCServer-FP009
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

• The Marketing runtime runs the CheckForBouncedEmail scheduled
  job to detect sent e-mail that has bounced. The information is
  recorded in the EMLBOUNCED and EMLBADADDR database tables. These
  tables are not being populated, or are not populated correctly.
  In addition, some SMTP servers require a SSL connection. The
  Marketing Email Activity Account Configuration does not allow
  for SSL connections.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 using Marketing to send e-mail
  
  PROBLEM ABSTRACT:
  Bounced e-mails are not recorded in the database for marketing
  dialog and e-mail activities. Marketing Email Activity Account
  Configuration does not allow for SSL connections.
  
  BUSINESS IMPACT:
  Bounced e-mail reports are inaccurate. Unable to use a SMTP
  server that requires SSL connections.
  
  
  RECOMMENDATION:
  

Problem conclusion

• The CheckForBouncedEmail scheduled job was fixed to properly
  read bounced e-mail messages from the SMTP server, and record
  the information in the EMLBOUNCED and EMLBADADDR database
  tables.
  
  A new configuration property can be set to indicate that SSL
  should be used when making connections to the SMTP server.
  
  To use SSL when making connections to the SMTP server, perform
  the following configuration:
  
  1. Create a com.ibm.commerce.marketing-ext folder for a
  customized marketing component configuration file at the
  following path:
  <WC_eardir>\xml\config\com.ibm.commerce.marketing-ext\ If this
  directory already exists, proceed to step 2.
  
  2. Open the file wc-admin-component.xml file in the
  <WC_eardir>\xml\config\com.ibm.commerce.marketing-ext\ folder.
  If this file does not exist, then create one with the following
  contents:
  <_config:DeploymentConfiguration
  
  xmlns:_config="http://www.ibm.com/xmlns/prod/commerce/foundation
  /config"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  
  xsi:schemaLocation="http://www.ibm.com/xmlns/prod/commerce/found
  ation/config ../xsd/wc-admin-component.xsd">
  
    <_config:extendedconfiguration>
      <_config:configgrouping name="MarketingRuntime">
      </_config:configgrouping>
    </_config:extendedconfiguration>
  
  </_config:DeploymentConfiguration>
  
  3. Add the following to the wc-admin-component.xml file within
  the <_config:configgrouping name="MarketingRuntime"> section:
  
  <_config:property name="useSSLForSMTPAuthentication-<storeID>"
  value="true"/>
  
  where <storeID> is the ID of the store.
  
  For example, to use SSL connections for store 10001:
  
  <_config:property name="useSSLForSMTPAuthentication-10001"
  value="true"/>
  
  4. Save the file, and restart the server.
  
  -------------------------------------------------------------
  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