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/
EmailTemplateFFSpecialsDisplayViewto
http://newhostname.mycompany.com/webapp/wcs/stores/servlet/
EmailTemplateFFSpecialsDisplayViewThe 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'