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/
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'