Host name change for e-mail template
If you have defined e-mail templates in WebSphere Commerce Version 5.6.1 or Version 6 and if you have changed your host name during the migration, you must manually 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'