Host name change for email template
If you defined email templates in WebSphere Commerce Version 7.0 and changed your host name during the migration, modify the EMLMSG.JSPPATH column in the migrated database to reflect the newly defined host name.
Assume that the previous host name is
oldhostname.mycompany.com
, and the new
host name is newhostname.mycompany.com
. To reflect the new host name, modify the
EMLMSG.JSPPATH
column
from:http://oldhostname.mycompany.com/webapp/wcs/stores/servlet/
EmailTemplateFFSpecialsDisplayView
to
http://newhostname.mycompany.com/webapp/wcs/stores/servlet/
EmailTemplateFFSpecialsDisplayView
The following example SQL makes this update:
update EMLMSG
set JSPPATH = 'http://newhostname.mycompany.com/webapp/wcs/stores
/servlet/EmailTemplateFFSpecialsDisplayView'
where JSPPATH = 'http://oldhostname.mycompany.com/webapp/wcs/stores
/servlet/EmailTemplateFFSpecialsDisplayView'